title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Developing Data Models with LookML
Course Description
Overview
This Developing Data Models with LookML course is an intermediate-level training that introduces the fundamentals of LookML for Looker developers and provides guided demos and hands-on practice with writing LookML code.Objectives
- 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 speed up SQL queries
Audience
Prerequisites
- 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.
Topics
- 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.
- Create dimensions and measures to curate data attributes used by business users.
- Implement version control with Git to manage and track changes in LookML projects.
- 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 end users.
- Define the two types of derived tables in Looker.
- Create ephemeral and persistent derived tables.
- List best practices for creating derived tables.
- Explain how Looker uses caching to speed up SQL queries.
- Use datagroups to manage caching policies in Looker.
Related Courses
-
Analyzing and Visualizing Data with Looker
GCP-1680- Duration: 1
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.