Developing Data Models with LookML (DDMLML) – Outline

Outline detalhado do curso

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