An interactive dashboard built using Power BI to analyze e-commerce sales data. The dashboard tracks key metrics like revenue, profit, quantity sold, and customer trends.
- Power BI Desktop
- DAX (for calculations and KPIs)
- Excel (for data preparation)
- GitHub (for version control and showcasing)
- KPI Tiles: Total sales, profit, quantity, AOV
- Filters by Category and Quarter
- Donut Charts for Payment Modes and Categories
- Top Sub-Categories and Customers (Bar Charts)
- Profit by State and Month
- Clothing leads sales volume (62%)
- COD is the top payment method (43.74%)
- December and January have the highest profits
- Uttar Pradesh is the most profitable state