Build a Sales Dashboard with Streamlit
Build a local CSV dashboard with filters, metrics, charts and automated checks.
A focused 6-page practical workbook by Thomas Reid, with a complete Streamlit app, sample sales data, AppTest checks, setup instructions, exercises and worked answers.
Keep revenue, order counts, average order value, charts and downloads on the same filtered dataset. Handle empty results and reversed dates, and test the rendered app. Sample amounts use integer pence and the dataset is small enough to reconcile by hand.
Download: one ZIP containing the PDF, app source, tests, CSV, requirements and README. Tested on Windows with Python 3.13.17, Streamlit 1.46.0 and Pandas 2.2.3. Runs locally; no database account or hosting subscription is included or required for this example.
This is a revised practical edition based on my published Medium article. It adapts the dashboard lesson to a self-contained CSV project and is not a verbatim reprint. Suitable for readers who can run Python scripts.