Donut Shop Interactive Dashboard: Multi-Page Streamlit App
What this is
A multi-page business dashboard that shows a donut shop's sales, inventory and staff data in one place, with clear numbers, tables and charts. The data comes live from a PostgreSQL database, so the owner always sees current information without touching spreadsheets or the database.
4 pages, one simple layout
User Guide: explains how to use the dashboard.
Sale & Revenue: top-selling donuts, sales trends, sales by category, and
profit.
Inventory: purchases, stock, and food waste.
Employees Status: staff by shift, age group and role, plus salary figures.
Every page has the same structure. Key numbers (KPIs) sit at the top, with a Tables tab and a Charts tab below, so new users learn the layout once and can use the whole dashboard.
Refresh button for performance
Instead of reloading constantly in the background, each page has a Refresh button. Users load the latest data only when they need it, which keeps the server and the database light and the dashboard fast.
Filters with select boxes
Tables can be filtered with simple select boxes, for example by month or by employee role. Users get just the rows they want without writing any queries.
Export and share
Charts can be saved as an image with one click.
Tables can be downloaded as a CSV file for Excel or reports.
Fast and interactive
Data is loaded from PostgreSQL with ConnectorX and processed with Polars, which stays fast as the data grows. Results are cached, so repeated views load quickly. Charts are made with Plotly, so you can hover over any point to see its exact values.
Tools: Streamlit, Polars, ConnectorX, Plotly, PostgreSQL, Python
0 likes · 0 views · Oct 23, 2026
Donut Shop Interactive Dashboard: Multi-Page Streamlit App What this is A multi-page business dashboard that shows a donut shop's sales, inventory and staff...