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 types 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.
