1 day EN / DE Max 16

Developing Data Models with LookML

This course empowers you to develop scalable, performant Looker ModelingLanguage (LookML) models that provide your business users with the standardized,ready-to-use data that they need to answer their questions. Upon completing thiscourse, you will be able to start building and maintaining LookML models to curateand manage data in your organization’s Looker instance. 

€920,00 excl. VAT

Individual scheduling

The courses are held as dedicated group sessions. Once you've booked, we'll coordinate a date that works for your team and send invitations to all participants.

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

What you'll learn

  • 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 to create new custom tables that do not exist in the underlying database.
  • Explain how caching works and how developers can use
    datagroups to manage caching policies.

Course modules
Looker and LookML The Looker user interface Example 1: The Looker IDE LookML project version control Example 2: Git workflow in Looker How Looker writes SQL
Anatomy of a LookML project Modeling dimensions Example 3: Creating dimensions using LookML Modeling measures Example 4: Modeling measures using LookML Dimension and measure modeling logic LookML dashboards Lab 1: Creating dimensions and measures with LookML
Modeling new Explores Using LookML to filter Explores Understanding symmetric aggregation
Introducing derived tables Types of derived tables Example 5: Using SQL derived tables Example 6: Using native derived tables Native derived table parameters Using persistent derived tables Caching and datagroups Implementing datagroups in Looker Lab 2: Creating Derived Tables with LookML
Developing Data Models with LookML