Create a data pipeline that runs periodically to place fivethirtyeight datasets into BigQuery.
Take these datasets, tidy them up and place them in BigQuery.
- Google BigQuery
- Google Data Studio
Order of operations
for all csvs found in folder: load into a table in BigQuery (raw dataset)
delete local repo copy
perform data transforms using SQL and loading the data into tables in prod dataset
Tarantino Film Dashboard dashboard in DataStudio
World Alcohol Consumption Dashboard dashboard in DataStudio