Course
digicode: ALML
Looker Developer Deep Dive
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.
Duration
2 days
Price
1'700.–
exkl. 8.1% MWST
Course facts
- Customizing and incrementally refreshing SQL and native derived tables
- Incorporating Liquid for dynamic SQL, formatting, templated filters, and parameters in Looker
- Using extends and refinements in Looker to modularize and organize your LookML
- Troubleshooting LookML code and improve performance
- Applying Looker best practices to your LookML projects
- Managing Looker deployments using DevOps practices
- Embedding Looker content into web applications
In this course you will practice the skills to be an advanced Looker Developer through guided lectures and independent exercises using sample data.
1 Looker Admin and LookML Fundamentals
- Looker Review
- Roles and User Attributes
- Connecting to a Database
- LookML Review
- 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
- Lab: Starter LookML Cleanup
2 Diving Deeper into Derived Tables
- Understanding Derived Tables
- Adding Persistence
- Refreshing Incrementally
- PDTs and Performance
- Define derived tables and advantages of native derived tables
- Maintain derived tables in Looker
- Describe performance implications of different PDT options
- Lab: Extending LookML with PDTs and Aggregate Tabl
3 Creating Dynamic LookML with Liquid
- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
- Lab: Enhancing LookML Flexibility with Liquid
4 Creating Modular LookML
- Extensions
- Refinements
- Manifests and Localization
- Use extends and refinements in Looker to modularize and organize your LookML
- Implement localization into your LookML models
- Lab: Modularize your LookML
5 Testing, Debugging and DevOps
- Leverage your IDE
- Debugging and Common Errors
- Data Tests
- Looker and DevOps
- 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
- Lab: Testing and debugging LookML
6 Looker Best Practices
- Improving Performance
- Understand Looker best practices
- Implement best practices in LookML to improve performance
- Lab: Implementing LookML Best Practices
7 Embedded Looker Analytics
- Explore Embedded Looker Options
- Using Private and SSO Embedding
- Explore options for embedding Looker content
- Understand how to use private and SSO embedding
We recommend taking the following course or equivalent knowledge: