ProjectsRetail Sales Intelligence Dashboard
Business AnalyticsProgram: Data Analytics Internship
Retail Sales Intelligence Dashboard
Design and deliver an executive sales dashboard analyzing regional revenue, product category margins, customer retention, and store performance.
Power BIPower QueryStar SchemaDAX
Business Scenario
A global retail enterprise needs a consolidated Power BI report to replace fragmented Excel sheets across 4 regional sales divisions. Executive leadership requires real-time insights into quarterly margin fluctuations, top-performing product categories, and regional store performance.
Key Objectives
- 1Clean and transform raw transactional sales data in Power Query.
- 2Design a clean Star Schema dimensional model with FactSales and dimension tables.
- 3Write DAX measures for Total Revenue, Gross Margin %, and YoY Growth.
- 4Create an executive 3-page interactive dashboard with drill-through capability.
Deliverables You Build
Deliverable 1Power Query M transformation script & dataset cleanup log
Deliverable 2Power BI Data Model diagram with 1:Many relationships
Deliverable 3DAX Measure Table (Revenue, Margin %, YoY Growth, YTD Sales)
Deliverable 4Interactive Power BI report file (.pbix) & executive PDF summary