← Back to Projects
Retail Financial Performance Analytics
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.
Ready to learn more about my work?
Explore my background and experience, or get in touch.