In this video, we'll learn how to import and connect Google Sheets data to Google Data Studio. This is the very first step if you wish to transform a spreadsheet into an interactive dashboard.
In addition, some basic concepts related to data source connection in Data Studio would also be covered! :)
Watch the complete tutorial here: https://bit.ly/datastudiocourse2022
Free dataset for download: https://bit.ly/danalyser-sample-data
How to create report with Template (Youtube Analytics) - https://www.youtube.com/watch?v=ydauaDeXUmo
(PS: Course Modules would be released over time.)
T I M E S T A M P
00:00 Overview
00:18 How to Get your Free Data Studio Account ?
00:40 GDS Landing Page Navigation
01:17 Where to Find Free & Professional Templates?
01:54 Let's Start with Creating an Empty Report
02:29 Data Source Connectors
04:47 How to Connect to Google Sheets Data | Method # 1
05:15 How to Connect to Google Sheets Data | Method # 2
08:16 Best Practice
10:05 Metrics vs Dimension (With Example)
12:41 Data Refresh Frequency
F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!
Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser
[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A
Subscribe to my channel @ https://www.youtube.com/channel/UCDEJmST2OTrVDFbKCUdqbxw?sub_confirmation=1
#GoogleDataStudio #Danalyser
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------
W A T C H N E X T
Show current date in dashboard
https://youtu.be/EVQ_nW19eq0
Export Data from Data Studio
https://youtu.be/e7zRFvKHs08
Automation in Data Studio (Email Delivery)
https://youtu.be/A_RRbgt3qjQ