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.