Course Highlights
  • Learn why businesses should use Looker to explore their data
  • How to setup Looker for learning
  • How to explore enterprise data using Looker as a business user
  • How to visualize data using popular chart types in Looker
  • Filter and sort data to find the right answer for your business questions
  • How to create a dashboard using looks in Looker
  • Learn about Folders and boards to make content easily accessible
  • How to share and schedule charts and dashboards with team mates
  • Learn LookML - the language that powers Looker (For Looker developers)
Curriculum

7 Topics
Introduction
Why use Looker?
Milestone!
Course Resources
Looker features
Setting up the Sandbox
Home Interface

2 Topics
Important terms used in Looker
Dimensions and Measures

2 Topics
Creating your first Look
Saving a Look

2 Topics
Filtering using Dimensions
Filtering using Measures

6 Topics
Single-Value Visualization
Bar and Column Chart
Line Chart
Pie Chart
Scatterplot
GeoMaps

5 Topics
Table Calculations
Creating a custom dimension using a Looker expression
Binning - Custom Dimension
Groups - Custom Dimension
Custom Measures

2 Topics
Look view-mode
Other options in View mode

3 Topics
Creating a Dashboard in Looker
Adding filters to a dashboard
Setting the tiles and other options

1 Topic
Creating folders and Managing Access

2 Topics
Downloading Looks and dashboards
Sharing and Sending mails

1 Topic
Boards

7 Topics
Why to use LookML
LookML Slides
Advantages of LookML
LookML important terms
Interface of LookML
How to create Views in LookML
SQL runner in Looker

7 Topics
Dimensions - Syntax ed
Dimensions - Number
Dimensions - String
Dimensions - YesNo
Dimensions - Tier
Dimensions - Location - Tier
Dimensions - Date Time and Others

5 Topics
Dimensions in looker - Data sample and import
Dimensions in looker - For Airport view
Dimensions in looker - Creating single view explore
Dimensions in looker - Creating Airport dashboard
Dimensions in looker - Explore and look for Flight view

11 Topics
Measures - Syntax
Measures - Average
Measures - Average Distinct
Quiz
Measures - Count and Count Distinct
Measures - Other common measures
Measures - Running total
Measures - Percent of previous
Measures - Percent of total
Measures - List
Measures - YesNo

3 Topics
Measures in Looker - Data Sample and Measures calculation
Measures in Looker - Creating Measures
Measures in Looker - Measures in a look

2 Topics
Substitution operator
Quiz

8 Topics
Types of joins - Introduction and Left Join
Types of joins - Full Outer join
Types of joins - Inner Join
Types of joins - Cross Join
Relationships for joins - Introduction
Relationships for joins - Why should we use relationships for joins
Primary Keys
Quiz

4 Topics
Joins in Looker - Syntax
Joins in Looker - Syntax Example
Joins in Looker - Creating joins
Joins in Looker - Exploring joins in a look

3 Topics
Customising explore menu - Concepts and Syntax
Customising explore menu - Application in looker
Customizing Field Picker - Concepts and Syntax

2 Topics
Customizing Field Picker - Application in Looker
Git and Github : Basics

2 Topics
The final milestone!
Bonus Lecture

  Write a Review

Google Looker Masterclass: Looker & LookML A-Z 2024

Go to Paid Course