Module 1: Introduction to Looker and LookML
Topics: LookML basics, Looker development environment
Objectives:
- Define Looker and the functionality it provides for curating data
- Define LookML basic terms and building blocks
- Use the Looker Integrated Development Environment (IDE) to modify LookML projects
Activities: 1 demo, 1 quiz
Module 2: Creating Dimensions and Measures
Topics: Dimensions, measures
Objectives: Create dimensions and measures to curate data attributes used by business users
Activities: 2 demos, 1 lab
Module 3: Project Version Control
Topics: Git within Looker, project version control
Objectives: Implement version control with Git to manage and track changes in LookML projects
Activities: -
Module 4: Model Files
Topics: SQL within Looker, Explores, joins, symmetric aggregations, filters
Objectives:
- Explain how Looker utilizes SQL on the back end to translate user requests to query results
- Create and design Explores to make data accessible to business users
- Use joins to establish relationships between data tables
- Leverage symmetric aggregation to ensure the accuracy of aggregated metrics
- Implement filters to preselect data provided to end users
Activities: 1 quiz
Module 5: Derived Tables
Topics: Derived tables, best practices
Objectives:
- Define the two types of derived tables in Looker
- Create ephemeral and persistent derived tables
- List best practices for creating derived tables
Activities: 2 demos, 1 lab
Module 6: Caching and Datagroups
Topics: Caching, datagroups
Objectives:
- Explain how Looker uses caching to speed up SQL queries
- Use datagroups to manage caching policies in Looker
Activities: 1 demo