Sales Data Analytics: An Interactive Dashboard to Track and Analyse Online Sales Data
The E-Commerce Sales Dashboard is an interactive Power BI report designed to explore and compare sales performance across 19+ states in India.
This dashboard highlights key insights such as:
- Highest and lowest buyers by state
- Revenue contribution by category and customer
- Payment mode preferences
- Quarterly performance trends
- Give Recommendations to the Richest Buyers
The goal is to provide data-driven strategies to better understand e-commerce sales and support business decision-making.
- Power BI Desktop → Main platform for dashboard creation
- Power Query → Data transformation and cleaning
- DAX (Data Analysis Expressions) → Calculated measures, dynamic visuals, and logic
- Data Modeling → Relationships between tables (e.g., Amount by State, Category, Payment Mode)
- File Formats →
.pbix(Power BI File - Get it in Raw File),.csv(data import - Details, Orders,.pngDashboard Preview & Dashboard background
- Business Problem: Large sales volumes across India, but limited visibility into performance.
- Dashboard Goal: Visualise sales trends, track top customers and categories, analyse quarterly performance, and support forecasting.
- Sales by State → Identifies top-performing states by revenue
- Quantity by Payment Mode → Breaks down payments (EMI, COD, Debit/Credit Cards, UPI, etc.)
- Sales by Customer → Highlights the most profitable customers
- Quantity by Category → Shows best- and worst-performing categories (Furniture, Electricals, Clothing, etc.)
- Quarterly Analysis → Tracks performance across 4 quarters