GCP100LOOKERAVD
Analyzing and Visualizing Data in Looker
In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. You learn to leverage Looker's modern analytics platform to find and explore relevant content in your organization's Looker instance. You also discover how to ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.
What you will learn
- Define Looker and the capabilities it provides for working with data.
- Use dimensions, measures, and filters to analyze and visualize data.
- Use dashboards for multiple visualizations and boards to curate Looker content.
- Create advanced metrics by pivoting Looker data and writing table and offset calculations.
- Create visualizations using Looks and dashboards, and share Looker content with others.
Prerequisites
- None
Target audience
- Business users who need to draw insights from data., Data analysts who are responsible for data analysis and visualization within their organizations.
Training Program
6 modules to master the fundamentals
Objectives
- Define the value proposition of the Looker platform.
- Explain Looker's role in the data analysis process.
- Describe Looker's main user interface components.
- Interpret Looker's hierarchical folder structure for content.
- Discuss different content locations within the Looker platform.
Topics covered
- →What is Looker?
- →Looker user interface
- →Organizing content with folders
Activities
1 quiz
Objectives
- Define the purpose of a dimension and measure in Looker.
- Identify where end users work with dimensions, measures, and filters.
- Explain how dimensions, measures, and filters contribute to the larger data analysis process in Looker.
- Identify what asset a dimension corresponds to in your database.
- Identify what SQL functions a measure can correspond to.
- Explain how to filter by a dimension.
Topics covered
- →Dimensions in Looker
- →Measures in Looker
- →Using dimensions and measures
- →Filtering dimensions
- →Filtering measures
Activities
3 demos, 1 lab, 1 quiz
Objectives
- Explain how to filter within a Look and a dashboard.
- Identify where users can work with dashboards and boards, and filter within Looks and dashboards.
- Explain how dashboards, boards, and filtering can contribute to the data analysis process.
- Define the purpose of a dashboard.
- Explain what a board is in Looker.
- Detail the process of creating a board.
- Detail the process for pinning Looks and dashboards to a board.
Topics covered
- →Filtering Looks
- →Introducing dashboards
- →Filtering dashboards
- →Curating Looker content in boards
Activities
1 demo, 1 quiz
Objectives
- Explain the process of pivoting data.
- Identify where users can pivot data, write table calculations, and write offset calculations.
- Identify situations to consider pivoting data and writing a new table calculation.
- Explain how pivoting data, writing table calculations, and writing offset calculations can contribute to the data analysis process.
- Differentiate between a table calculation and an offset calculation.
- Discuss the various types of table calculations.
- Detail the process to write table calculations and offset calculations.
Topics covered
- →Pivoting data in Looker
- →Introduction to table calculations
- →Types of table calculations
- →Writing table calculations
- →Introducing offset functions
- →Writing offset calculations
Activities
4 demos, 1 lab, 1 quiz
Objectives
- Explain how to create a new Look and dashboard in Looker.
- Identify where users can create new Looks and dashboards.
Topics covered
- →Creating new Looks
- →Creating new dashboards
Activities
1 quiz
Objectives
- List the options to share Looks and dashboards once or with a regular schedule.
- Identify where users can send or schedule Looks and dashboards, and configure tile-level dashboard alerts.
- Explain how to configure a shared or scheduled Look or dashboard.
- Discuss how to choose options that are appropriate for a given situation or business case.
- Identify the options to schedule a tile-level dashboard alert.
Topics covered
- →Sharing and scheduling Looks
- →Sharing and scheduling dashboards
- →Tile-level dashboard alerts
Activities
1 quiz
Quality Process
SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach
Teaching Methods Used
- Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
- Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
- Guided Labs — Guided practical exercises on software, hardware, or technical environments.
- Quiz / MCQ — Quick knowledge check (paper-based or digital via tools like Kahoot/Klaxoon).
Evaluation and Monitoring System
The achievement of training objectives is evaluated at multiple levels to ensure quality:
- Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
- Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
- Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.
Upcoming sessions
January 9, 2026
Distanciel • Français
March 9, 2026
Distanciel • Français
July 3, 2026
Distanciel • Français
November 20, 2026
Distanciel • Français
May 26, 2026
Distanciel • Français
September 29, 2026
Distanciel • Français
March 9, 2026
Distanciel • Français
July 3, 2026
Distanciel • Français
November 20, 2026
Distanciel • Français
Train multiple employees
- Volume discounts (multiple seats)
- Private or custom session
- On-site or remote