Get started with Google BigQuery: Your first lab is on us

You want to get the most out of your data. But when you hear words like “public datasets”, “training data models”, and “correlation percentage”, your eyes glaze over. So how do you start taking advantage of Google Cloud’s data tools?

Here are some easy ways to get started.

  1. Watch and learn. Join Priyanka and Heather to learn how to get meaningful insights with Google BigQuery (4:39).

  2. Then, get hands-on practice with a hands-on lab for yourself. Just click the link below the YouTube video and follow instructions. Did you get your free Qwiklabs credits, to take your first BigQuery lab on us? Just be sure to click before April 2. And if you want to double-check your work, go back to the video and follow along with the demo, starting at 3:45.

  3. Ready for a little more of a challenge? Try the Weather Data and BigQuery lab, and practice correlating diverse data sets. And today only, this lab is featured for #1creditwednesday, which means this lab is available for 1 credit (normally priced at 5 credits).

In this lab, you will take a look at analyzing public data with BigQuery – starting with weather data from NOAA and citizen complaints data from New York City. 

Using public datasets, you will find what types of municipal complaints are correlated with weather. For example, you will find (not surprisingly) that complaints about residential furnaces are most common when it is cold outside:

Weather Data in BigQuery

What types of big data do you think you might correlate?

  • Weather and traffic volume on your retail website

  • Daily temperature in your town and foot traffic on your business’s street

  • NCAA winning percentages and uniform colors (there’s a lab for that!)

You can find the Weather Data and BigQuery lab here. Special today, the lab is available for 1 credit only (usually priced at 5 credits), so now’s the perfect time to check it out. Click the green button to start the lab. You’ll see a lower price than the screenshot below, today only.

Start the lab

See how the left panel changes? Those are your credentials to log into the Google console. Use these credentials (not your personal credentials) so Qwiklabs covers the cost of all your lab activities.

Sign into the Google Cloud Console

Next, you’ll need to accept the terms of service for the student account. Don’t worry about account recovery or emails – you won’t ever need to use this account again.

Agreements

Then you’re off on your lab! Follow the lab manual and at the end of the lab, you will have correlated two massive public datasets using BigQuery. What will you correlate next? We’d love to hear how you applied what you learned in the lab to your real-world data questions, let us know @Qwiklabs!

Leave a Reply

Your email address will not be published. Required fields are marked *