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

Google Cloud - Community

A collection of technical articles and blogs 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

Data Cloud Advocate at Snowflake ❄️. Originally from Chile, now in San Francisco and around the world. Previously at Google. Let’s talk data.

Google Cloud - Community

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

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

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