Retail analytics2023
Adventure Works Analysis
A business intelligence dashboard turning raw sales data into the few views leadership actually uses.
Power BISQLPython
The challenge
The data existed but answering a straightforward commercial question meant assembling a spreadsheet by hand each time.
- Deliverable
- BI dashboard
- Coverage
- Sales, product, region
- Access
- Self-service
What we did
- 01
Modelled the data
Consolidated sales, product and regional data into one queryable model.
- 02
Built the reporting layer
Dashboards covering performance by product, region and period.
- 03
Designed for self-service
Structured so stakeholders answer their own follow-up questions without a request.