Turn complex data into trusted, business-ready models with LookML and Google Cloud Looker.
Develop the skills to build and maintain LookML models that give business users consistent, meaningful ways to explore organizational data. Learn to define dimensions and measures, design Explores, establish relationships between data, manage LookML projects with Git, create derived tables, and optimize query performance through caching and datagroups.
- Why get trained: Build LookML models, dimensions, measures, Explores, joins, derived tables, and caching strategies
- Why it matters: Well-designed data models give users consistent definitions and reliable data for analysis and decision-making
- Who should attend: Data developers and analysts involved in curating, modeling, or managing data in Looker
Create a reliable semantic layer that turns underlying data into consistent metrics and intuitive Explores your business users can confidently work with. HRD Corp Claimable.
Overview
Bring the power to connect, analyze, and visualize data across multicloud environments.
Looker for Google Cloud Platform allows anyone in your business to quickly analyze and find insights in your datasets. Looker makes it easy to build a data exploration platform that makes your data accessible in a meaningful, intuitive way for your entire organization.
This Google Cloud 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 Covered
- Define LookML basic terms and building blocks
- Use the Looker Integrated Development Environment (IDE) and project version control to modify LookML projects
- Create dimensions and measures to curate data attributes used by business users
- Create and design Explores to make data accessible to business users
- Use derived tables to instantaneously create new tables
- Use caching and datagroups in Looker to optimize SQL query performance
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 course.
Target Audience
- 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.
Module 1: Introduction to Looker and LookML
Objectives
- Define Looker and the functionality it provides for curating data
- Define LookML basic terms and building blocks
- Use the Looker Integrated Development Environment (IDE) to modify LookML projects
Module 2: Creating Dimensions and Measures
Objectives
- Create dimensions and measures to curate data attributes used by business users
Module 3: Project Version Control
Objectives
- Implement version control with Git to manage and track changes in LookML projects
- Send LookML changes from a development branch to production
Module 4: Model Files
Objectives
- Explain how Looker utilizes SQL on the back end to translate user requests to query results
- Create and design Explores to make data accessible to business users
- Use joins to establish relationships between data tables
- Leverage symmetric aggregation to ensure the accuracy of aggregated metrics
- Implement filters to preselect data provided to business users
Module 5: Derived Tables
Objectives
- Define the two types of derived tables in Looker
- Create ephemeral and persistent derived tables
- List best practices for creating derived tables
Module 6: Caching and Datagroups
Objectives
- Explain how Looker uses caching to optimize SQL query performance
- Use datagroups to manage caching policies in Looker
Dates & Locations
February 5, 2027 - February 5, 2027
February 5, 2027 - February 5, 2027
May 14, 2027 - May 14, 2027
May 14, 2027 - May 14, 2027
August 30, 2027 - August 30, 2027
August 30, 2027 - August 30, 2027
November 22, 2027 - November 22, 2027
November 22, 2027 - November 22, 2027
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
