End-to-end data analytics project analysing 75 years of Formula 1 race data (1950–2024) to uncover performance patterns across drivers, constructors, and championship competitiveness.
- How does starting grid position translate to race wins across eras?
- Which constructors have the highest mechanical DNF rates?
- Which drivers consistently overperform their grid position?
- How has championship competitiveness changed by decade?
- 79% of all race wins come from the top 3 grid positions
- Pole position converts to victory 42% of the time
- Mercedes leads modern reliability at 90% finish rate
- F1 reliability improved from 42% finish rate (1980) to 89% (2024)
- Lewis Hamilton leads the modern era with 105 wins and 202 podiums
| Layer | Tool |
|---|---|
| Cloud Warehouse | Snowflake |
| SQL Analytics | Snowflake Worksheets |
| Visualisation | Power BI Desktop |
| Publishing | Power BI Service |
| AI Assistance | Claude API |
| Documentation | Notion |
Ergast Motor Racing Database via Kaggle — 14 tables, static snapshot covering 1950–2024.
View live Power BI dashboard →
/sql— All SQL scripts for setup, table creation, and analytics views/powerbi— Power BI Desktop file (.pbix)/presentation— Final stakeholder presentation (.pptx)/docs— Data dictionary and project documentation