Google Looker Studio Intermediate to Advanced | Insights Training
Data visualization

Google Looker Studio Intermediate to Advanced

An intensive hands-on course for experienced Looker Studio users who need to manage more complex data sources, blend data, build calculated fields, apply transformation functions, resolve aggregation issues, and use Gemini to develop and troubleshoot formulas. Participants apply each technique to practical reporting scenarios and validate results against source data.

Join a Public ClassRequest Company Training

Build practical capability for workplace application.

An intensive hands-on course for experienced Looker Studio users who need to manage more complex data sources, blend data, build calculated fields, apply transformation functions, resolve aggregation issues, and use Gemini to develop and troubleshoot formulas. Participants apply each technique to practical reporting scenarios and validate results against source data.

Manage multiple data sources, reusable fields, refreshes, replacements, and field properties
Blend related data sources using appropriate join types, keys, filters, and granularity
Create calculated dimensions and metrics using conditional, text, numeric, date, and aggregate functions
Clean imported values, handle nulls, standardize categories, and troubleshoot incompatible fields
Use Gemini to draft, explain, refine, test, and troubleshoot Looker Studio formulas
Validate advanced calculations and blended results against the underlying source data

Who this training is for

  • Looker Studio users who already create basic reports, charts, filters, and calculated fields
  • Analysts, dashboard developers, report owners, and advanced spreadsheet users
  • Professionals combining multiple datasets or performing more complex data transformations
  • Teams using Gemini to accelerate formula development while maintaining validation and control

Training methodology

Instructor demonstrations, guided builds, formula walkthroughs, blending exercises, and troubleshooting drills. Hands-on application using related datasets, Gemini-assisted formula work, validation checks, and instructor feedback.

Course Overview

Open a module to see its full coverage.

1. Advanced Data Source Management
  • Managing multiple data sources
  • Reviewing and modifying field properties
2. Data Blending and Joins
  • Understanding blended data
  • Selecting tables and fields for a blend
3. Calculated Fields and Expressions
  • Data-source, chart-level, and blended calculated fields
  • Calculated dimensions vs. calculated metrics
4. Essential Functions for Data Transformation
  • Logical and Conditional
  • CASE, IF, IFNULL
5. Advanced Field and Data Techniques
  • Creating custom classifications with CASE
  • Grouping and bucketing values
6. Gemini-Assisted Formula Development and Troubleshooting
  • Translating requirements into Looker Studio formulas
  • Providing field names, types, and sample values to Gemini
7. Hands-On Application
  • Participants apply the techniques throughout the workshop to:
  • Combine multiple related data sources

Full course outline

View every topic from the source course outline.

View full outline

1. Advanced Data Source Management

  • Managing multiple data sources
  • Reviewing and modifying field properties
  • Data types and default aggregations
  • Data-source vs. chart-level fields
  • Refreshing, reconnecting, and replacing data sources
  • Managing reusable fields across reports
  • Troubleshooting common data-source and field errors

2. Data Blending and Joins

  • Understanding blended data
  • Selecting tables and fields for a blend
  • Identifying and configuring join keys
  • Left, Right, Inner, Full Outer, and Cross joins
  • Adding dimensions and metrics from different sources
  • Understanding join behavior and unmatched records
  • Aggregation and granularity in blended data
  • Filters and controls with blended sources
  • Troubleshooting duplicate, missing, and unexpected results
  • Understanding the limitations of data blending
  • Advanced techniques for blending, transforming, calculating, troubleshooting, and validating report data.

3. Calculated Fields and Expressions

  • Data-source, chart-level, and blended calculated fields
  • Calculated dimensions vs. calculated metrics
  • Arithmetic expressions and operators
  • Conditional calculations
  • Row-level vs. aggregated calculations
  • Data type conversion
  • Handling null and blank values
  • Creating reusable calculated fields
  • Formula validation and troubleshooting

4. Essential Functions for Data Transformation

  • Logical and Conditional
  • CASE, IF, IFNULL
  • AND, OR, and comparison operators
  • Text
  • CONCAT, REPLACE, TRIM
  • UPPER and LOWER
  • Text matching and extraction
  • Basic regular expressions
  • Numeric
  • ROUND
  • Arithmetic operators
  • Type conversion
  • Ratios and percentage calculations
  • Date and Time
  • PARSE_DATE
  • Date type conversion
  • Extracting year, month, and other date components
  • Date arithmetic and comparisons
  • Aggregation
  • SUM, AVG, MIN, MAX
  • COUNT and COUNT_DISTINCT
  • Combining aggregation with calculated fields
  • Advanced techniques for blending, transforming, calculating, troubleshooting, and validating report data.

5. Advanced Field and Data Techniques

  • Creating custom classifications with CASE
  • Grouping and bucketing values
  • Creating dynamic labels and categories
  • Standardizing inconsistent text values
  • Cleaning imported data
  • Converting text-based numbers and dates
  • Handling missing and null values
  • Creating conditional metrics
  • Working with calculated fields in filters and controls
  • Understanding aggregation errors and incompatible fields

6. Gemini-Assisted Formula Development and Troubleshooting

  • Translating requirements into Looker Studio formulas
  • Providing field names, types, and sample values to Gemini
  • Generating calculated-field formulas from natural language
  • Generating CASE and conditional expressions
  • Creating text, numeric, and date transformations
  • Explaining and simplifying existing formulas
  • Diagnosing formula and syntax errors with Gemini
  • Checking function compatibility with Looker Studio
  • Testing and validating AI-generated calculations
  • Refining prompts when generated formulas fail

7. Hands-On Application

  • Participants apply the techniques throughout the workshop to:
  • Combine multiple related data sources
  • Configure and troubleshoot joins
  • Create calculated dimensions and metrics
  • Perform text, numeric, and date transformations
  • Build conditional and aggregated calculations
  • Handle nulls and data-quality issues
  • Use calculated fields in charts, filters, and controls
  • Generate and troubleshoot formulas using Gemini
  • Validate calculated results against source data

Bring this program to your team.

Tell us your audience, goals, schedule, and preferred delivery format.

Request a Proposal