- Course overview
- Course details
- Prerequisites
Course overview
About this course
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.
Audience profile
- 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.
At course completion
You will be able to:
- 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.
Course details
Module 1: 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 2: 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
- LAB: Creating Dimensions and Measures with LookML
- LookML dashboards
Module 3: Modeling Explores for your Users
- Modeling new Explores
- Using LookML to filter Explores
- Understanding symmetric aggregation
Module 4: 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
- LAB: Creating Derived Tables with LookML
- Caching and datagroups
- Implementing datagroups in Looker
Module 5: Multi-Cluster Networking with Anthos Service Mesh
- Module overview
- Fleet networking
- Single network east-west routing
- Multiple network east-west routing
- North-south routing
- LAB: AHYBRID081 Configuring a multi-cluster mesh with Anthos Service
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.
Enquiry
Course : Developing Data Models with LookML
Enquiry
request for : Developing Data Models with LookML
