Advanced Data Visualisation with Google Data Studio

In this article, we are going to learn how to implement specific data visualizations to allow you to interpret data using charts and tables. It is recommended that you read the previous articles in our ‘how to’ series before moving onto this on:.

In this article, we will be exploring 3 types of charts on Google Data Studio.

Scatter Charts
Bullet Charts
Tables

This article consists of 11 steps to demonstrate how to use these charts to visualize your data in an interactive way.

Scatter Charts

Scatter charts show how one variable is affected by another. This relationship is known as ‘correlation’.

An example of this might be a comparison of clicks per campaign or total spend per day. The position of the individual dots on a scatter chart enables you to see the relationship between two different campaigns or daily expenditures. One dot is plotted along the ‘X’ axis, and the other along the ‘Y’ axis showing you how one variable is affected by another.

1) The first step is to select the ‘scatter chart’ option from the ‘add a chart’ drop-down menu and position it on your report.


For this example, we will explore the relationship between the total number of sessions and the total number of page views.

2) The scatter chart is set to default which displays the total number of sessions on the ‘X’ axis, and total page views on the ‘Y axis’. In order to change these metrics, simply click on the metrics and select one from the list.

3) In order to identify which data points refer to a certain category of information, it is necessary to add in the product category name as a label. To do this, select the ‘style tab’ then click the checkbox ‘show data labels’. Finally, you have the option of changing the colour of the data points.

4) In order to view data from previous weeks, months or even years, switch to view mode and set the date range of your report. The charts are interactive so it is possible to see the data points as you move your cursor over the graphs.

Bullet Charts

5) Bullet charts are typically used to display performance data and display progress towards a certain goal. Ie: Revenue, expenses, volume. Bullet charts can be both vertical and horizontal.To add a bullet chart, simply click ‘add chart’ in the quick links and select ‘bullet’.

6) On the right hand side of the page, there are options to set the metrics that you want to display. The range limits set the lower, middle and upper targets for the metric.

For this example, the bullet chart is set to default which displays the total number of sessions.

It is important to note that the date range needs to be adjusted accordingly.

Below the following values have been set: Target value: 4200, Range 1: 1800, Range 2: 3600, Range 3: 5400

7) It is also possible to change the colour of the metric bar and the range of the bullet chart.

8) To view your bullet chart, select ‘view’ mode in the top right hand corner of your screen.

Tables

A table is used to organize and display information in columns and rows.

9) To add a table with bars, select ‘add chart’ from the dropdown menu in the ‘quicklinks’ and select ‘table with bars’.

On the right-hand side of the page there are options to select different metrics and dimensions. For this example, we have added ‘month of the year’ as an additional dimension and ‘users’ and ‘new users’ as additional metrics.

10) It is possible to view months in descending order in order to display the latest data at the top of the table. It is important to note that the date range needs to be adjusted accordingly.

It is also possible to remove the row numbers from the ‘style tab’.

11) In the ‘style tab’ you will see a list of options for each column in the table. A number, bar or heatmap can be selected. Similar to the bullet chart, it is also possible to set a target value. The target value line will appears once the target goal has been set. It is also possible to change the colour of the bars.

All of the above options can be applied to each column of the table. Select your desired style based on the information you would like to display. In this example, we used the following options: Column 1: Bar, Target value: 950, Column 2: Heatmap, Column 3: Heatmap.

The Ultimate Charts & Graphs Guide for Google Data Studio

This article is a continuation of our previous article where we covered how to connect and display your Google Analytics data, creating an interactive dashboard using time series charts. In this article we are going to explore time series charts in more depth, as well as focusing on bar and pie charts.

This guide consists of 8 steps to help you better understand the various charts that Google Data Studio has to offer.

If you missed our previous article, ‘How to: Connect Google Analytics to Google Data Studio’, you might want to check it out before progressing as it provides an explanation of how to add and edit a time series chart using analytical data.

Bar Charts

Step 1 – Segmentation

First, it’s important to include some segmentation to see which marketing channel has brought in the most traffic over a specified period of time. For this, a bar chart is the most effective data visualisation tool.

You need to select the bar chart option from the ‘Add a chart’ drop-down menu and position it wherever you feel it is most suitable on your report.

Step 2 – Metrics

The bar chart is set to default which displays the total number of sessions by traffic medium. If you would like to change these metrics, simply click on the metric ‘sessions’ and select one from the list. It is important to note that your bar chart has to be selected before attempting to change the data.

Step 3 – Date Range

The final thing you need to do is change the date range so that only the previous month’s data is displayed.

Step 4 – Chart Appearance

You have the option to change the orientation of the chart which could give you a better visualisation of the category names and the information displayed. In order to do this, select the ‘Style’ tab in the top right-hand corner of the report and then select the horizontal orientation. If you would also like to see data labels, so that you don’t have to scroll over the chart to see the total number of sessions, click the checkbox ‘show data labels’. Finally, you have the option of changing the colour of your chart.

Pie Charts

Step 5 – Split by Channel

Pie charts can be useful to display percentage or proportional data. Continuing with our theme of traffic via different marketing channels, it’s possible to establish the effectiveness of each channel, by using a pie chart.

To add a pie chart, simply click ‘add chart’ in the quick links and select ‘pie chart’.

For this example, the pie chart is set to default which shows the total number of sessions by traffic medium. If you would like to change these metrics simply click on the metric ‘sessions’ and select one from the list. It is important to note that your pie chart must be selected before attempting to change this data. Don’t forget to set the custom date range to the correct time period!

Step 6 – Pie Chart Appearancee

There are a few styling options available for your pie chart. A useful facility is to use the ‘Doughnut’ option.

This can be done by using the slider to increase and decrease the size of the hole in the middle. It is also possible to limit the number of segments shown on the pie chart. Simply select the number of segments you would like to be shown from the drop-down menu.

Area charts


Step 7 – Trend Analysis

Area charts are most useful when facilitating trend analysis and are a good choice in order to see time series data broken down by categories. In this example, we would like to understand which marketing channels have contributed to the overall trend we see in traffic. Select an area chart from the ‘add chart’ drop-down menu, in the quick links menu.

If you would like to change these metrics, simply click on the metric ‘source’ or ‘sessions’ and select one from the list. It is important to note that your area chart must be selected before attempting to change this data.

Step 8 – View the report

To see your report as others would view it, click ‘view’ at the top right of the page. This is different from how you would see it in the edit mode. You will notice that the charts are interactive which allows you to see the data points as you move your cursor over the graphs.

Don’t miss the next article in our ‘how to’ series: ‘How to make your dashboard interactive with filters’!