IIRF Online > Office Productivity > Google > Google Looker > Google Looker Masterclass: Looker & LookML A-Z 2024
Google Looker Masterclass: Looker & LookML A-Z 2024 by Udemy
Complete course on Looker (includes LookML) | Looker for both business users as well as developers
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)
Skills you will learn!
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
Google Looker Masterclass: Looker & LookML A-Z 2024
Thank You!
Your review has been submitted successfully.