Explore over 70 years of Formula 1 history through data!
This project combines SQL-based data exploration with Power BI dashboarding to uncover driver trends, constructor dominance, DNF risks, and circuit-specific insights — all powered by the official F1 dataset.
- Extract insights on driver performance, constructor reliability, and circuit difficulty
- Perform complex aggregations using SQL (MySQL Workbench)
- Create multi-page Power BI dashboards for storytelling
- Make data actionable for motorsport fans and analysts
| Tool | Purpose |
|---|---|
| MySQL Workbench 8.0 | Writing SQL queries, data exploration |
| Power BI Desktop | Visualizing insights via dashboards |
| GitHub | Storing queries, outputs, dashboards |
| Kaggle F1 Dataset | Primary data source (1950–2020) |
📊 Power BI Dashboard Pages Driver Career Overview — Wins, Podiums, Total Points, Seasons Constructor Performance mixed with circuit analysis
📂 Dataset Overview Source: Kaggle Formula 1 World Championship
Key tables used:
drivers, constructors, results, races, circuits
Custom views created: vw_driver_results, vw_constructor_points, etc.