Skip to content
/ SQL-ETL-Sheets-BigQuery-DataStudio Public

This repository contains SQL code I used to build an ETL pipeline that extracts data from Google Sheets, transforms it inside of Google BigQuery, and then loads it into Google Data Studio dashboards.

3 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

davidwhitenyc/SQL-ETL-Sheets-BigQuery-DataStudio

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

92 Commits
README.md
README.md
 
 
e01_ela_grade1_create_or_refresh_bq_datasource.sql
e01_ela_grade1_create_or_refresh_bq_datasource.sql
 
 
e02_ela_grade2_create_or_refresh_bq_datasource.sql
e02_ela_grade2_create_or_refresh_bq_datasource.sql
 
 
ekg_ela_gradek_create_or_refresh_bq_datasource.sql
ekg_ela_gradek_create_or_refresh_bq_datasource.sql
 
 
epk_ela_gradepk_create_or_refresh_bq_datasource.sql
epk_ela_gradepk_create_or_refresh_bq_datasource.sql
 
 
etp00_datasource_level_calculated_fields.txt
etp00_datasource_level_calculated_fields.txt
 
 
etp03_ela_test_prep_grade3_create_or_refresh_bq_datasource.sql
etp03_ela_test_prep_grade3_create_or_refresh_bq_datasource.sql
 
 
etp04_ela_test_prep_grade4_create_or_refresh_bq_datasource.sql
etp04_ela_test_prep_grade4_create_or_refresh_bq_datasource.sql
 
 
etp05_ela_test_prep_grade5_create_or_refresh_bq_datasource.sql
etp05_ela_test_prep_grade5_create_or_refresh_bq_datasource.sql
 
 
etp99_ela_test_prep_leadership_view_create_or_refresh_bq_datasource.sql
etp99_ela_test_prep_leadership_view_create_or_refresh_bq_datasource.sql
 
 
m00_math_gradeK_create_or_refresh_bq_datasource.sql
m00_math_gradeK_create_or_refresh_bq_datasource.sql
 
 
m01math_grade1_create_or_refresh_bq_datasource.sql
m01math_grade1_create_or_refresh_bq_datasource.sql
 
 
m02_math_grade2_create_or_refresh_bq_datasource.sql
m02_math_grade2_create_or_refresh_bq_datasource.sql
 
 
m03_math_grade3_create_or_refresh_bq_datasource.sql
m03_math_grade3_create_or_refresh_bq_datasource.sql
 
 
m04_math_grade4_create_or_refresh_bq_datasource.sql
m04_math_grade4_create_or_refresh_bq_datasource.sql
 
 
m05_math_grade5_create_or_refresh_bq_datasource.sql
m05_math_grade5_create_or_refresh_bq_datasource.sql
 
 
map01_nwea_map_v2_create_or_refresh_bq_datasource.sql
map01_nwea_map_v2_create_or_refresh_bq_datasource.sql
 
 
mtp03_math_test_prep_grade3_create_or_refresh_bq_datasource.sql
mtp03_math_test_prep_grade3_create_or_refresh_bq_datasource.sql
 
 
mtp04_math_test_prep_grade4_create_or_refresh_bq_datasource.sql
mtp04_math_test_prep_grade4_create_or_refresh_bq_datasource.sql
 
 
mtp05_math_test_prep_grade5_create_or_refresh_bq_datasource.sql
mtp05_math_test_prep_grade5_create_or_refresh_bq_datasource.sql
 
 
mtp99_math_test_prep_leadership_view_create_or_replace_bq_datasource.sql
mtp99_math_test_prep_leadership_view_create_or_replace_bq_datasource.sql
 
 

Repository files navigation

ETL-Sheets-BigQuery-Data Studio - MSM Design

This repository contains SQL code that I've used to build an ETL pipeline that extracts data from Google Sheets, transforms it inside of Google BigQuery and loads it into a suite of Google Data studio dashboards.

For more information please contact me at: david@msmdesign.nyc | msmdesign.nyc

A. Diagram of the ETL Process

B. Instructions for Maintenance and Data Updates

C. Example of a Dashboard I Built Using This Process

About

This repository contains SQL code I used to build an ETL pipeline that extracts data from Google Sheets, transforms it inside of Google BigQuery, and then loads it into Google Data Studio dashboards.

Topics

bigquery sql dashboard etl google-sheets google-cloud-platform data-studio

Resources

Readme
Activity

Stars

3 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published