Looker and LookML for Developers Online Course

Looker and LookML for Developers Online Course

This course offers a comprehensive journey into Looker and LookML, guiding you from the basics of the interface to advanced data modeling and dashboard creation. You’ll start by setting up your environment and learning LookML terminology, then progress to building views, explores, and managing data connections. Hands-on sessions cover dimensions, measures, filters, joins, and custom actions, while advanced modules teach extending explores, testing, and creating interactive dashboards. By the end, you’ll be equipped to leverage Looker fully, transforming raw data into actionable insights and driving data-driven decisions.

Who should take this course?

This course is designed for data analysts, BI developers, and data engineers who want to master Looker and LookML for building interactive dashboards and reports. It’s also ideal for professionals aiming to streamline data exploration and visualization in modern analytics environments.

What you will learn

• Understand Looker's interface and core features
• Set up and configure LookML environments
• Create and manage LookML files, views, and explores
• Develop Advanced Dashboards using various visualization techniques and parameters.
• Apply advanced LookML parameters to optimize data manipulation
• Extend and Optimize LookML Models with additional views and explores, for better performance and scalability.

Course Outline

Introduction

• What is Looker?
• Features of Looker
• Looker vs. Competitors
• Reasons to Learn Looker
• Course Overview
• How to Succeed
• Instructor Overview

Environment

• Sandbox Environment Setup 1
• Sandbox Environment Setup 2
• Looker Terminology 1
• Looker Terminology 2
• Looker Terminology 3
• Looker Terminology 4

Beginner - Connections

• Setting LookML Files
• LookML Environment Walkthrough
• Create a View and Explore
• Connect to Data
• Set Example Data

Beginner - Fields

• Dimensions Introduction
• Dimension Types - Single
• Dimension Types - Bins
• Dimension Types - Case
• Chaining Fields Together
• Measures - Aggregations
• Measures - Non-Aggregations
• Measures - Post-SQL Types
• Dimension Groups
• Filters

Beginner - Field Parameters

• Labels
• Descriptions
• Group Labels
• View Labels
• Value Formats 1
• Value Formats 2
• Location-Based Fields

Beginner - Explore Parameters

• View Name Setting
• Group Label Description

Intermediate - Joins

• Join Data
• Basic Join Parameters
• From Parameter
• Restricting Fields
• Where Parameter

Intermediate - Actions

• Quick Start Analysis
• Drill Fields
• Links 1
• Links 2
• Setting Actions
• Adding Suggestions 1
• Adding Suggestions 2

Expert - Extensions

• Extends with Explores
• Extends with Views
• Sets
• Tests
• Explore Fields and Always_Where Settings

Expert - Dashboards

• Loading Updated Data
• Exploring Element Rental Sample Data
• Dashboard Reference Docs
• Creating Your First Dashboard
• Creating Your First Element
• Newspaper Layout - Element Location and Size 1
• Newspaper Layout - Element Location and Size 2
• Other Element Layout Types
• Model and Explore Parameters
• Type Parameter
• Visualization Parameter
• Refresh and Autorun Parameter
• Crossfilter
• Filters - Adding a Regular Filter
• Filters - Activating the Filter Using Listen
• Filters - Deploying the Filter
• Filters - Different Filter Types
• Filters - UI Multi Selectors
• Filters - UI Single Selectors
• Filters - UI Display Parameters
• Text Elements

Conclusion

• Conclusion and Next Steps