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.
Skills Gained
- Define LookML basic terms and building blocks
- Model new dimensions and measures using LookML
- Use dashboards to combine key queries and visualizations into a one page executive view
- Model files of LookML projects to design and build custom Explores for business users
- Use derived tables in Looker to create new custom tables that do not yet exist in the underlying database.
- Articulate how caching works in Looker and how developers can use datagroups to manage caching policies.
Who Can Benefit
- Data developers who are responsible for data curation and management within their organizations. Data analysts interested in learning how data developers use LookML to curate and manage data in their organization’s Looker instance.
Prerequisites
To get the most out of this course, participants should have a basic understanding of SQL, Git, and the Looker business user experience. For learners with no previous experience as data explorers in Looker, it is recommended to first complete Analyzing and Visualizing Data in Looker.
Introducing Looker and LookML
- This module provides an overview of Looker and the Looker integrated development environment (IDE) for LookML developers.
Data Modeling using LookML
- This module reviews how to model new dimensions and measures using LookML. The module also explores the use of dashboards to combine key queries and visualizations into a one page executive view
Modeling Explores for your Users
- This module provides a deeper dive into the model files of LookML projects for developers to start designing and building custom Explores for business users.
Working with Derived Tables
- This module explains how to use derived tables in Looker to create new custom tables that do not yet exist in the underlying database. This module also provides an overview of how caching works in Looker and how developers can use datagroups to manage caching policies.
Course Resources