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
Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More → Financial Edge Ad

The Investment Banker Certification

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.