As the final dashboard week challenge, we were tasked with analyzing Formula 1’s dataset. As someone who knew very little about Formula 1, I was initially overwhelmed and didn’t know where to start. However, with the help of our coaches, I was able to find an angle and decided to analyze Red Bull’s performance over the years to determine the importance of the driver and the car.

One of the biggest challenges of this project was finding the correct data model and relationships to join. Formula 1 has many tables, and if we made any incorrect relationships, we were more likely to get duplicated rows and incorrect information. For instance, we had to join tables that contained data on drivers, seasons, constructors, constructors’ results, and race results, which made the data model quite complex. Despite this challenge, I am able to find the correct relationships and data model to analyze Red Bull’s performance.

Here are the insights I found:

I found that in 2010, Red Bull’s ranking rose significantly from 7th to 1st in the Constructor Championship, which was the year Vettel joined the team. Vettel and Red Bull won the championship that year. They also hired Adrian Newey, a highly respected technical director, to lead the car design effort, and he produced the RB6 for the 2010 season. As a result, Red Bull has finished more races than the previous year, which suggests that their technicians have improved the car model, allowing them to achieve better results on the track. It indicates that the driver’s skills and the car’s advanced technology worked together to create a winning combination.

Red Bull’s ranking dropped temporarily after Vettel quit the team. However, since Max Verstappen joined the team, Red Bull’s ranking has recovered. This suggests that a combination of driver, car, and team strategy is required to win the championship.

While the dashboard week was a challenging and stressful experience, in the end, it was very rewarding. I learned a lot, such as how to timebox tasks, deliver a minimum viable product on time, and leverage all the tools at my disposal to achieve results. These skills will be invaluable in my future projects and will help me deliver high-quality work on time.

The Data School
Author: The Data School