GCP200LOOKML

Developing Data Models with LookML

This course empowers you to develop scalable, performant Looker Modeling Language (LookML) 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.

✓ Formation officielle Google CloudNiveau Intermediate⏱️ 1 jour (7h)

Ce que vous allez apprendre

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.

Prérequis

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.

Public cible

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.

Programme de la Formation

4 modules pour maîtriser les fondamentaux

Objectifs

Articulate the benefits of using LookML for data modeling and analysis.
Identify the primary components of the Looker user interface.
Identify the target users and functions of key Looker Ul elements.
Define core Looker platform and LookML terminology.
Understand the basic integration between Looker and Git for version control.
Describe the LookML development lifecycle, including writing, validation, merging, and deployment processes.
Recognize how Looker reads, parses, and writes SQL.
Explain the relationship between SQL and the LookML modeling language.

Sujets abordés

→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

Activités

2 demos

1 quiz

Quality Process

SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach

Teaching Methods Used

Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
Guided Labs — Guided practical exercises on software, hardware, or technical environments.
Quiz / MCQ — Quick knowledge check (paper-based or digital via tools like Kahoot/Klaxoon).

Evaluation and Monitoring System

The achievement of training objectives is evaluated at multiple levels to ensure quality:

Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.