LSM Cohort 6

01-01 Looker Studio Masterclass Program Structure

01-02 Looker Studio Essentials

01-03 User Interface Explained

01-04 Live Workshop: Creating an eCommerce Dashboard in Looker Studio - Part 1

01-05 Live Workshop: Creating an eCommerce Dashboard in Looker Studio - Part 2

01-06 Sharing Your Looker Studio Report

02-01 Overview of Chart Types in Looker Studio

02-02 Scorecards

02-03 Tables

02-04 Pivot Tables

02-05 Time Series

02-06 Area Charts

02-07 Line Charts

02-08 Combo Charts

02-09 Bar Charts

02-10 Geo Charts & Google Maps

02-11 Pie Charts & Donuts

02-12 Scatter & Bubble Charts

02-13 Tree Maps

02-14 Bullet Charts

02-15 Gauge Charts

03-01 Dashboard Planning: STQA Framework

03-02 Bringing in Your Data

03-03 Data Connectors

03-04 Live vs Warehoused Connectors

03-05 Google Connectors

03-06 Partner Connectors

03-07 Data Sources

03-08 Data Source Scope: Embedded vs Reusable

03-09 Caching & Data Freshness

03-11 Assignment

04-03 Aggregation

04-04 Aggregating Ratios: The Correct Method

04-05 Auto Aggregation

04-06 Data Modeling: Working with Numbers

04-07 Scope of Custom Fields: Chart vs Data Source

05-01 Clean & Normalize Data: Text Functions

05-02 Text Functions: CONCAT()

05-03 Text Functions: LOWER() & UPPER()

05-04 Text Functions: LENGTH()

05-05 Text Functions: CONTAINS_TEXT(), STARTS_WITH(), and ENDS_WITH()

05-06 Text Functions: LEFT_TEXT() and RIGHT_TEXT()

05-07 Text Functions: REPLACE() and REGEXP_REPLACE()

05-08 REGEXP_EXTRACT()

05-09 REGEXP_MATCH()

05-10 Every Chart is a Table

05-11 Additional Resources

06-01 Grouping Data with IF()

06-02 The CASE Function

06-03 Grouping 404 Pages with CASE Function

06-04 CASE Functions with Multiple Clauses

06-05 Tips for Editing Formulas in Looker Studio

06-06 Using CASE Function for Cleaning Data

06-07 Order of WHEN Clauses in CASE Function

06-08 Returning Expressions in CASE Functions

06-09 Using CASE to Extract URL Query Parameters

06-10 Mixing Dimension & Metrics in CASE

06-11 CASE Function: Aggregating Results

06-12 IMAGE() & HYPERLINK() Functions

07-01 Data Visualization Best Practices

07-02 Visualizing KPIs & Metrics

07-03 Visualizing Distribution

07-04 Visualizing Trend over Time

07-05 Comparison Across Categories

07-06 Visualizing Relationship

07-07 Adding Context

07-08 Communicating Status

07-09 Eliminating Distractions: Data-ink Ratio

07-10 Using Colors in Data Visualization

07-11 Clarity: Tell, Don’t Show!

07-12 Report Examples: Good, Bad, and Great

08-01 Mastering Your Style

08-02 Report Layout Customization

08-03 Theme Customization

08-04 Dimension Color Management

08-05 Page Level Theme & Layout Settings

08-06 Time Saving Techniques

08-07 Effective Communication

08-08 Community Visualizations

09-01 Introduction to Data Blending

09-02 One Chart, One Data Source

09-03 Data Blending: Behind the Scenes - Theory

09-04 Data Blending: The Simple Blend

09-05 Data Blending: Behind The Scenes - Live Demo

09-06 Data Blending: Calculated Fields & Dealing with Nulls

10-01 Intro & Limitations of Old Data Blending

10-02 Left Outer Join in Looker Studio

10-03 Data Blending: Data Enrichment

10-04 Data Blending: Paid Ads Cost

10-05 Data Blending: De-Aggregation

10-06 Right Outer Join

10-07 Inner Join

10-08 Full Outer Join

10-09 UNION (with Full Outer Join)

10-10 Cross Join

11-01 Intro & Dimension Filters

11-02 Metric Filters

11-03 Filters Live in Data Sources

11-04 Managing Filters

11-05 Filters vs GA Segments

11-06 Controls: Data Control

11-07 Date Range Control

11-08 Filter Controls

11-09 Filtered Filter Controls

11-10 Advanced Filter Controls

11-11 Chart Cross Filter

11-12 Controls Filter Controls

11-13 Scope of Controls

12-01 Introduction to Parameters

12-02 Use Cases for Parameters

12-03 Properties of Parameters

12-04 Parameters: From Creation to Visualization

12-05 Parameters: Range of Values

12-06 Parameters on Charts

12-07 Scope of Parameters

12-08 Parameter Example: Google Maps Link

12-09 Parameter Example: UTM Generator

12-10 Parameter Example: Dynamic Dimension

12-11 Parameter Example: Dynamic Metric

12-12 Parameter Example: Dynamic Comparison

12-13 Parameter Example: Dynamic Filter Controls

12-14 Parameter Example: Projection & Custom Calculators

12-15 App View

12-16 Parameters in Dynamic SQL for BigQuery

12-17 Parameter Example: The Journey Framework

12-18 Running Calculations

13-02 Bridge Fields

13-03 Bridge Filters

13-04 Filtering Blended Data Sources

13-05 Bridge Parameters

13-06 Page vs Report Level Parameters

13-07 Metric Sliders

13-08 Optional Metrics

13-09 Chart Dimension Drill Down

13-10 Link Navigation

13-11 Dynamic Date Range Granularity Selector

13-12 Managing Pages & Sections in Navigation Sidebar

14-01 The Date Functions

14-02 Calculating Membership Duration with CURRENT_DATE()

14-03 Advanced Date Range Selector

14-04 WEEKDAY() Function

14-05 DATETIME_ADD() in Looker Studio

14-06 DATETIME_DIFF() in Looker Studio

14-07 EXTRACT() and DATE() in Looker Studio

14-08 Embedding Videos in Looker Studio

14-09 Embedding Forms in Looker Studio

14-10 Embedding Google Docs in Looker Studio

14-11 Quicker Data Freshness with Blending & BigQuery

14-12 Extract Data in Looker Studio

14-13 Creative Use Cases for Extract Data in Looker Studio

14-14 Discussion: Dashboard Types in Looker Studio

14-15 Discussion: Dashboard Design and Layout Considerations

16-01 Introduction to BigQuery

16-02 Why Do We Need BigQuery?

16-03 What is BigQuery?

16-04 BigQuery Pricing Explained

16-05 How Fast is BigQuery?

16-06 When Should we Consider BigQuery?

16-07 Google Sheet vs BigQuery Data Pipeline

16-08 Importing Data into BigQuery

16-09 Importing Google Analytics Data to BigQuery

16-10 Importing Data from Marketing Tools into BigQuery

16-11 Working with Data in BigQuery with SQL

16-12 Connecting Looker Studio to BigQuery

16-13 BigQuery & Looker Studio Case Study: Affiliate Performance Dashboard

16-14 BigQuery & Looker Studio Case Study: Labor Performance

16-15 Shopify, Klavyio RFM Segmentation with BigQuery ML

16-16 Store Inventory Capacity Outlook: BigQuery and Looker Studio Case Study

16-17 Location Exploration Case Study with BigQuery and Looker Studio

16-18 Discussion: BigQuery and BigQuery ML Use Cases

17-01 BigQuery & Looker Studio: A Hands-on Workshop

17-02 Planning the Data Pipeline

17-03 Getting Data into BigQuery

17-04 SQL Workspace in BigQuery

17-05 Bringing a Google Sheet into BigQuery

17-06 Table Schema in BigQuery

17-07 External Tables in BigQuery

17-08 Writing SQL in BigQuery

17-09 Data Modeling in BigQuery

17-10 SQL Join in BigQuery

17-11 Calculating % Share of Total using SQL

17-12 Calculating Keyword Ranking in BigQuery SQL

17-13 Saving Queries in BigQuery and Connecting to Looker Studio

17-14 Creating Views in BigQuery

17-15 Scheduled Queries in BigQuery