Download data from https://ergast.com/mrd of Formula1 from year 1954 to 2021. Upload the data to Azure blob storage.
We are using 8 different dataset out of which four were Incrementally load on weekly basis.Also,we are transforming and generating into 4 different deltalake files.
Also analyzed the dominant drivers and domiant teams.
The Ingestion datasets schema are give below:-
The transformation dataset schema are given below:-
constructor standing dataset:-
Calculated race_result dataset(normalized the points based on wins):-