A Power BI report for the 2024 Depot Climbing Summer Bouldering Leagues.
Data was extracted from a results page, cleaned, and transformed using Power Query and Excel.
The dashboard provides clear insights into competitors' performances, highlighting my skills in data cleaning and visualization using Excel and Power BI.

Brief:

Since moving to Melbourne, I was unable to participate in this year's Depot Bouldering League - a fantastic event I was sad to miss out on, especially after previously finishing in the top 10. To stay connected with the competition and track my friends' results, I created this dashboard. It allowed me to remain involved and keep up with the event.

Method:

This project is divided into two main parts:
    • Data Extraction and Cleaning:
    • Power BI Dashboard:
Data was scraped from the results website and cleaned using Power Query in Excel. The process included removing duplicate entries, fixing naming mistakes, and correcting erroneous data. The cleaned data was imported into Power BI to create an interactive dashboard. Best practices were followed by implementing a dimDate and measure table. The dashboard tracks standings across 6 locations over 3 rounds, offering clear insights into competitors' performances.