SKI RACE RESULTS
Data CollectionData PreparationDashboard Design
CONTEXT AND OBJECTIVE
Every year during the winter season, several races are organized for young skiers in the Swiss alps. The results for each race are publicly avaible, but there is no way to get a season’s overview for a specific athlete, nor to visualise his or her progression over several competition.
The objective of this project was to focus on two competitions, the Anniviers Cup and the FMV Cup, to collect all results with key metrics for each young athlete.
WHAT WAS DONE
The results of each race was downloaded in the native PDF format and converted into Excel, using OCR for improved reliability. All files were manually processed and merged into a single, consolidated CSV file.
Elo rankings were computed for each race and each skier, as a way to visualize the progressions throughout the season.
A dashboard was designed with Tableau and published on Tableau Public.