GSP787 Insights from Data with BigQuery: Challenge Lab (COVID-19 JHU CSSE EU Dataset) | GCP learning
🆕 Watch the new version for the lab that changed to use COVID-19 Open Data dataset 📹 • GSP787 Insights from Data with BigQue... 👈
⏱ Timestamps:
0:00 Start Lab
0:29 Query 1: Total Confirmed Cases
2:24 Query 2: Worst Affected Areas
4:23 Query 3: Identifying Hotspots
5:48 Query 4: Fatality Ratio
7:41 Query 5: Identifying specific day
12:34 Query 6: Finding days with zero net new cases
13:50 Query 7: Doubling rate
17:12 Query 8: Recovery rate
20:50 Query 9: CDGR - Cumulative Daily Growth Rate
22:50 Create a Datastudio report
Congratulations!
#GoogleCloud #BigQuery #ChallengeLab
