Business & Analytics — Power BI
Product Sales Analysis Dashboard
An interactive Power BI dashboard analyzing product-level sales, profit, and discount performance across 8 Indian cities, built on 2024 retail transaction data.
01 — The Problem
Business Challenge
The business needed clear visibility into which products, cities, and discount levels were actually driving profit — not just revenue.
02 — The Approach
Methodology
- Built an interactive Power BI dashboard analyzing revenue, profit, discounts, and city-wise sales performance.
- Developed DAX measures for Revenue, Profit, Orders, and Profit Margin.
- Created dynamic visualizations to identify sales trends and category performance.
- Applied business intelligence concepts to support data-driven decision-making.
03 — Business Impact
Key Metrics
₹12,589
Revenue
₹4,229
Profit
33.60%
Profit Margin
8
Cities
50
Orders
Impact Statement
Surfaced city-wise and category-level profit drivers, revealing that Luggage has the strongest margin (39.83%) and one sales rep generates over 25% of total revenue.
04 — Key Insights
Findings
- Accessories leads revenue but Luggage is most profitable at 39.83% margin.
- Lucknow leads both revenue and profit; Bengaluru trails on both.
- Revenue peaks in April and June, with 4x swing between best and worst month.
- Ayesha Khan generated over 25% of total revenue as top performer.
- Average discount is a modest 7.4%.
05 — Tools & Technologies
Tech Stack
Power BIDAXExcelData Analytics