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
  • Discuss how to modify LookML projects using the Looker Integrated Development Environment (IDE)
  • 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 quiz, 1 lab

Module 3 - Project Version Control

Topics - Git within Looker, project version control

  • Discuss how to implement version control with Git to manage and track changes in LookML projects
  • Explain how to send LookML changes from a development branch to production
  • 1 quiz

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
  • Describe how to create and design Explores to make data accessible to business users
  • Identify join parameters that can be used to establish relationships between datatables
  • Discuss the use of symmetric aggregation to ensure the accuracy of aggregated metrics
  • Describe how to implement filters to preselect data provided to business 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 quiz, 1 lab

Module 6 - Caching and Datagroups

Topics - Caching, datagroups

  • Explain how Looker uses caching to optimize SQL query performance
  • Describe how datagroups manage caching policies in Looker
  • 1 demo, 1 quiz