Developing Data Models with LookML Training

Live Online & Classroom Enterprise Certification Training

The Developing Data Models with LookML course focuses on empowering learners to build efficient and scalable semantic data models using the Looker Modeling Language (LookML). Through this training, participants gain the skills to create dimensions, measures, Explores, derived tables, and performance-optimised caches in a Looker environment.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Developing Data Models with LookML Certification Training about?

This course empowers you to develop scalable, performant Looker Modeling Language (LookML) 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.

What are the objectives of Developing Data Models with LookML Certification Training ?

Define LookML basic terms and building blocks.
Model new dimensions and measures using LookML.
Use dashboards to combine key queries and visualizations into a one-page executive view.
Model files of LookML projects to design and build custom Explores for business users.
Use derived tables to create new custom tables that do not exist in the underlying database.
Explain how caching works and how developers can use datagroups to manage caching policies.

Who is Developing Data Models with LookML Certification Training for?

This course is primarily intended for the following participants:

Data developers who are responsible for data curation and management within their organizations.
Data analysts interested in learning how data developers use LookML to curate and manage data in their organization’s Looker instance.

What are the prerequisites for Developing Data Models with LookML Certification Training?

To get the most out of this course, participants should have a basic understanding of SQL, Git, and the Looker business user experience. For learners with no previous experience as data explorers in Looker, it is recommended to first complete Analyzing and Visualizing Data in Looker.

Available Training Modes

Live Online Training

1 Days

Course Outline Expand All

Expand All

Module 1: Introducing Looker and LookML

Looker and LookML

The Looker user interface

Example 1: The Looker IDE

LookML project version control

Example 2: Git workflow in Looker

How Looker writes SQL

Module 2: Data Modeling Using LookML

Anatomy of a LookML project

Modeling dimensions

Example 3: Creating dimensions using LookML

Modeling measures

Example 4: Modeling measures using LookML

Dimension and measure modeling logic

LookML dashboards

Lab 1: Creating dimensions and measures with LookML

Module 3: Modeling Explores for Your Users

Modeling new Explores

Using LookML to filter Explores

Understanding symmetric aggregation

Module 4: Working with Derived Tables

Introducing derived tables

Types of derived tables

Example 5: Using SQL derived tables

Example 6: Using native derived tables

Native derived table parameters

Using persistent derived tables

Caching and datagroups

Implementing datagroups in Looker

Lab 2: Creating Derived Tables with LookML

DOWNLOAD COURSE BROCHURE

Who is the instructor for this training?

The trainer for this Developing Data Models with LookML Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Developing Data Models with LookML Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Google Cloud Platform.
The training fees is exclusive of exam cost.
For any queries, feel free to reach us at GCP@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree