Тёмный

2-IN-1 PIVOT TABLE TUTORIAL - Build Google Sheets Pivot Tables in Google Data Studio w/ 3 Examples 

Danalyser
Подписаться 10 тыс.
Просмотров 3,7 тыс.
50% 1

Someone asked you if you can make the table in Google Data Studio to look like one in Google Sheets ? Yes, you can totally do that ! In this tutorial, you'll learn below:
▸ How to group rows in table charts ?
▸ How to create pivot tables with additional horizontal columns ?
▸ How to create pivot tables with dimension values ?
▸ Table Formatting: Can we wrap pivot table headers and values ?
▸ How to add or remove subtotal and grand total rows from the table?
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ ru-vid.com?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
T A B L E C H A R T S T U T O R I A L 👇
❶ Add Conditional Formatting to Table - • Tutorial: Conditional ...
❷ Date Comparison Metrics in Table Chart - • GDS Dynamic Date Compa...
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studi...
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: 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.]
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.
T I M E S T A M P
❶ 00:00 👉🏻 Start
❷ 01:16 Example 1: Group Table Rows by Category
❸ 06:22 Example 2: Add Columns to Pivot Table
❹ 08:51 Example 3: Pivot Table with Text as Metric
#GoogleDataStudio #Danalyser

Опубликовано:

 

31 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 16   
@dragon3602010
@dragon3602010 Год назад
Awesome thanks 🔥🔥👍🏼
@danalyser
@danalyser Год назад
You’re so welcome 😊😊❤️
@dubey_ji
@dubey_ji Год назад
you're awesome
@danalyser
@danalyser Год назад
Hey Abhishek! Thank youuu! Hope you enjoyed the tutorial 😄😄
@user-lt7zn9hn9r
@user-lt7zn9hn9r Год назад
Hi! Is there a way or trick to wrap text like in normal tables?? Sometimes text gets truncated and you can't really change the column thickness if you're in visualization mode! I find it so frustrating that there is no wrap text option to select like in normal tables..!
@danalyser
@danalyser Год назад
Hey! 👋 I wish they have this option available for pivot table as well, but unfortunately no at the moment.
@shankarmanjal4577
@shankarmanjal4577 Год назад
Hi i have query
@skyngmusic1557
@skyngmusic1557 Год назад
Are u in KL?
@aryakurniasandi9671
@aryakurniasandi9671 Год назад
can u give some example data ? i wanna learn to be data analyst,sorry if my english bad
@danalyser
@danalyser Год назад
Hey sure thing, you may look for my beginner course for Google Data Studio :) we’ll have a free dataset there for your practice! 😊
@leighgan985
@leighgan985 Год назад
Is there a way to transfer metric to rows instead of columns - like if you have multiple metrics
@danalyser
@danalyser Год назад
You may have to preprocess the table, unpivot the table again so that you have only a column named metrics and a column for the values :)
@leighgan985
@leighgan985 Год назад
@@danalyser its me again. I would like to ask related to this video. Is there a way to custom sort date stored as text in Pivot table? I know how to do it in a table in GDS but not in Pivottable.
@danalyser
@danalyser Год назад
@@leighgan985 helo! Was wondering how you do it in table? If it works in table, it should be working in pivot table 🤔
@leighgan985
@leighgan985 Год назад
@@danalyser sent you the video through your email. Hope you will have time to view it. Thank you
@danalyser
@danalyser Год назад
@@leighgan985 Thanks for the video! I've replied to that and let's continue our conversation over there :)
Далее
Ouch.. 🤕
00:30
Просмотров 9 млн
Google Sheets Pivot Tables - Basic Tutorial
5:53
Просмотров 464 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Create and Use Pivot Tables in Google Looker Studio
5:22