Course Overview
TOPThis 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 organizations Looker instance.
Scheduled Classes
TOPWhat You'll Learn
TOPDefine 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.
Outline
TOP
Viewing outline for:
This module provides an overview of Looker and the Looker integrated development environment (IDE) for LookML developers.
- 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
- 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.
- 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.
- PDF links to all modules
Prerequisites
TOPTo 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.
Who Should Attend
TOPData 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 organizations Looker instance.