Data Connectors: Connect to Google Sheets
In order to learn Google Data Studio, you would need a data set to work with. By following the step-by-step guide provided in this tutorial, you will be able to create sample company Sales Reports with dummy data provided for you.
The YHK Store Sample Data is made possible using free online text and number generator tools.
YHK Store Sample Data
Download YHK Store Sample Sales Data
Copy This Google Sheet Data File To Your Google Account
Make a copy of this YHK Store Sample Data and store it under the same Google Account which you will be using for Google Data Sheet later.
What's In The Data?
- Transaction ID – Sale Transaction Number generated by the Company. There are total 3000 transactions in the data
- Order Date – Date the order was made by the customer
- Customer – Customer’s name on the order.
- Deliver To – State the Country of Delivery
- Sales Representative – Sales representatives working at YHK Store
- Item – Item the customer ordered
- Quantity – Quantity of the item ordered
Prepare Your Data
Cells should only contain data
The first row of the data should contain column headers
How to connect to Google Sheets?
The first step in creating a data source is to establish a connection with the data in Google Sheets.
After you have signed in to Google Data Studio, click on CREATE on the Top Left Corner.
Create Data Source
Choose Google Sheets as your Google Data Connector
Choose and type an appropriate name for this Data Set. Browse to the YHK Store Sample Data which you have downloaded under your own Google Account
Ensure <Use First Row As Headers> and <Include Hidden and Filtered Cells" are checked.
Next, click on CONNECT at the Top Right corner. You should now see a table like the one below.
Check to ensure that Google Data Studio has correctly identified the data type for each field. Usually data types which require amendments or corrections are "Country", "Date" and "Currency".
Once everything is in order, click on the "CREATE REPORT" button.
Add Data to Report
Click ADD TO REPORT to continue.
Congratulations, you have successfully connected to the YHK Store Sample Data. Read on to find out how you can create your first Visualisation Report.
Data Connectors - Connect to Google Sheets
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.
Questions & Answers
© 2020 Heng Kiong Yap