Updated date:

Your First Visualisation Report Using Google Data Studio

Heng Kiong teaches Information Technology, including business analytics and management information systems, at a tertiary institute.

Recap

Google Data Studio is a free service by Google for creating interactive reports. In the last article, you have successfully imported (using Google Sheets Data Connector) data from Google Sheets. You are now ready to visualize it in charts and tables, and make interaction with the Report in real time.

Google Data Studio allows you to automate your Report. Once you have created a dashboard, you can share it with others to self-serve that data, giving them easier access to what they need.

How to build your first report

your-first-visualisation-report-using-google-data-studio

Now that you have linked your data in Google Sheets, it’s time to build your first Report.

There are many different types of charts, tables, and scorecards that you can add to your dashboard in Google Data Studio.

  • Table
  • Scorecard
  • Time Series
  • Bar
  • Pie
  • Geo Map
  • Line
  • Area
  • Scatter
  • Pivot Table
  • Bullet
  • Treemap

Chart Elements To Visualise Your Data in Google Data Studio

your-first-visualisation-report-using-google-data-studio

Building a dashboard from scratch

We will not be using any of the templates or reuse reports built by the community. Instead we shall create a new Report from scratch.

Google Data Studio makes it extremely easy for anyone, even without technical knowledge or prior experience in data visualisation, to create custom dashboards that pull from multiple data sources.

In this tutorial, we are going to build a simple Sales Report Google Data Studio dashboard.

Give an appropriate name to your first Report and delete any charts that has been auto added by Google Data Studio.

your-first-visualisation-report-using-google-data-studio

Click on the "Add a Chart" button on the toolbar and then click on the Table icon.

Add a Table To Your Report

your-first-visualisation-report-using-google-data-studio

Click anywhere on the Canva to add that Table

your-first-visualisation-report-using-google-data-studio
your-first-visualisation-report-using-google-data-studio

Adding Fields To The Report

Look to the right, can you see all the fields which correspond to the YHK Company Sales Sample Data in Google Sheets?

Click "Add Dimension" and start to add all fields in the following sequence.

your-first-visualisation-report-using-google-data-studio
DIMENSIONMETRICS

Transaction ID

Quantity

Order Date

 

Customer

 

Deliver To

 

Item

 

Sales Representative

 

Drag the Table so that it occupies the entire width of the page.

your-first-visualisation-report-using-google-data-studio

Adding Fields To Dimension and Resizing Table

your-first-visualisation-report-using-google-data-studio

Next, we are just going to add a title to the Page to finish off your first Google Data Studio Report.

your-first-visualisation-report-using-google-data-studio

From the right, choose the Font type and Size.

your-first-visualisation-report-using-google-data-studio
your-first-visualisation-report-using-google-data-studio

What's Next

Click on the Title you have just entered, select Make Report Level so that it will appear on each page of your report.

Congratulations, you have just created your first Google Data Studio Report.

Google Data Studio unlocks the power of your data with interactive dashboards and beautiful reports.

Up next, we will learn how to turn your Report interactive for richer reporting.

Navigation

Learn How to Use Google Data Studio to Visualise Data Easily

Google Data Studio - Getting Started

Data Connectors - Connect To Google Sheets

Your First Visualisation Report using Google Data Studio

Richer Interactive in Google Data Studio

About Filter Control In Google Data Studio

Using Charts as Interactive Filters in Google Data Studio

Managing Data Sources in Google Data Studio