Developing Data Models with LookML (DDMLML) – Outline

Detailed Course Outline

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