An interactive Power BI dashboard designed to analyze and visualize key metrics in e-commerce sales performance. This project provides a comprehensive view of sales trends, customer behavior, and product category performance across different regions and time periods.
📊 Overview
This dashboard enables data-driven decision-making by offering insights into:
- Sales performance across time and geography
- Customer purchasing behavior
- Product category contributions
- Payment method preferences
🚀 Features
- 📈 Sales Metrics: Track total sales amount, quantity sold, and average order value.
- 🕒 Time-Based Analysis: Visualize profit trends across months and quarters.
- 🗺️ Geographic Insights: Analyze sales distribution by Indian states.
- 👥 Customer Insights: Identify top customers by purchase amount.
- 🛍️ Category Breakdown: Understand product category contributions (Clothing, Electronics, Furniture).
- 💳 Payment Preferences: View distribution of payment modes (COD, UPI, Credit/Debit Cards, EMI).
- 🎛️ Interactive Filters: Slicers for time periods (quarters) and other dimensions for dynamic exploration.
🔍 Key Insights
- Top Performing Categories
- Clothing leads with 63% of quantity sold
- Followed by Electronics (21%) and Furniture (17%)
- Regional Sales
- Maharashtra and Delhi are among the top contributing states
- Customer Segmentation
- Key customers like SK, OK, and Madhav drive significant revenue
- Payment Trends
- COD is the most preferred payment method (44%), followed by UPI and Debit Cards
- Profitability Trends
- Monthly profit analysis highlights seasonal performance variations
Files Included
- Details Data / Orders Data
- Dashboard_Screenshots