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
- Discuss how to modify LookML projects using the Looker Integrated Development Environment (IDE)
- 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 quiz, 1 lab
Module 3 - Project Version Control
Topics - Git within Looker, project version control
- Discuss how to implement version control with Git to manage and track changes in LookML projects
- Explain how to send LookML changes from a development branch to production
- 1 quiz
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
- Describe how to create and design Explores to make data accessible to business users
- Identify join parameters that can be used to establish relationships between datatables
- Discuss the use of symmetric aggregation to ensure the accuracy of aggregated metrics
- Describe how to implement filters to preselect data provided to business 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 quiz, 1 lab
Module 6 - Caching and Datagroups
Topics - Caching, datagroups
- Explain how Looker uses caching to optimize SQL query performance
- Describe how datagroups manage caching policies in Looker
- 1 demo, 1 quiz