ABCDE
1
VideoURLSeenAgain?Note
2
1.1. What to Expect from Looker Studio Masterclass? (Full Beginner to Advanced Training)www.youtube.com/watch?v=FrY462bn5SY
3
1.2. What's Looker Studio? (Formerly Google Data Studio) (Looker Studio Tutorial for Beginners)www.youtube.com/watch?v=-6iJG28A7cs
4
1.3. Looker Studio User Interface Explained (Looker Studio Beginner Tutorial)www.youtube.com/watch?v=Lea39a9YpWY
5
1.4. eCommerce Dashboard: Looker Studio Tutorial - Part I - KPI Overviewwww.youtube.com/watch?v=MTcPR0lfPNM
6
1.5. eCommerce Dashboard: Looker Studio Tutorial - Part II - Cost vs Profitwww.youtube.com/watch?v=OZ1cugob-Uc
7
1.6. Options for sharing your dashboard with others (Looker Studio Masterclass)www.youtube.com/watch?v=7uGfw6sVSF8
8
2.1. Chart Types in Looker Studio (Looker Studio Masterclass) - Tutorial (Google Data Studio)www.youtube.com/watch?v=WKGIFU_kbjE
9
2.2. Scorecards: Instant Metric Snapshots - Looker Studio Masterclass - Google Data Studio Tutorialwww.youtube.com/watch?v=xDiAPoPuniA
10
2.3. Tables: Organize Data With Clarity (Looker Studio Masterclass) - (Google Data Studio Tutorial)www.youtube.com/watch?v=ze5KxAjJlro
11
2.4. Pivot Tables: Analyze Data Like Magic! Looker Studio Masterclass - Google Data Studio Tutorialwww.youtube.com/watch?v=ZewNx1MyM20
12
2.5. Time Series: Uncover Trends & Patterns - Looker Studio Masterclass - Data Studio Tutorialwww.youtube.com/watch?v=yTRfo7DqDzI
13
2.6. Area Charts: Distribution & Volume Trends - Looker Studio Masterclass - Data Studio Coursewww.youtube.com/watch?v=ALuqE5Zrryw
14
2.7. Line Charts: Clarify Data Connections - Looker Studio Masterclass - Data Studio Tutorialwww.youtube.com/watch?v=BY0r5iRUSj4
15
2.8. Combo Charts: Combine Series for Dual Impact - Looker Studio Masterclass - Google Data Tutorialwww.youtube.com/watch?v=KUhLHXuZ-4Y
16
2.9. Bar Charts: Comparison Made Simple (Looker Studio Masterclass) - Tutorial (Google Data Studio)www.youtube.com/watch?v=O4HzJPiGOlo
17
2.10. Geo Charts & Maps: Unearth Hidden Geospatial Patterns - Looker Studio Masterclasswww.youtube.com/watch?v=OgbIH9t_ZP4
18
2.11. Pie Charts: Stay Away or Do It Right! Looker Studio Masterclass - Data Studio Tutorialwww.youtube.com/watch?v=msaOpOghj1M
19
2.12. Scatter & Bubble Charts: Explore Data Relationships - Looker Studio Masterclasswww.youtube.com/watch?v=2YjPJJozcqo
20
2.13. Tree Maps: Visualize Data Hierarchies - Looker Studio Masterclass - Data Studio Tutorialwww.youtube.com/watch?v=5fxwXl0VdVE
21
2.14. Bullet Charts: Track Targets & Performance - Looker Studio Masterclass - Data Studio Tutorialwww.youtube.com/watch?v=pok5cehf5zU
22
2.15. Gauge Charts: Keep An Eye on Performance - Looker Studio Masterclass - Data Studio Coursewww.youtube.com/watch?v=sQLB3rKS3-I
23
3.1. Dashboard Planning: STQA Framework (Looker Studio Masterclass) (Data Studio tutorial)www.youtube.com/watch?v=mbcHh0Ov2L8
24
3.2. Bringing in Your Data (Looker Studio Masterclass) (Data Studio tutorial)www.youtube.com/watch?v=CpazudU1jgc
25
3.3. Data Connectors (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=e181FzYG_9I
26
3.4. Live vs Warehoused Data Connectors (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=cRWz83yZLO0
27
3.5. Google Connectors (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=6IDNsh9zcm4
28
3.6. Partner Connectors (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=B1LRxgzRE10
29
3.7. Data Sources (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=vEBxNnEa-8Q
30
3.8. Embedded vs Reusable Data Sources (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=Vnuoq9zxAPk
31
3.9. Data Freshness & Caching (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=aQ5Lzdiv-tI
32
3.10. Managing Data Sources (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=MWd6ZKid6OA
33
3.11. Dashboard Planning Assignment (Looker Studio Masterclass) (Google Data Studio tutorial)www.youtube.com/watch?v=x0635HT3xI4
34
4.1. Aggregation & Working with Numbers (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=V9FuHieuPjI
35
4.2. Data Sources in Depth (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=uzZnBC0_xZU
36
4.3. Understanding Aggregation (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=5cOoZpxCGNg
37
4.4. Aggregating Ratios: the Correct Way (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=4XeK_Qw9Wtk
38
4.5. Understanding AUTO Aggregation (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=qg6klMbNBwA
39
4.6. Working with Numbers: Math Operations (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=kjgpYCn1fZ8
40
4.7. Scopes of Custom Field: Chart vs Data Source (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=TXy-slTirsg
41
5.1. Intro to Text Functions (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=lavfhfG8ANo
42
5.2. Cleaning & Normalizing Data: CONCAT() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=SQwblByFwd0
43
5.3. LOWER() & UPPER() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=6-6GR882aoc
44
5.4. LENGTH() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=EOyhtGjOUp0
45
5.5. CONTAINS_TEXT(), STARTS_WITH(), ENDS_WITH() (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=Xq4DvetAtGI
46
5.6. LEFT_TEXT() and RIGHT_TEXT() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=xZe5VB2njGY
47
5.7. REPLACE() and REGEXP_REPLACE() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=GtY6zcZd-5Q
48
5.8. REGEXP_EXTRACT() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=lmnZiWTQxuI
49
5.9. REGEXP_MATCH() (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=FW9DX_CvGC0
50
5.10. Every Chart is a Table! (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=RjcSJprlCIU
51
5.11. Recap, Assignment, Q&A and Further Discussion (Looker Studio Masterclass)www.youtube.com/watch?v=KjzG1S7kIbM
52
6.1. Grouping & Categorizing Data with IF (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=meHHbQwH7ns
53
6.2. Grouping & Categorizing Data: CASE Function (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=V1kss0RgLTo
54
6.3. Using CASE to Group Pages (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=O5prOcHlS9c
55
6.4. CASE Function Multiple WHEN Clauses (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=iDC6ScxorfI
56
6.5. Tips for Editing Formulas in Looker Studio (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=nW6hChPwTtU
57
6.6. Cleaning Data with CASE Function (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=zvvKN1J-cxM
58
6.7. CASE Function: Order of WHEN Clauses (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=qIGfcyKVeqw
59
6.8. CASE Function: Returning Expressions (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=u7_C5wQIlaE
60
6.9. Extracting URL Query Parameters CASE & RegEx (Looker Studio Masterclass - Data Studio Tutorial)www.youtube.com/watch?v=lKG-A9APFwk
61
6.10. Mixing Dimensions & Metrics (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=Reprl-ndyKk
62
6.11. CASE Function: Aggregating Results (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=-9s3bm0uqGg
63
6.12. IMAGE & HYPERLINK Functions (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=HbaPYCtXl-w
64
7.1. Data Visualization Best Practices (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=OVKbdxF2Czs
65
7.2. Showing KPIs & Metrics (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=AsElkkagE9s
66
7.3. Visualizing Distribution (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=kIQ9g6m2QQo
67
7.4. Visualizing Trend Over Time (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=MjTZ2p6U_0c
68
7.5. Comparing Data Across Categories (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=EJaqz6xt58M
69
7.6. Visualizing Relationships (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=ty5cNaVIET8
70
7.7. Adding Context to Visualizations (Looker Studio Masterclass) (Google Data Studio Tutorial)www.youtube.com/watch?v=JDNhriIxwg4
71
7.8. Communicating Status: Conditional Formatting (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=-Nr3UXGbmXQ
72
7.9. Eliminating Distractions: Data ink Ratio (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=a5Xq8UAxeRo
73
7.10. Tips for Using Colors in Data Visualization (Looker Studio Masterclass) (Data Studio Tutorial)www.youtube.com/watch?v=HsU6oFD-LwE
74
7.11. Tell, don't show! Clarity in Data Visualization (Looker Studio Masterclass)www.youtube.com/watch?v=Jw4F7xY-9NM
75
7.12. Dashboard Examples: Good, Bad, and Uglywww.youtube.com/watch?v=-Bf4YjX8ywE
76
8.1. Mastering Your Dashboard Style (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=51zO31ByaAI
77
8.2. Dashboard Layout Customization (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=jcSBHL-lDBs
78
8.3. Dashboard Theme Customization (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=qjxFuY-UHvA
79
8.4. Dimension Color Management (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=N0dzBYb0_Hc
80
8.5. Page Level Theme & Layout Settings (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=rov6x_3aZHU
81
8.6. Time Saving Techniques (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=8nyC5Za682A
82
8.7. Effective Communication (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=fquDcAzajFM
83
8.8. Community Visualizations (Looker Studio Masterclass) (Google Data Studio Course)www.youtube.com/watch?v=6bZ8GIfA-Xs
84
9.1. Introduction to Data Blending (Looker Studio Masterclass) (Advanced Data Studio Course)www.youtube.com/watch?v=k9S-MT87KUY
85
9.2. One chart, One Data Source (Looker Studio Masterclass) (Advanced Data Studio Course)www.youtube.com/watch?v=YtfUHcbVc-s
86
9.3. Data Blending: Behind the Scenes - Theorywww.youtube.com/watch?v=it50RKRJTP8
87
9.4. Data Blending: The simple Blend (Looker Studio Masterclass) (Advanced Data Studio Course)www.youtube.com/watch?v=bMcE5KbO2LA
88
9.5. Data Blending: Behind The Scenes - Live Demowww.youtube.com/watch?v=zqr6Ou8altE
89
9.6. Data Blending: Calculated Fields & Nulls (Looker Studio Masterclass) (Full Data Studio Course)www.youtube.com/watch?v=OCaT0t-BZLY
90
10.1. Data Blending Join Types - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=F3JMjMCLQW8
91
10.2. Data Blending: Left Outer Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=gOAd6R1O7jM
92
10.3. Data Blending: Data Enrichment - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=y6jrfb5tfKU
93
10.4. Data Blending: Paid Ads Cost - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=cvjBR0T3FoQ
94
10.5. Data Blending: De-Aggregation - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=r50AIYVCdR8
95
10.6. Data Blending: Right Outer Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=F1MAB6BswgM
96
10.7. Data Blending: Inner Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=oENkcU_lxJM
97
10.8. Data Blending: Full Outer Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=BOLZcWYDQQg
98
10.9. UNION using Full Outer Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=4cMh55gJG7A
99
10.10. Data Blending: Cross Join - Looker Studio Masterclass - Advanced Data Studio Coursewww.youtube.com/watch?v=DkaexZc882s
100
11.1. Filtering Charts By Dimension Values (Looker Studio Course) (Google Data Studio Tutorial)www.youtube.com/watch?v=Lq2b6Q7-5ts