TK
Menu

Data Science / Business Intelligence

Tour de France Dashboard (Power BI)

A Power BI dashboard for the Maven Analytics Tour de France Challenge: 109 editions of winners, stages, speeds and finishers, plus a review that caught two wrong headline cards.

Problem

The Maven Analytics Tour de France Challenge: turn 120 years of race data into a dashboard that tells the story of the race at a glance.

Approach

  • Power Query to clean and join the stage, rider and winner tables.
  • DAX for finisher rates, winner averages and rankings.
  • Line charts of distance against average speed, starters against finishers, stages led and won by country, a rider table, and a decomposition tree of winners by country, team and rider.

Dashboard

Result

  • 109 Tours, a 63% finisher rate, winners averaging 1.78 m and 68.4 kg; races got shorter after the 1920s while average speed kept rising.
  • Review finding: the "youngest winner" card shows Alberto Contador and the "oldest winner" card shows Vincenzo Nibali, but the real answers are Henri Cornet (1904, aged 19) and Firmin Lambot (1922, aged 36). The age measure most likely only covers winners with a birth date in the data; the fix is to calculate age at the race date for every winner and flag missing birth dates.

What this shows

Power BI modelling and visual design, and checking a dashboard's headline numbers against known facts before anyone relies on them.