Detailed Course Outline
Module 1 - The Looker Platform
Topics:
- What is Looker?
- Looker user interface
- Organizing content with folders
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.
Activities:
- 1 quiz
Module 2 - Data Analysis Building Blocks
Topics:
- Dimensions in Looker
- Measures in Looker
- Using dimensions and measures
- Filtering dimensions
- Filtering measures
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.
Activities:
- 3 demos, 1 lab, 1 quiz
Module 3 - Working with Looker Content
Topics:
- Filtering Looks
- Introducing dashboards
- Filtering dashboards
- Curating Looker content in boards
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.
Activities:
- 1 demo, 1 quiz
Module 4 - Customizing Explores
Topics:
- Pivoting data in Looker
- Introduction to table calculations
- Types of table calculations
- Writing table calculations
- Introducing offset functions
- Writing offset calculations
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.
Activities:
- 4 demos, 1 lab, 1 quiz
Module 5 - Creating New Looker Content
Topics:
- Creating new Looks
- Creating new dashboards
Objectives:
- Explain how to create a new Look and dashboard in Looker.
- Identify where users can create new Looks and dashboards.
Activities:
- 1 quiz
Module 6 - Sharing Looker Data with Others
Topics:
- Sharing and scheduling Looks
- Sharing and scheduling dashboards
- Tile-level dashboard alerts
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.
Activities:
- 1 quiz