Data Studio the Lazy Way
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Studio the Lazy Way to your Wishlist.

Add to Wishlist

Data Studio the Lazy Way

Mastering Google's free dashboard tool
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Created by David Krevitt
Last updated 5/2017
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build advanced dashboards and reports in Google Data Studio
View Curriculum
  • A Google account and an open mind

Google released their beautiful dashboard-building powerhouse, Data Studio, in Fall 2016.  

We've been actively building dashboards with it ever since.

Ascending new heights. Stretching the limits of what's possible with Data Studio.  You get the picture.  

We've turned this tool inside out, and now are here to share everything we've learned.

During the course, you'll master how to build Data Studio reports.  

All of these dashboards are based on raw data from Google Sheets, but the same methods could be used for any data source (Google Analytics, Youtube, a database, etc): 

  • Building a Twitter data dashboard (the course project)
  • Connecting Mailchimp to Data Studio (template included)
  • Building an Adwords + FB ads dashboard with Supermetrics (template included)

Your team will thank you, when they bask in the beauty and elegance of your next monthly update.

Who is the target audience?
  • Anyone building reporting for their team - marketers, developers, HR and ops specialists
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
Data Studio Basics
6 Lectures 22:26

Walking through what we'll actually *do* here.  

The course project is a Data Studio dashboard based on Twitter analytics data - which has been dropped into a handy Google Sheet for our analysis.

We'll use Data Studio to calculate new metrics, make sexy charts, and generally squeeze the lemon that is this Twitter data.

To get started, make a copy of the course Twitter data here:

Preview 00:53

Data Studio is somewhat temperamental - it requires your Sheets to be in a specific format to read them correctly.  

Date columns in particular can be tricky, so you won't want to miss this lesson.

Preview 04:34

Every piece of data in Data Studio is a *Data Source*, which you need to connect before you can build any charts or tables with it.  

This includes Google Analytics, Youtube, or any of the native sources that sync with Data Studio - but in this tutorial we'll focus on connecting a Google Sheet.

Preview 03:35

Fields in data studio are either dimensions or metrics.

Dimensions are text values like your City or State.  

Metrics are number values like your Height.

If you've worked with Google Analytics data before, this will look familiar to you.

Connecting your Data Source

Getting your feet wet with building basic charts - feel for the first time the glorious bells and whistles of the Data Studio sidebar.

Building your First Chart

Being able to compare metrics between two date ranges is one of the most powerful features of Data Studio.  

Learn how to put it into action. 

Adding Time Period Comparisons to your Chart
Getting Fancy with Filters and Calculated Columns
6 Lectures 21:48

Adding your first date filter to your report - the magic dropdown that makes your charts sing.

Preview 05:56

In many ways, calculated columns can *replace* work that you used to do in Google Sheets.  

For more info on the formulas available in calculated columns, check out the attached Google docs.

Preview 06:03

Dive into the nuances of making your bar charts look oh so beautiful.

Styling your Bar Charts

Scatterplot charts a bit more complex than bar charts - let's make sure you know how to wield them effectively.

Styling a Scatterplot Chart

Quiz 1: Starting your Dashboard

Quiz 2: Filters and Calculated Columns
Reaching the Summit with Calculated Columns
6 Lectures 23:56

When you start building multi-page dashboards, you'll want to add some titles, filters, charts or tables to *every* page, and some to just one page.  

Classifying them as either Report or Page-Level allows you to do that.

Preview 04:34

Let's take your calculated column skills up a notch, by writing a function to count another column.  

Building a 'count' column is the easiest way to get around Data Studio's pesky limitations on aggregating dimensions.

Counting in Calculated Columns

The CASE statement is the swiss army knife of custom functions in Data Studio.  

You can use it to apply a time of day (morning / afternoon / night) based on an actual time (12:30pm), or to apply a type of tweet (retweet / primary tweet) based on tweet text.  

It's a tough nut to crack, but opens up a world of possibilities in calculating your own metrics. 

Using the CASE function in Calculated Columns

Often you'll want to strip out just one part of your dates - whether it's the day of the week, or month of the year. 

Calculated columns allow you to seamlessly do that, without adding new data to your Sheet.

Working with Dates in Calculated Columns

We already talked about adding filter control dropdown menus to your reports, but what about filtering behind the scenes?

Let's walk through how to add a custom filter to any chart or table.

Filtering on the Fly

Quiz 3: Taking Calculated Columns to the Limit
Putting Data Studio into Action
3 Lectures 04:47

With great power, comes great responsibility.

A Word of Caution

Building an Ad Campaign Dashboard with Supermetrics

Visualizing your Mailchimp Data with Apps Script
About the Instructor
David Krevitt
4.5 Average rating
31 Reviews
255 Students
2 Courses
Growth Marketer

I'm currently the head of growth at Coach, a venture-backed education startup in New York City.

I publish everything I know about code-free automation on my blog, Coding Is For Losers, including a vault of Google Sheets templates. 

I teach advanced Google Sheets, how to use Sheets add-ons like Blockspring, Supermetrics, and Zapier for data analysis, and SQL for beginners.