Google Data Studio: How to get the most out of your time series chart? | Lachezar Arabadzhiev | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Google Data Studio: How to get the most out of your time series chart?

teacher avatar Lachezar Arabadzhiev, Founder and CEO @SkildLabs

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

4 Lessons (13m)
    • 1. Introduction

      0:28
    • 2. Configuring a time-series chart and date types

      4:33
    • 3. Comparing date ranges and advanced filters

      3:30
    • 4. Automating reporting with an advanced date control

      4:07
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

16

Students

--

Projects

About This Class

A time series chart shows how your data points and how they change over a period of time. For example, you can display the count of product revenue weekly over the course of a quarter, or perhaps your website traffic with monthly granularity over the last 5 years. Either way, a time series chart can provide an enormous amount of context to data set. In this class, we are going to explore the intricacies of how to configure a time-series, edit advanced date range and automate data flow via the date control. Let's get started!

c0d9ebda.png

Meet Your Teacher

Teacher Profile Image

Lachezar Arabadzhiev

Founder and CEO @SkildLabs

Teacher

Hey there! I'm Lachezar Arabadzhiev and for the past five years, I have helped companies harness the power of data in a variety of ways to drive business growth and innovation. I began my career as a digital marketer at Microsoft but soon transitioned to the audience and analytics world, where I had the opportunity to work with major brands including Air Canada, RBC, Walmart, Kimberly-Clark, Nintendo, Mazda, and HSBC. In addition, I am the owner of the Data Studio Canada educational website. 

Throughout all that time, I always loved teaching and developing learning programs for my colleagues and friends. That passion materialized in early 2021 in the form of a brand new company that I was luckily enough to start.

I am currently the Founder and CEO of SkildLabs, where ... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Hey, there latches are here with another video on data visualization. Would Google Data Studio. In this video, we're gonna talk about time series or simply put, how do we analyze data that has trended over time? We're also going to look into comparing different time periods, such as month over month or a year over year. And lastly, we're going to look into how to use the date filter to automate our dashboards and reports without further ado. Let's get started. 2. Configuring a time-series chart and date types: We're going to start off this module by exploring something called a time series. A time series is really a representation of all your data points, but simply put in an ordered way. To get started, we're going to click on Add Chart and select Time Series here. So there's a couple of different versions here, but we're going to start off with the first one. And we're going to select this will expanded a little bit. And I just wanted you to notice that the data source here is, we've gone back to one master view. So for this one, we're going to use the Google Analytics demo account because it has a lot of data and we'll be able to look at it in continuation. So if you are using the old data source, just swap it. Perfect. Now we have the chart here and I'm going to expand it even a little bit more. And expanded on the bottom. We're going to add a control. Just saw are looking at the same data range. So I'm going to add a control here on the top. And we're going to select a couple of months because we're going to need a few months here. So we're going to start January 2021 and we're gonna do May 2021. So we're going to get a good couple of months. And so you can see what happens with the time series. The main thing here is on the x-axis you have the actual months. We have January first, January 11. So those are the different dates that correspond to the specific data point. What do we have as a metric? And the blue line is new users. And on the y-axis you have the amount of new users. And you can see it's pretty simple how it's set up here. On the metric side, we have new users on the dimension and we have date. Now let's dig a little bit deeper into the date here. So I'm going to edit it and click here on the little pencil and click on Type. So the interesting part is, when we looked at the data schema, will these options were available. But we can also expand this and look at the date, the time. We can change this formatting to let say, if we wanted to see it quarterly, we'll just click quarter here. And what's going to happen is we've selected obviously just a couple of months. So we'll see this x-axis change to Q1, Q2, Q3, Q4. Let's select another option just to see how that works. So we're gonna go type again, take it in time. And perhaps we can pick maybe weeks. Let's see day of week. And let's see what that gives us. So that gives us the actual Sunday, Monday, Tuesday, Wednesday. In aggregate, there's a lot of different options in the beauty of this is when ingesting data that's often with other tools, difficult to change the dates. You have to write a lot of different scripts, cast the data and change formats. Whereas here you can do that right away into the types here and just change it very, very quickly. So I can even go into as granular as date, hour, minute. And so if that's provided, it will give me the result. But if that's not provided, we'll get this error. So too many rows do to the number of frozen charge can be rendered. So imagine how granular the data gets that we're getting this error because we'll have the date, the hour, and the minute. So the entries of all those different users for every single minute, it's just, the volume is too high. So we're going to revert it back to isolate your week. And this is really the most common one that you would seen dashboards because it has the actual day and then it has the ear. So if you're doing any type of year-over-year comparisons, that would be fairly useful. So I'm just going to go to the view here just to show you how it looks for a viewer. So the interesting part is that the tool tip here, it's really helpful because it colors the metric. So I can see how many new users were there in that week. And on top I can see when the week starts, when it ends. And what's the number of this week? So week one, we have here, week 2, week 3, and et cetera. Because it's very, very visually appealing to do this. Now, let's go back to edit and see another option here. 3. Comparing date ranges and advanced filters: In this video, we're going to look at a couple of things. We're going to cover comparisons and also advanced filters and how they can work together with the time series. So we're going to start by just deleting this one that we created previously and create a brand new time series here. Just going to select it. And we're going to still stick to the date range here, but not for long because we're going to play around with this. Now let's keep the new users and looking to the dates here. So I'll scroll down and we can see the default date range. Well, auto means that we're going to be using this control here on top, costs them means that you can actually override this and troll and select a specific one for this only for this time series. And we're not going to really use this one right now. What we're going to focus on as comparison date range. And this is really cool. So if I click here and open it, I can pick a comparison date range for this chart. So I can really compare month over month, year over year, week over week. If I want to, just by clicking a button, I can either select a fixed date range here. For example, we saw that it's January 1st, 2021, May 31st, 2021. So how about going back to 2020 and selecting January first and going back here as well. So going a year back and selecting May 31st. So if I click apply shears, what happens? I get new users or regular line here, and then I get new users January 1st, 2020. And it's the previous year. So I can see year over year comparison. And if I go to View here, here is how it looks. So I have the lines, but if I drag the mouse through this, I can actually see for every single day how many new users I had on February 14 for 2021 and how many I had for February 14th, 2020. And so I can immediately spot that, well, 2020 was a better ear because I have way more users that day. And so by doing these comparison, you can really see the data and spot any type of issues that you might be having with your website. And you basically add another layer to your data that can help you create an insight and a much more effective way. So let's see what else we can do with this feature. So I'm going to go back to Edit, click on it, and we're going to select the comparison again. So it's fixed comparison here because we selected What's the start and end date. But if I click on this view here, I can select previous period, previous year. Advanced thing, we'll see that in a minute, but I can do previous year and click Apply. And now every time I go to the View here and select, for example, even a single month. So let's say we just select January because we're not using the fixed one. This automatically adjust any chills me the exact numbers for the year before. So this is really important because we other type of software in order to create a year over year or period over period comparison. It takes an incredible amount of formulas and you can get fairly complex. Whereas here it's really easy if I decide to change this to February and just look at a couple of days that is going to adjust and I'm going to see the same days for the year before. 4. Automating reporting with an advanced date control: In this last part, we're actually going to see how we can automate our reporting if we have a campaign or specific cadence that we need to follow what our clients. So I'm going to go back to edit here. And we're going to remove this previous year that we set up. So we're going to click here and we're going to click on none. And then apply. So you can apply this comparison to existing charts, but you can also play with the deep feature directly, the control that you have here. So let's see what I actually mean. I'm going to click on this. And we're going to get a default date range, which is fixed in this case. So we've selected a specific range that we want to see on the dashboard. Well, a lot of times that's not necessarily the reality. What happens is when you have campaigns or sales, these dashboards have to be updated in normally a person would go manually update them to show an extra week, extra day, or a specific increment that your client might have asked for. You can also apply these settings here on top. These are not necessarily comparisons, but these allow you to see, let's see the last seven days, last 14, 28 days. So I'm just going to click on one of these to show you what happens. So I'm going to click apply, and you probably saw the actual calendar changed. But what's happening here is the last 30 days, it's a rolling 30 days. So if I review this tomorrow and for you it might be different because it will be viewing the course that are different on, but you will always see the last 30 days of data. And it says excludes today. So if I go to View and let's say here it's May 21st. Tomorrow, May 21st will disappear and I will only have May 20 seconds. So this will gradually move and adjust based on the date that is today. So this is really useful if you want to see specific time increment. And there's a lot of preset options. So if I go back, a lot of the sections are included. So today, yesterday, week, month, there's a lot of different options. So most of them will cover you. Plus if you want to include today, which normally is not included unless you're doing some sort of a test or an event. But you can make this even more interesting by using what's called the Advanced option. And all these are also available in the comparison. So if I scroll to the very bottom, click Advance here, and we have rules that we can set up for the start date and end date. So let's imagine that we started a campaign. And so I'm going to click fixed for the sake of this little scenario, we started a marketing campaign and we started it on June 15. And so we know that data is going to be flowing on June 15 before then there's going to be nothing. So that's why we're going to select 15 here. Now for the end date, we want to see the new data that comes in with every data has passed. And we don't really want to give that flexibility to the user to do with themselves, which just want it to be automatic because there'll be checking in on a daily basis anyway. So we don't want them to play around with the control every time. So what you could do here is you can select today which is pre-selected, then you can pick between minus and plus. There are two options, in this case will be minus. And then you can pick the actual number of increments, so is one. And then we can pick days, months, quarters, and a lot of other different options, but in this case is days. So what's happening right now is this is telling Google Data Studio whatever the date is today, minus one, what I would like to see every day. So in this case, Today is June 20th. If you minus one, it will be June 19th on the 21st. This will show June 20th. So by doing this, you can automate the updating of your dashboards in minimize the amount of manual work that will be needed. And once you click Apply, you have your dashboard adjusted.