01
F1-Data-Warehouse
The project follows a modular Medallion Architecture to ensure data integrity and analytical readiness: Bronze Layer (Ingestion): Raw data is ingested from CSV files into a SQL Server environment using Python. Silver Layer (Transformation): SQL views are used to clean, join, and standardize racing metrics. Gold Layer (Analysis): Complex T-SQL queries extract deep insights into driver and constructor performance. Presentation Layer (Visualization): An interactive Power BI dashboard provides a bird's-eye view of the sport's history.
- SQL Server,
- Python,
- Power BI
