Detailed Course Outline
Module 1 - Introduction to Looker and LookML
Topics - LookML basics, Looker development environment
- 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
- 1 demo, 1 quiz
Module 2 - Creating Dimensions and Measures
Topics - Dimensions, measures
- Create dimensions and measures to curate data attributes used by business users
- 2 demos, 1 lab
Module 3 - Project Version Control
Topics - Git within Looker, project version control
- Implement version control with Git to manage and track changes in LookML projects
Module 4 - Model Files
Topics - SQL within Looker, Explores, joins, symmetric aggregations, filters
- 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
- 1 quiz
Module 5 - Derived Tables
Topics - Derived tables, best practices
- Define the two types of derived tables in Looker
- Create ephemeral and persistent derived tables
- List best practices for creating derived tables
- 2 demos, 1 lab
Module 6 - Caching and Datagroups
Topics - Caching, datagroups
- Explain how Looker uses caching to speed up SQL queries
- Use datagroups to manage caching policies in Looker
- 1 demo