UNITED KINGDOM

Developing Data Models with LookML

Learn how to use LookML to make data accessible to business users on this one-day course.
product
google badge
1 day course
Supporting material
Google Cloud Partner of the Year
Private
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

This course shows you how to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardised, ready-to-use data.

Upon completing the session, you will be able to start building and maintaining LookML models to curate and manage data in your organisation’s Looker instance.

Jellyfish has recently been named a Google Cloud Specialisation Partner of the Year. This title recognises our commitment to provide world-leading Cloud-based Training solutions that help our clients succeed.

Course overview
Who should attend:
Data developers who are responsible for data curation and management within their organisations and Data analysts interested in learning how data developers use LookML to curate and manage data in their organisation’s Looker instance.
Walk away with the ability to:
  • 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 data groups in Looker to speed up SQL queries
Prerequisites

To get the most out of this course, you should have a basic understanding of SQL, Git, and the Looker business user experience.

Course Agenda
Module 1: Introduction to Looker and LookML
  • 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
Module 2: Creating Dimensions and Measures
  • Dimensions, measures
  • Create dimensions and measures to curate data attributes used by business users
Module 3: Project Version Control
  • Git within Looker, project version control
  • Implement version control with Git to manage and track changes in LookML projects
Module 4: Model Files
  • SQL within Looker, Explores, joins, symmetric aggregations, filters
  • Explain how Looker utilises 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
Module 5: Derived Tables
  • 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
Module 6: Caching and Datagroups
  • Caching, datagroups
  • Explain how Looker uses caching to speed up SQL queries
  • Use datagroups to manage caching policies in Looker
Book this course
Call our sales team today
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy