Machine Learning- Developing Data Models with LookML -4

Machine Learning

Developing Data Models with LookML

Transform how your business accesses and interacts with data! This one-day course provides the tools to build, curate, and manage LookML models for a more data-driven decision-making process

Duration

1 Days

Target Audience

Who should attend?
Data developers looking to enhance their data curation and management skills using LookML.
Data analysts interested in learning how LookML is used to manage and organize data in Looker

Prerequisites for Success

• A basic understanding of SQL to work with LookML models and queries.
• Familiarity with Git for version control in LookML projects.
• Experience with the Looker business user experience to understand how business users interact with data.

If you have no prior experience as a data explorer in Looker, it is recommended to first complete the Analysing and Visualising Data in Looker course

COURSE AGENDA

Model Files

Understand how SQL works within Looker to generate user queries.
Create and design Explores to make data more accessible to business users.
Use joins to define relationships between data tables.
Leverage symmetric aggregation to ensure the accuracy of aggregated metrics.
Implement filters to preselect data for end-user access.

Derived Tables

Understand derived tables and their role in Looker.
Learn the two types of derived tables in Looker: ephemeral and persistent.
Follow best practices for creating derived tables to optimize model performance.

Caching & Datagroups

Learn how Looker uses caching to speed up SQL queries.
Use datagroups to manage caching policies and optimize query performance.