Welcome to this Power BI tutorial where we explore an interactive Ecommerce Sales Dashboard designed for deep and insightful business analysis.
This dashboard was created using real-world ecommerce data and showcases how to use Power BI to:
- Visualize complex KPIs
- Segment user behavior
- Analyze sales performance across time, location, category, and more
Get the Dataset here : https://www.kaggle.com/datasets/shrishtimanja/ecommerce-dataset-for-data-analysis
🔍 Key Components of the Dashboard
📊 1. Top KPI Cards
At the top, we have Key Performance Indicators (KPIs):
- Num Customers: 29K
- Num Transactions: 54K
- Avg Sales per transaction: ₹3,000
- Total Sales: ₹160.74M
- Avg Discount: ₹136.92
These metrics give you an executive summary at a glance.
🧓👩🦰 2. Total Sales by Age Group
A bar chart showing how different age groups contribute to total sales:
- Highest spenders: 25–45 years
- Lower sales from under 18 and 60+
📅 3. Sales Over Time
The line chart reveals trends in total sales by:
- Year
- Quarter
- Month
You can observe sales growth, seasonality, and spikes across years (2019–2024).
💳 4. Total Sales by Purchase Method
Insights into customer preferences:
- Most used: Credit Card, Debit Card
- Least used: Google Pay, Paytm, and Cash on Delivery
👩🦱🧔 5. Sales by Gender
A pie chart highlighting the gender split:
- Slightly more sales by Females (54%)
🏷️ 6. Discount Analysis
Understand how offering discounts influences total sales:
- Avg Sales for users who availed discounts is ₹3,000
🗺️ 7. Sales by Location
A map visualization shows geographic distribution across India and neighboring countries.
📦 8. Sales by Product Category
A treemap to break down top-selling categories:
- Electronics and Clothing are leading
- Books, Toys, and Sports follow
🎯 Filters / Slicers (on the right):
Allow dynamic filtering by:
- Age Group
- Discount Availed
- Gender
- Location
- Purchase Date (with a date slider)
🏆 Recommended Power BI Course for Beginners
If you’re new to Power BI or want to become a pro in data visualization and business intelligence, we highly recommend this best-selling course:
🔗 Power BI Tutorial for Beginners to Advanced (Udemy)
You’ll learn everything step-by-step — from importing data, transforming it with Power Query, to building professional-level dashboards like this one.