Updated date:

Managing Data Sources in Google Data Studio

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

Data Refreshness

A good Report performance is determined by how quickly the report loads and also how updated the Data is. Maintaining Data freshness is one important aspect in Data Visualisation.

Go back to the Home page of Google Data Studio. Click on the data source "YHK Company Sales Data". Notice that the Data Freshness shown as 15 minutes. This means that data source checks for fresh data every 15 minutes.

Different types of reports have different data refreshness requirements; highly dependant on the type of Data Sources you are connected with.

Visit Google Support by for Data refresh rates by Connector.

managing-data-sources-in-google-data-studio
managing-data-sources-in-google-data-studio

Field Editing in Reports: ON

By default, the field names as appeared in the Report matches the underlying data. Google Data Studio By setting the Field Editing in Reports to be ON, you allow you as the Report editor to change field definitions at the chart level.


Click the 3 horizontal blue bar to go back to Google Data Studio's homepage.

managing-data-sources-in-google-data-studio

Click on YHK Company Sales Report

managing-data-sources-in-google-data-studio

An error has occurred.

managing-data-sources-in-google-data-studio

Turn "Field editing in reports" back to ON.

managing-data-sources-in-google-data-studio

Field Editing in Reports: ON

Open up your Report in Edit Mode. Switch to Page 1 of your Report.

Click on the Pencil icon next to "Item" and change its name to "Item Sold".

Notice that Table in your Report has been updated with the new name.

However, renaming here does not change anything in the original data sets at Google Sheets.

managing-data-sources-in-google-data-studio
managing-data-sources-in-google-data-studio

Manage Added Data Sources

Next up, we are going to try something new.

Let's make a change at Google Sheets and learn how can the change be effected at Google Data Studio.

Change "Quantity" to "Quantity Ordered" in Google Sheets.


managing-data-sources-in-google-data-studio
managing-data-sources-in-google-data-studio

To fix this error, do the following:

In "Edit" mode, click Resource -> Manage Added Data Sources

managing-data-sources-in-google-data-studio

Click "Edit" next to the YHK Company Sales Data

managing-data-sources-in-google-data-studio

Click "Refresh fields"

managing-data-sources-in-google-data-studio

Note the change which Google Data Studio has detected.

Click "Apply" to continue, followed by "Done" and then "Close"

managing-data-sources-in-google-data-studio

You still get the same error message. That is because you have to manually add the "new" metric to the Report as shown below.

managing-data-sources-in-google-data-studio

Go through, one by one, all the charts which have been affected by this change. Manually add the 'new' metric to the Reports.

managing-data-sources-in-google-data-studio

The charts are now back to function with the updated new field name.

managing-data-sources-in-google-data-studio
managing-data-sources-in-google-data-studio

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

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2020 Heng Kiong Yap