Grid Intelligence is an interactive Power BI analytics suite designed to transform raw Formula 1 historical data into actionable racing insights. By visualizing decades of race results, this project uncovers the hidden patterns behind driver dominance, constructor hierarchies, and evolving team strategies.
- Driver Performance Trends: Longitudinal analysis of podium finishes, win rates, and points progression across different eras.
- Constructor Strategy: Evaluation of team efficiency, reliability (DNFs), and the correlation between qualifying positions and final race results.
- Circuit Heatmaps: Statistical breakdown of lap times and win probabilities across various global circuits.
- Interactive Drills: Users can filter data by Season, Nationality, Constructor, or specific Grand Prix to see granular performance metrics.
- Visualization: Power BI Desktop
- Data Modeling: DAX (Data Analysis Expressions) for custom measures (e.g., Win %, Average Grid Position).
- Data Transformation: Power Query (M Language) for cleaning and normalizing datasets.
| Metric | Description |
|---|---|
| PtoP Ratio | Pole-to-Podium conversion rate for top-tier drivers. |
| DNF Analysis | Mechanical vs. Collision retirement rates per Constructor. |
| Overtake Index | Analysis of grid position vs. finishing position per circuit. |
- Clone the Repo: ```bash git clone https://github.com/[YourUsername]/grid-intelligence.git