This medium article focusses on the detailed walkthrough of the steps I took to solve the challenge lab of the Insights from Data with BigQuery Skill Badge on the Google Cloud Platform (Qwiklabs). I got access to this lab in the Google Cloud Ready Facilitator Program. Thanks to Google!
Till now, I have completed over 100 labs and 23 quests on Qwiklabs. Below is the reference of my profile.
This lab is only recommended for students who have completed the labs in the Insights from Data with BigQuery Quest. Knowledge ofSQL** and **BigQuery is also needed to solve this challenge lab. Are you up for the challenge? Let’s go!
Image by 200 Degrees on Pixabey
The dataset that we would be using in this challenge lab is **bigquery-public-data.covid19_open_data.covid19_open_data. **This dataset contains data related to covid-19 on a country basis globally. We would be using this in this skill badge tutorial.
BigQuery Tutorial can be found on the reference below:
There are 10 small tasks in this challenge lab, all of which should be completed to score 100/100. In order to pass the lab, there are** 9 SQL commands and 1 Data Studio** report that should be generated in order to score 100. This tutorial list out the steps I took to solve all the ten challenges within the lab. The ten tasks are as follows:
#sql #qwiklabs #google-cloud-platform #data-science #bigquery #cloud