This repository contains a comprehensive Formula 1 (F1) database setup and analysis project. The aim is to provide an extensive dataset for exploring various aspects of Formula 1 racing, including circuits, drivers, constructors, race results, and more, using SQL queries.
- Download the F1 data folder from One Drive: Download Link
- Originally, I pulled the data from Kaggle. Before being able to use the data in the format provided in the download link, I had to clean the data.
Unpack and move the F1 folder to your desired location on your PC/Mac or network.
Use the Find & Replace function in MySQL Workbench to replace the file path in the SQL scripts with the location of your F1 folder.
Run the provided SQL scripts to create the F1 database, its tables, and import datasets.
Start exploring the database with SQL queries to uncover insights about the F1 world.
- Circuits: Information about race circuits.
- Drivers: Details of F1 drivers.
- Constructors: Data on F1 teams.
- Seasons: Season-wise data.
- Races: Detailed information on each race.
- Race Results: Results of individual races.
- Constructor Results: Team performances in races.
- Status: Status codes for race outcomes.
- Driver Standings: Seasonal performance of drivers.
- Constructor Standings: Seasonal performance of teams.
- Qualifying: Qualifying round details.
- Pitstops: Information about pitstops during races.
- Lap Times: Lap time data for drivers.
- Most Successful Drivers: Retrieve a list of drivers with the most race wins in F1 history.
- World Champions by Year: List F1 World Champions for each year, along with their team and nationality.
This project has been a deep dive into the world of Formula 1, offering insights into data structuring, database management, and SQL querying. Handling a dataset of this magnitude has been a rigorous exercise in data organization and query optimization. This type of approach to handling the motorsports series' statistics data would be typical for a platform providing insights into the sport.
- Data Expansion: Continuously update and expand the dataset with new seasons and race data.
- Advanced Analysis: Looking to implement more complex queries and possibly integrate this data with analytical tools for deeper insights. At this time, I've only utilized MySQL to query the data in a structured format. Consequently, logical next steps would take this data to more advanced data analytics tools such as Python, R, or Tableau to create actionable insights and visualizations.
- Name: Tobias Seck
- LinkedIn: Tobias Seck
- Email: contact@tobiasseck.com
This README is part of my portfolio in data analytics, business analytics, and data science, demonstrating my ability to make data useful and accessible. For more detailed information and insights, visit my professional portfolio: Tobias Seck's Portfolio.