Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Developing Data Models with LookML

Google via Google Cloud Skills Boost

Overview

This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data that they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.

Syllabus

  • Introducing Looker and LookML
    • Looker and LookML
    • The Looker user interface
    • The Looker IDE
    • LookML project version control
    • Example: Git workflow in Looker
    • How Looker writes SQL
    • Module 1 Quiz
  • Data Modeling using LookML
    • Anatomy of a LookML project
    • Modeling dimensions
    • Example: Creating dimensions using LookML
    • Modeling measures
    • Example: Modeling measures using LookML
    • Dimension + measure modeling logic
    • Creating Dimensions and Measures with LookML
    • LookML dashboards
    • Module 2 Quiz
  • Modeling Explores for your Users
    • Modeling new Explores
    • Using LookML to filter Explores
    • Understanding symmetric aggregation
    • Module 3 Quiz
  • Working with Derived Tables
    • Introducing derived tables
    • Types of derived tables
    • Using SQL derived tables
    • Using native derived tables
    • Native derived table parameters
    • Using persistent derived tables
    • Creating Derived Tables with LookML
    • Caching and datagroups
    • Implementing datagroups in Looker
    • Module 4 Quiz
  • Course Resources
    • Course Resources
  • Your Next Steps
    • Course Badge

Reviews

Start your review of Developing Data Models with LookML

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.