Looker and LookML – The Complete Course for Beginners

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Get a free Looker learning account

Lecture 1: Setting up a Sandbox environment – Part 1

Lecture 2: Setting up a Sandbox environment – Part 2

Lecture 3: Sandbox tip – limit of labs usage

Lecture 4: The Interface

Chapter 3: Explores – Getting Started

Lecture 1: What is an Explore in Looker?

Lecture 2: Filtering Explores

Lecture 3: Sorting our data

Lecture 4: Row Limit and Totals in Explores

Lecture 5: In Use & Clear fields options

Lecture 6: Pivoting in Explores

Lecture 7: Cache data in Looker

Lecture 8: SQL section in Explores

Lecture 9: Advanced Topic – What stand behind the Explores?

Chapter 4: Explores Part 2 – Vizualizations

Lecture 1: Into to the Visualization section

Lecture 2: Table Visulizations

Lecture 3: Column chart

Lecture 4: Bar charts

Lecture 5: Scatterplot Visualizations

Lecture 6: Line Chart

Lecture 7: Area Chart

Lecture 8: Pie Chart

Lecture 9: Map Chart

Lecture 10: Single Value

Lecture 11: Donut Multiples

Lecture 12: Single Record

Lecture 13: Table Legacy visulization

Lecture 14: Word Cloud

Chapter 5: Explores Part 3 – Custom Fields

Lecture 1: What are Custom Fields?

Lecture 2: Create a custom dimension – group items

Lecture 3: Custom Binning

Lecture 4: Create a custom measure from a dimension

Lecture 5: Create a custom measure 2

Lecture 6: Apply filters to our custom fields

Lecture 7: Creating a custom dimension using a Looker expression

Lecture 8: Looker Expressions – Part 2

Chapter 6: Explores Part 4 – Filters deep dive

Lecture 1: Filters – The Basics

Lecture 2: Filters – The Basics Part 2

Lecture 3: Matches Advanced filtering expressions

Lecture 4: Custom Filter options

Chapter 7: Looks

Lecture 1: Creating our first Look

Lecture 2: Editing our saved Look

Lecture 3: Looks options – Sending, Sharing, Scheduling, adding to Boards and more

Chapter 8: Dashboards – Beginner to Expert

Lecture 1: Creating our first Dashboard – Part 1

Lecture 2: Creating our first Dashboard – Part 2

Lecture 3: Dashboard filtering

Lecture 4: Cross-filtering

Lecture 5: Dashboard settings

Lecture 6: Dashboard options

Chapter 9: Other useful tips and tricks for Users and Looker Analysts

Lecture 1: Looker Shortcuts

Lecture 2: The History option

Lecture 3: Looker Marketplace

Lecture 4: Boards

Lecture 5: Boards – Part 2

Chapter 10: LookML Basics

Lecture 1: Explore the LookML environment

Lecture 2: Elements of LookML

Lecture 3: Fields

Lecture 4: Views

Lecture 5: Explore

Lecture 6: Models

Lecture 7: Project

Lecture 8: Dimension and Measure Fields

Lecture 9: Dimension Types

Chapter 11: LookML Practice – Beginner

Lecture 1: Create Folders and tidy up your space

Lecture 2: Create a view

Lecture 3: Create dimensions on our view

Lecture 4: Create a measure in our view

Lecture 5: Commit Changes and Deploy to Production

Lecture 6: Join a View to an existing Model and Explore

Lecture 7: Create a new custom dimension based on calculation

Lecture 8: Create a new custom measure

Lecture 9: Decimals in our custom measure

Chapter 12: LookML Practice – Intermediate

Lecture 1: Add filters to your Explores using LookML – Always_Filter

Lecture 2: Add filters in LookML – Part 2 (sql_always_where)

Lecture 3: Add filters in LookML – Part 3 (sql_always_having)

Lecture 4: Add filters in LookML – Part 4 (conditionality_filter)

Lecture 5: Using commenting in LookML

Lecture 6: Create our first Model in LookML

Lecture 7: Create a join

Lecture 8: Limiting fields in a join

Lecture 9: Changing field names

Lecture 10: Dashboards – User-Defined vs LookML Dashboards

Chapter 13: LookML Practice – Advanced

Lecture 1: Datagroups in LookML

Lecture 2: Apply the datagroup

Lecture 3: LookML reference

Lecture 4: The Looker Community

Chapter 14: LookML – Integrating Looker with Git