Explore Public Datasets with Google BigQuery and DataStudio

Explore Public Datasets with Google BigQuery and DataStudio

In this short article, I will introduce you how to use Google Cloud service (BigQuery + DataStudio Free plan) to explore the open-source dataset with example COVID-19 dataset from the Google Cloud Public Datasets Program.

Many time, as Data Scientist, we waste so much time in the data storing, importing, managing, and cleaning process. In this short article, I will introduce you how to use Google Cloud service (BigQuery + DataStudio Free plan) to explore the open-source dataset with example COVID-19 dataset from the Google Cloud Public Datasets Program.

Good News, It’s Free!

As with all data in the Google Cloud Public Datasets Program, Google pays for storage of datasets in the program. BigQuery also provides free queries over certain COVID-related datasets to support the response to COVID-19. Queries on COVID datasets will not count against the BigQuery sandbox free tier. As in the free tier, you can query up to 1TB free each month and up to 1 TB queries/month, completely free of charge. [1] Well, that’s quite a lot of data you can explore!

What do you need before the start?

  • The Google Cloud account. (Free tier is sufficient)
  • Some of the standard SQL knowledge - to able to query the data, which you can find several of the tutorials online such as in https://www.w3schools.com/sql/

Yes, that’s it — you are good to go!

google-cloud-platform covid19 bigquery data-science google-data-studio

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

The basics of Google Cloud Platform (GCP)

The Cloud is a complicated space. It’s not a simple plug and play as most people would imagine. Let’s simplify the Cloud: GCP Edition. The Cloud is a complicated space.

Overview of Google Cloud Essentials Quest

If you looking to learn about Google Cloud in depth or in general with or without any prior knowledge in cloud computing, then you should definitely check this quest out.

50 Data Science Jobs That Opened Just Last Week

Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments. Our latest survey report suggests that as the overall Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments, data scientists and AI practitioners should be aware of the skills and tools that the broader community is working on. A good grip in these skills will further help data science enthusiasts to get the best jobs that various industries in their data science functions are offering.

Google Data Studio in 6 steps — Beginners Guide

Google Data Studio in 5 steps — Beginners Guide: How to get started with Google Data Studio, connect to data, generate insights, build reports, create stories, and share your work — all for free!

Multi-cloud Spending: 8 Tips To Lower Cost

Mismanagement of multi-cloud expense costs an arm and leg to business and its management has become a major pain point. Here we break down some crucial tips to take some of the management challenges off your plate and help you optimize your cloud spend.