This challenge lab tests your skills and knowledge from the labs in the Insights from Data with BigQuery Quest. You should be familiar with the content of the labs before attempting this lab.
Overview
Syllabus
- GSP787
- Introduction
- Setup and requirements
- Scenario
- Task 1. Total confirmed cases
- Task 2. Worst affected areas
- Task 3. Identifying hotspots
- Task 4. Fatality ratio
- Task 5. Identifying specific day
- Task 6. Finding days with zero net new cases
- Task 7. Doubling rate
- Task 8. Recovery rate
- Task 9. CDGR - Cumulative daily growth rate
- Task 10. Create a Looker Studio report
- Congratulations!
Tags
Related Courses
-
Analyze BigQuery data in Connected Sheets: Challenge Lab
-
Streaming Analytics into BigQuery: Challenge Lab
-
Engineer Data in Google Cloud: Challenge Lab
-
Get Started with Cloud Storage: Challenge Lab
-
Analyze Images with the Cloud Vision API: Challenge Lab
-
Store, Process, and Manage Data on Google Cloud - Command Line: Challenge Lab
