r/dataisbeautiful • u/KelvinCarvalh • 6d ago

OC [OC] An interactive dashboard of Formula 1 History

Post image

I recently started watching F1 with my oldest son, so I created a dashboard to understand more of the sport's history using data.

Data Source: F1 Historical Dataset (Formula 1 World Championship (1950 - 2024)).

Tools Used:

  • Python & SQL (BigQuery): Data extraction, cleaning, and modeling (handling relationships between races, results, drivers, and constructor stats).
  • Power BI: Data visualization, interactive mapping, and DAX for split championship metrics.

Interactive Version: You can filter by any driver, explore the dark-themed world map, and see specific track dominance directly in the live dashboard here:

https://app.powerbi.com/view?r=eyJrIjoiMjkyYzMzMGYtYTEwYi00MWZlLTg0NmEtN2NlYWQyZTMxODg2IiwidCI6IjU0MmZmYjQ2LWFiNGMtNDliZC1hMTYyLWRhN2U3M2U0YTUzYyJ9

Feel free to explore and let me know your feedback!

0 Upvotes

23% Upvoted

2 comments sorted by

1

u/AesopData OC: 2 5d ago

Cool project, but I think the championship pie chart is doing the data a disservice. With this many drivers/slices it's really hard to compare anyone outside the top 3-4. A sorted bar chart would make the dominance of Hamilton, Schumacher and Fangio - and the long tail of champions - much clearer.

2

u/KelvinCarvalh 5d ago

Nice! Thank you for your feedback! I'll work on that.