Looker and LookML - The Complete Masterclass

Name: Looker and LookML - The Complete Masterclass
Rating: 4.5 (23 reviews)

Master Looker and LookML - From Analyst to Developer

Highest Rated

Created byBiswajit | Expanding Horizons

Last updated 2/2026

English

English [Auto],

What you'll learn

Master Looker from both analyst & developer perspectives - build skills for any data role in modern organizations.
Create interactive dashboards and visualizations that tell compelling data stories and drive business decisions.
Build robust data models using LookML to create single sources of truth for entire organizations.
Design and develop complete Looker projects from scratch, including explores, views, and derived tables.
Master dashboard design principles, filters, cross-filtering, and user experience best practices.

Course content

7 sections • 21 lectures • 2h 33m total length

What is Looker5:35
Looker is a web-based business intelligence platform that connects to data sources, explores data, creates dashboards, and enables secure collaboration via LookML semantic layers.
The Magic of Semantic Layer & LookML4:55
Explore how LookML builds the semantic layer and a single source of truth in Looker, enabling governance, data lineage, and model-driven SQL across any SQL dialect.

A tour of Looker Interface10:56
Navigate the Looker interface in a temporary one-hour sandbox, exploring the explore, develop, and admin components. Learn LookML concepts, data organization with folders, boards, and blocks, plus practical navigation tips.
Core Concepts: Explores, Looks, and Dashboards4:52
Explore Looker’s core concepts, using explores as report builders to ask questions of your data. Save insights as looks and assemble them into dashboards to tell a data driven story.
Data Analysis Flow7:04
Build a semantic LookML layer on top of raw data in Looker, enable fast, governance-driven analysis through explores and looks, and deliver interactive dashboards that tell a complete business story.

Getting Started with Looker Explores8:31
Learn to use Looker explores to pick dimensions and measures, run revenue-focused queries on order items, and pivot data to compare categories and genders.
Filters7:20
Explore how filters in Looker and LookML segment data using pre- and post-aggregation techniques. Learn when to apply field and measure filters and which operators to answer precise business questions.

Tables & Single Record14:38
Explore Looker visualization fundamentals by comparing tables and single records to analyze profits by category. Create a calculated measure from revenue and cost, and apply conditional formatting to reveal insights.
Bar & Column Chart8:26
Looker and LookML masterclass: discover how column and bar charts enable quick revenue comparisons across distribution centers and genders, with stacked and percentage views for clarity.
Line & Area Chart7:15
Explore line and area charts to reveal trends over time, seasonal patterns, and cumulative volume, using time scales, data points, and trend lines to forecast growth.
Pie & Donut Multiple6:29
Use pie and donut charts to show composition and part-to-whole relationships, emphasizing 2–7 categories. Learn when to pivot and unpivot data for multiple donuts, and when to switch to bars.

Introduction to Dashboards15:09
Create dashboards by arranging visualization and text tiles on a 24-column grid, save looks to dashboards from explore order items, and tell the data story with markdown text.
Filters in Dashboards9:30
Explore how to build interactive dashboard filters in Looker, configure filter controls, limit values, enable cross filtering, and drive dynamic data across charts and maps.

Relevance of Looker Developer3:54
Build robust data models with LookML, defining business metrics and relationships. Explore the Looker IDE, set up projects, enforce governance, embed analytics, and optimize performance.
Anatomy of LookML Project4:23
Master the anatomy of a LookML project by mapping models, views, and dashboards. Learn how explores, joints, dimensions, measures, and field sets connect to governance at scale and data experiences.
Connecting Looker to Database5:36
Enable development mode and create a Looker project to connect to a database. Define views and explores that map to SQL tables through the BigQuery public data connection.
Exploring the Developer Interface6:50
Navigate the development workspace, use the file and object browsers to organize models and views, create views from tables or blank, and explore joins, git actions, dashboards, and project settings.

Defining View7:38
Create your first LookML view from scratch with a derived table, define a sample customer data table in SQL, and enable explore in Looker.
Defining Explore3:47
Define an explore to expose the customer view, ensuring the explore name matches the view. Use labels for a name to help analysts drag fields, apply filters, and build visualizations.
Defining Dimentions & Measures8:00
Define dimensions and a measure in a lookml view by configuring customer id as a numeric primary key and adding a first name string dimension and total customer count measure.
Note3:07
Note for the Looker and LookML masterclass. A complete masterclass for learners of Looker and LookML.

Requirements

Basic computer literacy and familiarity with navigating web applications - no advanced technical background required.
Fundamental understanding of data concepts like tables, columns, and basic metrics - spreadsheet experience helpful.
For developer modules: Basic SQL knowledge (SELECT, JOIN, WHERE clauses)
A Google account to access Looker sandbox environment - we guide you through setup step-by-step.
Curiosity about data analysis and willingness to learn - no prior BI tool experience necessary.
Web browser and stable internet connection - all work happens in cloud-based Looker environment.

Description

Welcome to "Looker and LookML - The Complete Masterclass" - your definitive guide to mastering one of the most powerful business intelligence platforms in today's data landscape. This comprehensive course is meticulously designed to take you from absolute beginner to Looker expert, covering every aspect of the platform through structured, hands-on learning. Whether you're looking to enhance your data analysis capabilities, build robust data models, or advance your career in business intelligence, this masterclass provides the complete skill set needed to excel with Looker in any professional environment.

In the Analyst section, you'll master the art of data exploration and visualization using Looker's intuitive interface. You'll learn to navigate explores, create meaningful visualizations including tables, charts, graphs, and maps, and build interactive dashboards that communicate insights effectively. We'll cover essential analytical techniques, filtering strategies, and dashboard design principles that transform raw data into actionable business intelligence. This section empowers you to answer critical business questions, create compelling data stories, and share insights across your organization with professional-grade reports and interactive data experiences.

The Developer section takes you deep into Looker's technical foundation, where you'll master LookML - the powerful modeling language that sets Looker apart. You'll learn to build and manage complete Looker projects, create sophisticated data models with views, explores, and joins, and implement complex business logic through dimensions and measures. This comprehensive developer training equips you with the skills to architect scalable data solutions, maintain enterprise-grade Looker instances, and create the robust data foundations that drive organizational decision-making.

Who this course is for:

Data Analysts & BI Professionals looking to master modern cloud-based analytics platforms and advance their careers.
Business Users & Domain Experts in marketing, sales, finance who want to transform data into actionable insights.
Data Engineers & SQL Developers seeking to expand their skills into business intelligence and data modeling.
Consultants & Freelancers who want to add Looker expertise to their service offerings and deliver client value.
Career Changers & Students looking to enter the high-demand field of data analytics with practical, job-ready skills.
Managers & Team Leads who need to understand Looker capabilities to lead data-driven teams and projects effectively.
Product Managers & Strategists who use data to drive product decisions and need to communicate requirements effectively.
Current Looker Users who want to move beyond basic usage to master advanced features and development capabilities.
Anyone in Data-Related Roles looking to stay current with one of the fastest-growing BI platforms in the industry.

Looker and LookML - The Complete Masterclass

What you'll learn

Explore related topics

Course content

Getting started with Looker2 lectures • 11min

Navigating the Interface3 lectures • 23min

Explores2 lectures • 16min

Types of Visualizations4 lectures • 37min

Dashboards2 lectures • 25min

Exploring the Developer Interface4 lectures • 21min

Creating our Data Model4 lectures • 23min

Requirements

Description

Who this course is for: