Showing off the new (free) Google Data Studio, with reddit April’s gilded comments for Sanders/Trump/Clinton in BigQuery

Felipe Hoffa
May 26, 2016 · 2 min read

The Google Analytics team just announced Data Studio: their free, new, Data Visualization Product. Read their post for more details, but since I just got a new load of reddit comments from /u/Stuck_in_the_Matrix loaded in BigQuery, I’m eager to show you how to connect both.

The first surprise with Data Studio: It’s really easy to connect it to BigQuery:

  1. Add a data source, choose BigQuery.
  2. To work with open data that others have shared, choose “shared projects”. Try adding mine, to find reddit comments: ‘fh-bigquery’.
  3. Select the dataset and table you want to work with.

4. If this is your first time using BigQuery, you might need to create a new “billing project”. Don’t worry, just create a GCP account and don’t worry about billing (yet): BigQuery gives you a free terabyte for querying every month, no credit card required. Then come back to Data Studio to complete the previous steps.

5. Note that when querying and sharing, this will be the project being billed for the underlying BigQuery queries.

Data Studio now displays your chosen table columns (it could have been a query too), and allows you to choose the credentials to use when sharing the report (yes, you can share). You can choose either your credentials (will allow you to share the reports with anyone) or have the report ask for the viewer credentials (to keep the underlying data viewable only by authorized parties).

And now comes the fun part: Start dragging and dropping to create visualizations and interactive reports:

To put all of this together, I created a visualization to compare how many comments for Trump/Sanders/Clinton got gold on reddit during April 2016. As shown in the following video, it’s super easy to share the results.

The shareable report: https://datastudio.google.com/open/0ByGAKP3QmCjLWFpxU1R4WU9WR0k

For more stories like this, follow me on twitter.com/felipehoffa, or subscribe to reddit.com/r/bigquery.

PS: Now globally available!

Google Cloud - Community

A collection of technical articles published or curated by…

Felipe Hoffa

Written by

Developer Advocate @Google. Originally from Chile, now in San Francisco and around the world. Let’s talk data.

Google Cloud - Community

A collection of technical articles published or curated by Google Cloud Developer Advocates. The views expressed are those of the authors and don't necessarily reflect those of Google.

Felipe Hoffa

Written by

Developer Advocate @Google. Originally from Chile, now in San Francisco and around the world. Let’s talk data.

Google Cloud - Community

A collection of technical articles published or curated by Google Cloud Developer Advocates. The views expressed are those of the authors and don't necessarily reflect those of Google.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store