← All projects
// Project · Oct 2023

How Dominant Are Red Bull Really?

An analysis of dominance in Formula 1 across the years.

Python Pandas Power BI
Formula 1 dominance comparison graphic

Overview

Red Bull Racing are currently the kings of F1, winning both championships this year in dominating fashion. There is no doubt this team is one of the greats, but how great are they really? Here is a short personal data analysis project I did comparing the performances of Red Bull (2023) to other dominant F1 teams from the past, including Mercedes (2015), Ferrari (2002) and McLaren (1988).

The data is sourced from the Ergast API (ergast.com/mrd).

This project involved

Data Collection & Processing
  • Collected each season's race and qualifying results and saved them to .csv files.
  • Cleaned and processed the data to make it usable.
Data Analysis
  • Conducted exploratory analysis using Python.
  • Calculated the relevant statistics for comparison between teams.
Visualisation & Reporting
  • Visualised the data in intuitive and aesthetic graphs using Microsoft Power BI.
  • Wrote up a comprehensive final report.
Power BI visualisation of F1 team dominance statistics

If you're interested, you can read my full report below, or explore the Python script I wrote to calculate the stats:

Loading preview…
Open full report Download PDF Python File

This was a very interesting project with results that may be surprising to younger or more casual fans of the sport. It was a great experience for honing my data processing, analysis and visualisation skills. I look forward to sharing more interesting projects in the future :)

← Back to all projects