A Case Study: Advanced Data Transformation in Google Sheets for Data Studio | Accumulated Percentage
In this tutorial, I'll show you how you can transform your data in Google Sheets before importing to Data Studio to achieve more complex calculation/data cleaning process. Advanced SQL-Like Formula (QUERY) is the key to achieve this result :)
We are going to use an example provided by my subscriber and work on it together in this video (Find link below) ! Timestamp are included below so you can feel free to skip.
If you find this kind of problem-solving videos helpful, don't forget to like, comment, subscribe or donate to support this channel! Your kindness is much appreciated! ❤️
👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ https://www.youtube.com/c/Danalyser?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
👉 More BTS:
@ www.instagram.com/danalyser8
This is the link to the question so you can feel free to follow along! 👉🏻 https://stackoverflow.com/questions/7...
T I M E S T A M P
00:00 Our Challenge 💪🏼
02:54 Data Source
04:15 Step 1: Copy Data to Another Sheet
04:55 Step 2: Sort Dataset (QUERY Formula)
05:36 Step 3: Calculate Running Total
07:15 Step 4: Calculate Accumulated Percentage (%)
09:00 Setup Data Studio Report & Result
13:50 Add-Ons: How the automation works?
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studio Course (2023)...
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨
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.]
#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
👉 • Display TODAY's DATE as a TITLE in Da...
⚈ Export Data from Data Studio
👉 • How to Export Data From Google Data S...
⚈ Automation in Data Studio (Email Delivery)
👉 • How to automate data studio report? ✉...
Watch video A Case Study: Advanced Data Transformation in Google Sheets for Data Studio | Accumulated Percentage online without registration, duration hours minute second in high quality. This video was added by user Danalyser 11 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,408 once and liked it 46 people.