Donut Shop Interactive Dashboard: Multi-Page by Rozina BegumDonut Shop Interactive Dashboard: Multi-Page by Rozina Begum

Donut Shop Interactive Dashboard: Multi-Page

Portfolio project
Rozina Begum
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...

Tags