GB
/
GBP
/
EN_GB

Shaping the future of IT skills

Maximising IT performance through learning

Developing Data Models with LookML

WGAC-GGL-DDMLML

Google

Description

Show Tabs
Introduction

Module 1 - Introduction to Looker and LookML

Topics - LookML basics, Looker development environment

  • 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
  • 1 demo, 1 quiz

Module 2 - Creating Dimensions and Measures

Topics - Dimensions, measures

  • Create dimensions and measures to curate data attributes used by business users
  • 2 demos, 1 lab

Module 3 - Project Version Control

Topics - Git within Looker, project version control

  • Implement version control with Git to manage and track changes in LookML projects

Module 4 - Model Files

Topics - SQL within Looker, Explores, joins, symmetric aggregations, filters

  • 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
  • 1 quiz

Module 5 - Derived Tables

Topics - Derived tables, best practices

  • Define the two types of derived tables in Looker
  • Create ephemeral and persistent derived tables
  • List best practices for creating derived tables
  • 2 demos, 1 lab

Module 6 - Caching and Datagroups

Topics - Caching, datagroups

  • Explain how Looker uses caching to speed up SQL queries
  • Use datagroups to manage caching policies in Looker
  • 1 demo
Prerequisites & Audience

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 Benefits
  • 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

Not covered in this course:

  • Analyzing data in Explores
  • Creating and sharing visualizations and dashboards
  • Looker administrative features and functions

Google courses


Cloud Digital Leader
CODE: WGAC-GGL-CDL
Data Integration with Cloud Data Fusion
CODE: WGAC-GGL-DICDF
Preparing for Your Professional Cloud Network Engineer Journey
CODE: WGAC-GGL-PYPCNEJ
Deploying and Managing Windows Workloads on Google Cloud
CODE: WGAC-GGL-DMWWGC
Installing and Managing Google Cloud's Apigee API Platform for Private Cloud
CODE: WGAC-GGL-IMAPIPC
Customer Experiences with Contact Center AI - Dialogflow CX
CODE: WGAC-GGL-CCAIDCX
Customer Experiences with Contact Center AI - Dialogflow ES
CODE: WGAC-GGL-CCAIDES
Application Development with Cloud Run
CODE: WGAC-GGL-ADCR
Serverless Data Processing with Dataflow
CODE: WGAC-GGL-SDPF
Developing Data Models with LookML
CODE: WGAC-GGL-DDMLML
Analyzing and Visualizing Data with Looker
CODE: WGAC-GGL-AVDL
Machine Learning on Google Cloud
CODE: WGAC-GGL-MLGC
Developing APIs with Google Cloud's Apigee API platform
CODE: WGAC-GGL-T-APIENG-B
Managing Google Cloud's Apigee API Platform for Hybrid Cloud
CODE: WGAC-GGL-T-APIHYB-B
Logging, Monitoring, and Observability in Google Cloud
CODE: WGAC-GGL-LMOGC
Security in Google Cloud Platform
CODE: WGAC-GGL-SGCP-3D
Google Cloud Fundamentals for Azure Professionals
CODE: WGAC-GGL-GCPAZURE
Preparing for the Associate Cloud Engineer Examination
CODE: WGAC-GGL-PPACE
Architecting Hybrid Cloud Infrastructure with Anthos
CODE: WGAC-GGL-T-AHYBRID-I
Architecting with Google Kubernetes Engine
CODE: WGAC-GGL-AGKE
Architecting with Google Compute Engine
CODE: WGAC-GGL-AGCE
Preparing for the Professional Data Engineer Examination
CODE: WGAC-GGL-PPDEE
Networking in Google Cloud Platform
CODE: WGAC-GGL-NGCP
Preparing for the Professional Cloud Architect Examination
CODE: WGAC-GGL-PPCAE
Getting Started with Google Kubernetes Engine
CODE: WGAC-GGL-GCP-GSGKE
Google Cloud Platform Fundamentals for AWS Professionals
CODE: WGAC-GGL-GCP-FAP
Developing Applications with Google Cloud Platform
CODE: WGAC-GGL-DAGCP
From Data to Insights with Google Cloud Platform
CODE: WGAC-GGL-DIGCP
Data Engineering on Google Cloud Platform
CODE: WGAC-GGL-DEGCP
Google Cloud Fundamentals: Big Data and Machine Learning
CODE: WGAC-GGL-GCF-BDM
Architecting with Google Cloud Platform: Design and Process
CODE: WGAC-GGL-AGCP-DP
Google Cloud Fundamentals: Core Infrastructure
CODE: WGAC-GGL-GCF-CI
We use cookies to understand how you use our site and to improve your experience. To learn more, click here. Read our revised Privacy Policy and Terms and Conditions.