Google Data Studio has several chart types thus allow users to create and design their reports in unlimited ways. In today’s video, Ahmad of Siavak is back, this time to show us the 6 most significant charts in data studio. Plus, he will give us some tips and tricks on how to design your data visualization dashboards more efficiently.
Google Data Studio – https://datastudio.google.com/
Chart Types Reference – https://support.google.com/datastudio/answer/7398001
In this video, Ahmad is going to introduce you to the most important chart types within Data Studio. And he’s going to give you some tricks on how to build more effective dashboards in Data Studio. All and more coming up.
Hey, there measure geeks. Julian here back with another video for you. Today, we want to talk about Data Studio and data visualizations. Now, you’re seeing we are remodeling right now our little studio here and I’m thinking what should I put in the background? Let me know in the comments down below. Today, we gonna talk about Data Studio. And this is a quite new tool in a Google universe. So it’s always evolving further and further. There’s always stuff I learned from different people. And today we want to learn from Ahmad who’s going to show us the different chart types within Data Studio. He’s also going to give us his tricks on how to become more effective in building a dashboard. He’s actually going to build a very small dashboard in this video
in a very short amount of time. Now we got lots to cover. So Ahmad take it away. Thanks, Julian. This is Ahmad from Siovak. And today I’m gonna show you 6 useful charts in Google Data Studio and we are gonna create this simple report dashboard together. Okay, let’s begin. First, I’m going to create a new blank Data Studio report. And I’m going to create a new data source for it. For this tutorial, we’re going to use Google Analytics and we are going to connect to Google Analytics demo account.
Let’s choose the Master View. And connect. It takes a few seconds, and then you can add it to your report. Click Add to report. And we are ready to go. The first data visualization side we’re going to create is a scorecard. Scorecard is best to show KPIs with key performance indicators. To do this, let’s go and add a chart. Choose a scorecard.
Resize it a bit and position it our canvas. As you can see the scorecard chose a metric, we can change the metric, for example, to sessions.
We can drag and drop sessions over page views for it to change. We can see the date range of this metric. So this is the number of sessions over the last 28 days. And we can also have a comparison to the previous year, previous period, or a custom time period. I’m going to choose previous period and hit apply. We can also filter the scorecard to show the number of sessions only for segments of our audience. To do this, we can add a filter.
Let’s for example, say viewers only say country equal to United States. Hit Save. Now it reloads to reflect the number of sessions from users from United States. We can also change the name and title of the metric to US only sessions. So it’s clear what’s number is a scorecard is going to represent. Let’s revert it back to default. And remove the filter. Because I’m going to show you at the end of this video, a really cool trick and a new feature of Data Studio that is actually more useful. The scorecard right now is pretty basic. So the next thing I’m going to do is to apply a bit of a styling to the scorecard. We can go to the style tab, choose a background and border and border radius. For background, we can use a solid color, or you can use a gradient from top left to bottom right. And let’s choose from white to a light gray.
Let’s change the border radius to four and add a light gray border as well. Okay, this looks much better. Now let’s copy and paste it to create three more scorecards. So control C and control V to create another one. For this, I’m going to show revenue.
For the next one, I’m going to show transactions. And for the final one, I’m going to show e-commerce conversion rate.
That’s it. Now, let’s say we want to see the trend of sessions over the time period of last 28 days. This is only the total number. But if you want to see the trend, we can use another data visualization chart, which is a trend line. We can either add a trend line or time series directly from the menu. But because I want to keep this styling, I can do this from another way. Let’s see, I can copy and paste this to create a new one. As you can see, the metric is still sessions and the comparison time period is set. I make it a bit bigger to come here to this menu and change the type of the chart from a scorecard to time series chart. That’s it. So we have our time series here, which we can adjust. It’s already showing sessions during the timeframe of last 28 days. Now let’s create another type of visualization that shows us the top five acquisition channels that send traffic to this website during last 28 days. I’m going to copy and paste again because I want to keep this styling. And now I’m going to change the charts type from time series to a horizontal bar chart. Let’s close this. And for the dimension, I want to use default channel grouping,
which is the acquisition channel for these sessions. I want to sort it not based on the name of the default channel grouping, but based on the number of sessions descending. And then in this time tab, I can choose to show only the top five channels. Now I’m going to make it a bit smaller and resize it a bit. That’s it, we know the number of sessions, we can see the trend of sessions over time. And we can see the top channels that have been sending these users to our website. Now let’s say we want to know the geography of and the countries that are sending traffic to this website. I can copy and paste this again, resize it a bit to make it bigger. And then I can change the type to a geo map. The dimension automatically changes to show the country and in shows the number of sessions per country based on you know the shade of the blue color. The darker the country, it means the more sessions we had from this country. The next chart I want to create is an area chart. An area chart helps us to see both the channel contribution to the traffic and the trend of users over time, we already know what to do copy, paste. And the reason for copy pasting is just simply retaining the styling. Otherwise, you can come here and add a area chart quite easily. And once here, we can change it to this area chart. For the time dimension we’re using date, of course. And for the breakdown dimension, we’re going to use the default channel grouping.
Here, we can also go to this style tab and change the number of series to five. Because we want this to match to the bar chart above. As you can see, we can now see boosted trend of sessions over time, and also the distribution of the default channel grouping per date. Next, let’s see some demographic data. We’re going to use a pie chart to show the ratio of male and female users to this website. Let’s copy and paste the bar chart and change it either to a pie chart or a donut chart. They’re basically the same, they only look different I like the donut chart. Let’s make it a bit ticker. And in data, let’s choose gender as the dimension of this pie chart. Now also, I’d like to come to the style tab and change the position of the legend. That’s it. Congratulations our simple dashboard is ready. We can preview the dashboard. Or you can also share it with your client or the end user. If they hover on any piece of the pie, or bar, or any data into the top online, or any country, they can see the actual number of sessions or any other metrics that you have on your visualization. But other than that, it’s a static report, they cannot interact with it. So if they click, nothing happens, it’s basically stays the same. So now it’s time for the cool trick that I promised to show you. Let’s go back to edit mode, we want to make this dashboard a bit more interactive. Let’s start by making the pie chart interactive. You can select the visualization widget. And on the Data tab at the end, we have interactions, and we can choose it to apply filter. Now let’s see how it behaves. Now that we’ve enabled the interactions for this pie chart, if we hover and click on any piece of the pie, every other widget in this dashboard will get updated to show us the data for that segment only. Let’s try. Now every other widget on this dashboard is updated to only show the number of sessions for male users. We can click again to reset it and go back to default. Now let’s go back to edit mode and enable interactions for the rest of the widgets, for the map, for the area chart and for the timeline. And so we have a totally interactive report dashboard. We can click on organic search to see data all for organic search which is coming up with an error. I don’t know why. We can click back to reset, we can click on the US to only see the other data for US users, just like what we did with the manual filter or the sessions at the beginning, and then can click back to return it. We can also apply two or more filters at the same time. So let’s say female users from United States. Let’s click again and reset. So we have two types of filtering and a report interaction Data Studio. The first one is filtering which is clicking on a segment on a graph to filter the rest of the widgets on the same report dashboard. The second one is called brushing, which is the selection of a time period on a chart like time series on an area chart to update the rest of the widgets in the same document to only represent the data for that time period. You can select the date, or any time period that you want.
That’s it. So to recap, today, we learned about six most useful charts and Data Studio and how to use them to create a simple report dashboard like this and it looks good and beautiful as well. We bring scorecards, time series, bar charts, area charts, a map and a pie or donut chart. Plus, we learn how to make our dashboard interactive for the end user. Now it’s your turn, go make some cool dashboards and share the links in the comments section. Thanks for watching and good luck.
All right, so there you have it. Thanks Ahmad for this quick introduction to the different chart types and how you have actually built this dashboard in such a short amount of time. I’m still amazed by this trick of duplicating your data visualizations and then there’s changing the chart types so you don’t have to do all the styling over again. Something I will keep in mind the next time I build a dashboard. What have you taken away from the video? I’d love to hear from you in the comments down below. And if you haven’t yet, then maybe consider subscribing right over there to the channel because we bring you new videos just like this one every week. Now my name is Julian.
See you in the next one.