IIRF Online > Office Productivity > Google > Google Looker > Looker and LookML - The Complete Course for Beginners
Looker and LookML - The Complete Course for Beginners by Udemy
Practical Looker course for beginners that want to quickly get up to speed with Looker and LookML
Course Highlights
- Learn the Looker platform and interface
- Learn LookML from the basics
- Learn best practices for using Looker and LookML
- Become confident in using Looker for any project
- Be able to create analysis using Looker
Skills you will learn!
Curriculum
1 Topic
Introduction
4 Topics
Setting up a Sandbox environment - Part 1
Setting up a Sandbox environment - Part 2
Sandbox tip - limit of labs usage
The Interface
9 Topics
What is an Explore in Looker?
Filtering Explores
Sorting our data
Row Limit and Totals in Explores
In Use & Clear fields options
Pivoting in Explores
Cache data in Looker
SQL section in Explores
Advanced Topic - What stand behind the Explores?
14 Topics
Into to the Visualization section
Table Visulizations
Column chart
Bar charts
Scatterplot Visualizations
Line Chart
Area Chart
Pie Chart
Map Chart
Single Value
Donut Multiples
Single Record
Table Legacy visulization
Word Cloud
8 Topics
What are Custom Fields?
Create a custom dimension - group items
Custom Binning
Create a custom measure from a dimension
Create a custom measure 2
Apply filters to our custom fields
Creating a custom dimension using a Looker expression
Looker Expressions - Part 2
4 Topics
Filters - The Basics
Filters - The Basics Part 2
Matches Advanced filtering expressions
Custom Filter options
3 Topics
Creating our first Look
Editing our saved Look
Looks options - Sending Sharing Scheduling adding to Boards and more
6 Topics
Creating our first Dashboard - Part 1
Creating our first Dashboard - Part 2
Dashboard filtering
Cross-filtering
Dashboard settings
Dashboard options
5 Topics
Looker Shortcuts
The History option
Looker Marketplace
Boards
Boards - Part 2
9 Topics
Explore the LookML environment
Elements of LookML
Fields
Views
Explore
Models
Project
Dimension and Measure Fields
Dimension Types
9 Topics
Create Folders and tidy up your space
Create a view
Create dimensions on our view
Create a measure in our view
Commit Changes and Deploy to Production
Join a View to an existing Model and Explore
Create a new custom dimension based on calculation
Create a new custom measure
Decimals in our custom measure
10 Topics
Add filters to your Explores using LookML - Always_Filter
Add filters in LookML - Part 2 (sql_always_where)
Add filters in LookML - Part 3 (sql_always_having)
Add filters in LookML - Part 4 (conditionality_filter)
Using commenting in LookML
Create our first Model in LookML
Create a join
Limiting fields in a join
Changing field names
Dashboards - User-Defined vs LookML Dashboards
4 Topics
Datagroups in LookML
Apply the datagroup
LookML reference
The Looker Community
4 Topics
Introduction to Git branches
Creating a new Git branch
Switch to another Git branch
Managing Git branches
3 Topics
Commiting changes
Uncommitted changes
View and Revert changes on single file
3 Topics
Utilize the Looker documentation
Thank you and Closing Remarks
Bonus Lecture
Looker and LookML - The Complete Course for Beginners
Related Google Looker Courses
Thank You!
Your review has been submitted successfully.