How Duolingo Plans to Reach 100M Users

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Insights from Data with BigQuery: Challenge Lab

Google via Google Skills

Go to class Write review
Corporate Finance Institute Ad

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Learn More → Coursera Ad

Google Data Analytics, IBM AI & Meta Marketing — All in One Subscription

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.

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

Reviews

Start your review of Insights from Data with BigQuery: Challenge Lab

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.