Having moved to Melbourne, I couldn't take part in this year's league, though I'd finished in the top 10 the season before. I built this to stay connected with the competition and follow my friends through the rounds.
Data was extracted from competition results pages and cleaned in Excel using Power Query:
- Removed duplicate entries
- Fixed naming inconsistencies across rounds
- Corrected erroneous data points
The dashboard tracks standings across all 6 locations, with a rankings table showing each climber's total points, category, and location, alongside breakdowns by gender, location, and category.
The model follows Power BI best practices with a dedicated dimDate table and a centralised measure table.