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.
Objectives
In this course, participants will learn the following skills:
- 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.
Audience
Audience
Audience
Audience
This course is intended for the following participants:
- Customers.
Prerequisites
To get the most of out of this course, participants should have:
- Completion of the Developing Data Models with LookML course or the equivalent experience in using LookML for development in Looker.
Duration
2 days
Investment
Check the next open public class in our enrollment page. If you are interested in a private training class for your company, contact-us.
Course Outline
- 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
- Define derived tables and advantages of native derived tables.
- Maintain derived tables in Looker.
- Describe performance implications of different PDT options.
- Core Liquid Concepts and Syntax.
- Custom Links, Drills, and Formatting.
- Templated Filters, Parameters and Dynamic SQL.
- Use extends and refinements in Looker to modularize and organize your LookML.
- Implement localization into your LookML models.
- 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.
- Understand Looker best practices.
- Implement best practices in LookML to improve performance.
- Explore options for embedding Looker content.
- Understand how to use private and SSO embedding.