Nike-themed sales analytics
A relational model and a set of DAX measures over a course dataset, built to answer margin, growth and ranking questions from one model rather than one report per question.
Course project on a Nike-themed dataset, not Nike’s data
- Period
- August to September 2024
- Tools
- SQL, Python, Power BI, DAX
- Context
- Coursework at the University of the Pacific
What it was
A relational model across transactions, products, customers and locations, with DAX measures for margin, growth and ranking built on top of it.
The point of modelling it properly rather than flattening it was that a new question should not require a new extract. Margin by product line, growth by region and rank within a category all resolve against the same model.
What this is not
The dataset is Nike-themed coursework. It is not Nike’s data, this was not work for Nike, and nothing here should be read as a commercial engagement.