← Back to Projects
Retail Financial Performance Analytics
Executive Summary
An executive dashboard built in Power BI Desktop from the Sample Superstore dataset, using a star schema with one fact table and four dimension tables, plus DAX time-intelligence measures for year-over-year comparisons.
Dashboard Preview
Use the arrows below the dashboard to navigate: Executive Overview → Sales Overview → Profit Overview → Customer & Product Analysis
Key Findings
- The analysis surfaced a pattern that a simple totals view would have missed: Central region was the only one to decline in two separate years (2015 and 2017), while every other region grew.
- Overall YoY sales growth sits at 46.9%, but that number hides a low-base effect in early years that a naive percentage comparison would have overstated.
- The dashboard runs on a dedicated Calendar table rather than the dataset's native order dates, since SAMEPERIODLASTYEAR requires a contiguous date range. This detail broke the model twice before the underlying date table was fixed.