Today marks the final day of our Dashboard Week challenge, and what a week it has been! Throughout the week, we have been tasked with creating interactive dashboards using a variety of datasets and tools. We’ve explored data related to Spacex, Superannuation, Melbourne City Open Data, and even the Happiness Index. And now, on our last day, we are turning our attention to the world of motorsport.

The Challenge and my goal

To narrow my focus, I decided to explore who the best driver of all time is by delving into results, drivers, and races tables. As a novice in this field, I turned to ChatGPT for insights on typical metrics used to define a good driver. Armed with this knowledge, I continued my analysis and gained a deeper understanding of what it takes to excel in Formula One.

Dashboarding

my dashboard majorly divided into 3 parts: KPIs, the Top10 Podiums, Win Percentage and Podium Matrix

Here are some possible rewrites of the given KPIs:

  1. Total Race Wins: This metric simply refers to the total number of race wins achieved by drivers in Formula One.
  2. Race Wins by Driver: This metric involves analyzing how many race wins each individual driver has achieved.
  3. Podiums per Race: This metric takes into account the number of podium finishes achieved by drivers in relation to the number of races they have finished. It provides a more complete picture of a driver’s consistency and overall performance.
  4. Win Percentage: This metric calculates the percentage of races won by a driver out of the total number of races they have started. It’s a useful way to compare drivers across different eras, as it accounts for changes in the number of races held per season.
  5. Race Wins by Grid Positions: This metric analyzes the correlation between a driver’s starting grid position and their likelihood of winning the race. If a driver starts in pole position (i.e. the leading or dominant position), it’s considered an advantage that can increase their chances of winning.

As for the Bubble Chart, I planned to answer the question: Which drivers maximized every given racing opportunity and got the most performance out of the car?

  1. X-axis: Podiums finished per race – This axis represents how often a driver finishes on the podium, on average, per race. This is a good measure of consistency and shows how often a driver is able to perform at a high level.
  2. Y-axis: Wins percentage – This axis represents the percentage of races that a driver has won. This is a good measure of overall performance and shows how often a driver is able to finish in first place.
  3. Dot (marker): Each driver – Each dot on the chart represents a driver. The position of the dot on the chart shows the driver’s podium finishes per race (x-axis) and wins percentage (y-axis).
  4. Size: Total wins – The size of the dot represents the total number of wins a driver has. This gives an indication of a driver’s success over time.
  5. Color: Wins percentage by grid position – The color of the dot represents the driver’s win percentage based on their starting position. If they started further back and won the race, their dot would be a different color. This gives an indication of a driver’s ability to move up through the field and win races from different starting positions.

Overall, this chart can be used to compare the performance of different drivers based on their podium finishes, wins percentage, and starting positions. Drivers with larger dots (more wins) that are higher on the chart (more podium finishes and higher win percentage) are generally considered to be better performers. The color of the dots can provide additional insights into a driver’s ability to win races from different starting positions.

Insights

When it comes to analyzing Formula One driver performance based on the given metrics, Lewis Hamilton, Michael Schumacher, and Sebastian Vettel are among the most successful drivers in the sport’s history.

Lewis Hamilton currently holds the record for the highest win percentage (34.97%), with 103 race wins out of 295 starts as of the end of the 2022 season. He has also won 7 championship titles, tying him with Michael Schumacher for the most championships in Formula One history.

Michael Schumacher, on the other hand, holds the record for the most race wins (91), podium finishes (155), and championship titles (7) in Formula One history. His dominance during the early 2000s is still considered one of the greatest periods of success in the sport’s history.

Sebastian Vettel has also achieved impressive results, with 53 race wins, 122 podium finishes, and 4 championship titles to his name. He has demonstrated great consistency throughout his career and has been a consistent threat to win races and championships.

It’s worth mentioning that there are other legendary drivers who achieved great success in the early years of the sport, such as Juan Manuel Fangio. Fangio won 5 championship titles between 1951 and 1957, a record that stood for over 45 years until Schumacher surpassed it in the 2000s. Despite competing in a different era, Fangio’s achievements and legacy continue to inspire modern-day Formula One drivers.

The Data School
Author: The Data School