Become data-driven with Google Cloud.

The role of a Data Analyst can vary depending on what type of industry they’re in or which part of their organization they are supporting. Data Analysts gather data, analyze that data and translate the results into insights to share with business stakeholders.

What’s in the Data Analyst/BI Analyst learning path?

Leverage data and gain real-time insights that improve your decision-making and accelerate innovation.

Overview

Learn how to design and build data processing systems.

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.

Limited Time Offer: Get up to 45% OFF selected Google Cloud courses in H2 2025 via our Google Cloud Certified program.

Skills Covered

  • Customize and incrementally refresh SQL and native derived tables
  • Incorporate Liquid for dynamic SQL, formatting, templated f ilters, 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

Prerequisites

Completion of the following courses or the equivalent experience in using LookML for development in Looker:

Target Audience

  • Anyone who are interested.

Course Curriculum

Module 1: Looker Admin and LookML Fundamentals
Topics

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

Objectives

  • 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

Module 2: Diving Deeper into Derived Tables
Topics

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

Objectives

  • 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 Tab

Module 3: Creating Dynamic LookML with Liquid
Topics

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

Objectives

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

Activities

  • Lab: Enhancing LookML Flexibility with Liquid

Module 4: Creating Modular LookML
Topics

  • Extensions
  • Refinements
  • Manifests and Localization

Objectives

  • Use extends and refinements in Looker to modularize and organize your LookML
  • Implement localization into your LookML models

Activities

  • Lab: Modularize your LookML

Module 5: Testing, Debugging and DevOps
Topics

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

Objectives

  • 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

Module 6: Looker Best Practices
Topics

  • Looker Best Practices
  • Improving Performance

Objectives

  • Understand Looker best practices
  • Implement best practices in LookML to improve performance

Activities

  • Lab: Implementing LookML Best Practices

Module 7: Embedded Looker Analytics
Topics

  • Explore Embedded Looker Options
  • Using Private and SSO Embedding

Objectives

  • Explore options for embedding Looker content
  • Understand how to use private and SSO embedding

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

There’s no intakes scheduled for this course at the moment!

For enquiries, please contact our reps.

Exam & Certification

Note: There is no exam directly associated with this course. However, Google Cloud offers an extensive portfolio of industry-recognized certifications that can help you stand out as a tech professional in 2025 and beyond. Obtaining a Google Cloud certified credential is one of the most effective ways to validate your skills and accelerate your career.

With our expert-led training, you’ll be prepared to:

  • Master in-demand capabilities across Cloud, Data & AI, and Cybersecurity — areas driving global digital transformation.
  • Prove your expertise with a globally respected credential recognized by employers worldwide.
  • Advance your career by enhancing your credibility, increasing your earning potential, and opening doors to new opportunities.

Explore our full range of Google Cloud certifications and start building the skills that matter today.

Training & Certification Guide

Why train with Trainocate

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes