GSP787 Insights from Data with BigQuery: Challenge Lab (COVID-19 Open Data) | 🐱🏍 GCP learning tour
Step-by-step Guide 👉 https://chriskyfung.github.io/blog/qw...
⏱ Timestamps:
00:00 Start Lab
00:30 Open "COVID-19 Open data" public dataset
01:34 Query 1: Total Confirmed Cases
03:10 Query 2: Worst Affected Areas
07:07 Query 3: Identifying Hotspots
09:17 Query 4: Fatality Ratio
12:30 Query 5: Identifying specific day
13:19 Query 6: Finding days with zero net new cases
14:47 Query 7: Doubling rate
18:25 Query 8: Recovery rate
24:36 Query 9: CDGR - Cumulative Daily Growth Rate
25:32 Create a Datastudio report
📹 Short ver. → • Speedrun🚀GSP787 Insights from Data wi...
#GoogleCloud #BigQuery #ChallengeLab
