T-ALML-AOfficial Google Curriculum
Looker Developer Deep Dive
2 daysILTAdvancedLoading...
Overview
LookML not only serves as the foundation for visualization assets in Looker, but is also capable of dynamic aggregations, incrementally refreshed persistent derived tables, and more. In this course you will practice the skills to be an advanced Looker Developer through guided lectures and independent exercises using sample data.
What You'll Learn
- Customize and incrementally refresh SQL and native derived tables
- Incorporate Liquid for dynamic SQL, formatting, templated filters, and parameters in Looker
- Use extends and refinements in Looker to modularize and organize your LookML
- Troubleshoot LookML code and improve performance
- Apply Looker best practices to your LookML projects
- Manage Looker deployments using DevOps practices
- Embed Looker content into web applications
Who Should Attend
Customers
Prerequisites
Completion of the "Developing Data Models with LookML" course or the equivalent experience in using LookML for development in Looker.
Products Covered
Looker
Course Modules
1
Looker Admin and LookML Fundamentals
Topics
- Looker Review
- Roles and User Attributes
- Connecting to a Database
- LookML Review
Learning Outcomes
- Review key concepts of Looker and LookML development
- Describe roles and user attributes in Looker
- Explain how to connect your Looker instance to a database
Activities
Lab: Starter LookML Cleanup
2
Diving Deeper into Derived Tables
Topics
- Understanding Derived Tables
- Adding Persistence
- Refreshing Incrementally
- PDTs and Performance
Learning Outcomes
- Define derived tables and advantages of native derived tables
- Maintain derived tables in Looker
- Describe performance implications of different PDT options
Activities
Lab: Extending LookML with PDTs and Aggregate Tabl
3
Creating Dynamic LookML with Liquid
Topics
- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
Learning Outcomes
- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
Activities
Lab: Enhancing LookML Flexibility with Liquid
4
Creating Modular LookML
Topics
- Extensions
- Refinements
- Manifests and Localization
Learning Outcomes
- Use extends and refinements in Looker to modularize and organize your LookML
- Implement localization into your LookML models
Activities
Lab: Modularize your LookML
5
Testing, Debugging and DevOps
Topics
- Leverage your IDE
- Debugging and Common Errors
- Data Tests
- Looker and DevOps
Learning Outcomes
- Utilize the Looker IDE to ease development and debugging of LookML
- Write data tests to ensure validity of your Looker dashboards
- Understand DevOps best practices in Looker
Activities
Lab: Testing and debugging LookML
6
Looker Best Practices
Topics
- Looker Best Practices
- Improving Performance
Learning Outcomes
- Understand Looker best practices
- Implement best practices in LookML to improve performance
Activities
Lab: Implementing LookML Best Practices
7
Embedded Looker Analytics
Topics
- Explore Embedded Looker Options
- Using Private and SSO Embedding
Learning Outcomes
- Explore options for embedding Looker content
- Understand how to use private and SSO embedding
Upcoming Classes
13 Feb 2026 - 27 Feb 2026
05:00:00 - 07:00:00 Australia/Sydney
Virtual
12 seats left
Seats:
Course Details
- Course Code
- T-ALML-A
- Duration
- 2 days
- Format
- ILT
- Level
- Advanced
- Modules
- 7
- Activities
- 6
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact UsStarting fromLoading...