Full Stack Analytics Dashboard

A production-style business intelligence dashboard built with Flask, SQLite, and Chart.js. Visualizes sales performance across products, categories, regions, and time with live filtering.

Features

• 6 KPI cards — revenue, profit, orders, AOV, customers, margin
• Revenue & profit trend chart (monthly)
• Category and region revenue breakdown
• Daily orders chart (last 30 days)
• Order status distribution
• Top 10 products table with sort and search
• Recent orders feed with status badges
• Date range and quick filter controls

Tech Stack

• Backend: Python, Flask, SQLAlchemy, SQLite
• Frontend: Vanilla JS, Chart.js
• Data: Synthetic dataset — 500 customers, 8,000 orders, 40 products

Setup

1. Clone the repo
2. python -m venv venv then activate
3. pip install -r requirements.txt
4. python seed_db.py — generates the database
5. python app.py
6. Open http://localhost:5005

Screenshots