Developing Data Models with LookML (DDMLML)
Virtual Learning: 550€ + IVA
REF: DDMLML Catálogo: Google Cloud Área: Smart Analytics and Data Management
Duração:
1 dia
Próxima Data:
18 Aug 2025
Local:
Online
Descrição
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.
*PVP por participante. A realização do curso nas datas apresentadas está sujeita a um quórum mínimo de inscrições.
Destinatários
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.
-
Área: Google Cloud
Programa:
Module 1: Introducing Looker and LookML
This module provides an overview of Looker and the Looker integrated development environment (IDE) for LookML developers.
Lessons:
- 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
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
Lessons:
- 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
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.
Lessons:
- Modeling new Explores
- Using LookML to filter Explores
- Understanding symmetric aggregation
Module 4: Working with Derived Tables
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.
Lessons:
- 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
Pré-requisitos:
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.
Partilha:
Precisas de ajuda a encontrar o teu futuro?
