Looker Developer Deep Dive (LDDD)

 

Course 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 lecture and independent exercises using sample data.

Who should attend

Looker Developers who want to learn how to get the most out of LookML, leveraging features like Liquid, aggregate tables, modular LookML files, Looker DevOps, and embedding their Looker content.

Prerequisites

Completion of the “Developing Data Models with LookML” course or the equivalent experience in using LookML for development in Looker.

Course Objectives

  • 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

Outline: Looker Developer Deep Dive (LDDD)

Module 1 - Looker Admin and LookML Fundamentals

  • Looker Review
  • Roles and User Attributes
  • Connecting to a Database
  • LookML Review

Module 2 - Diving Deeper into Derived Tables

  • Understanding Derived Tables
  • Adding Persistence
  • Refreshing Incrementally
  • PDTs and Performance

Module 3 - Creating Dynamic LookML with Liquid

  • Core Liquid Concepts and Syntax
  • Custom Links, Drills, and Formatting
  • Templated Filters, Parameters and Dynamic SQL

Module 4 - Creating Modular LookML

  • Extensions
  • Refinements
  • Manifests and Localization

Module 5 - Testing, Debugging and DevOps

  • Leverage your IDE
  • Debugging and Common Errors
  • Data Tests
  • Looker and DevOps

Module 6 - Looker Best Practices

  • Looker Best Practices
  • Improving Performance

Module 7 - Embedded Looker Analytics

  • Explore Embedded Looker Options
  • Using Private and SSO Embedding

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • Online Training: CAD 1,975
  • Online Training: US $ 1,495

Schedule

Currently there are no training dates scheduled for this course.