Analytics Dashboard — Interactive BI

A full-stack business intelligence dashboard built with Plotly Dash. Visualizes sales performance across products, categories, regions, and time with live filters.

Features

• 6 live KPI cards — revenue, profit, orders, AOV, margin, cancelled
• Revenue & profit trend with dual-axis order volume
• Category, region, day-of-week breakdowns
• Profit margin and AOV analysis
• Monthly revenue heatmap (year × month)
• Top 10 products by revenue
• Recent orders table with status color coding
• All charts update instantly on filter change

Tech Stack

• Python — Dash, Plotly, Pandas
• Data — Exported from SQLite analytics database

Setup

1. Clone repo
2. python -m venv venv → activate
3. pip install -r requirements.txt
4. Place orders.csv in data/
5. python app.py
6. Open http://localhost:8052

Screenshots