This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data that they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.
Overview
Syllabus
- Introducing Looker and LookML
- Looker and LookML
- The Looker user interface
- The Looker IDE
- LookML project version control
- Example: Git workflow in Looker
- How Looker writes SQL
- Module 1 Quiz
- Data Modeling using LookML
- Anatomy of a LookML project
- Modeling dimensions
- Example: Creating dimensions using LookML
- Modeling measures
- Example: Modeling measures using LookML
- Dimension + measure modeling logic
- Creating Dimensions and Measures with LookML
- LookML dashboards
- Module 2 Quiz
- Modeling Explores for your Users
- Modeling new Explores
- Using LookML to filter Explores
- Understanding symmetric aggregation
- Module 3 Quiz
- Working with Derived Tables
- Introducing derived tables
- Types of derived tables
- Using SQL derived tables
- Using native derived tables
- Native derived table parameters
- Using persistent derived tables
- Creating Derived Tables with LookML
- Caching and datagroups
- Implementing datagroups in Looker
- Module 4 Quiz
- Course Resources
- Course Resources
- Your Next Steps
- Course Badge