Looker Learning Tutorial For Beginners

Practical Looker course for beginners that want to quickly get up to speed with Looker and LookML

Last updated 2022-01-10 | 4.3

- Learn the Looker platform and interface
- Learn LookML from the basics
- Learn best practices for using Looker and LookML

What you'll learn

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

* Requirements

* Basic understanding of SQL will help but not mandatory

Description

Welcome! I am here to help you learn quickly how to use Looker and LookML

[Jan 2022 Update]: Course is fully updated to capture the newest interface of Looker and its Sandbox environment. Additional lessons added to capture new functionality

[Dec 2021 Update]: 2 hours of content added

[October 2021 Update]: A new section on Git branches was included

[August 2021 Update]: Lessons updated to cover the new sandbox envrionment introduced this month

------------------------------------------------------------------------

Beginners welcome: no need to know anything about Looker and LookML!

Looker can be challenging to learn on your own without guidance from an experienced trainer. In this course, I will walk you through every step of using Looker and LookML in an easy to undertand way for the absolute beginner.

This course will give you a deep understanding of Looker's functionality by using hands-on, contextual examples designed to showcase why Looker is awesome and how how to use it for any project.

In this Looker course you will learn:

· How to setup a free training account with Looker

· Get familiar with the Looker interface

· How to build Looks in Looker

· How to edit a Look

· How to build a dashboard

· The different elements of LookML

· How to create a custom dimension

· How to create a view from table

· Understand the different dimension types

· How to structure your project

· How to use Explores

· How to utilize the formal Looker documentation

· How to create a model in the Development environment

· The interface of the Development environment

... and much, much more!


Enroll today and enjoy:

  • Lifetime access to the course and all future updates

  • 5+ hours of high quality, up to date video lectures

  • Practical Looker course with step by step instructions on how to implement the different features

Thanks again for checking out my course and I look forward to seeing you in the classroom :)

Who this course is for:

  • Users with no or little experience with Looker and LookML

Course content

16 sections • 96 lectures

Setting up a Sandbox environment - Part 1 Preview 02:12

Setting up a Sandbox environment - Part 2 (Qwiklabs) Preview 08:07

Sandbox tip - limit of labs usage Preview 02:33

The Interface Preview 03:26

What is an Explore in Looker? Preview 08:18

Filtering Explores Preview 04:31

Sorting our data Preview 01:11

Row Limit and Totals in Explores Preview 02:32

In Use & Clear fields options Preview 02:04

Pivoting in Explores Preview 08:14

Cache data in Looker Preview 04:22

SQL section in Explores Preview 05:28

Advanced Topic - What stand behind the Explores? Preview 05:11

Into to the Visualization section Preview 01:53

Table Visulizations Preview 12:30

Column chart Preview 09:36

Bar charts Preview 03:55

Scatterplot Visualizations Preview 10:13

Line Chart Preview 04:36

Area Chart Preview 06:34

Pie Chart Preview 08:55

Map Chart Preview 14:57

Single Value Preview 09:02

Donut Multiples Preview 06:30

Single Record Preview 04:07

Table Legacy visulization Preview 07:02

Word Cloud Preview 05:37

What are Custom Fields? Preview 03:43

Create a custom dimension - group items Preview 06:40

Custom Binning Preview 09:50

Create a custom measure from a dimension Preview 05:20

Create a custom measure 2 Preview 05:12

Apply filters to our custom fields Preview 08:03

Creating a custom dimension using a Looker expression Preview 05:57

Looker Expressions - Part 2 Preview 04:50

Filters - The Basics Preview 04:25

Filters - The Basics Part 2 Preview 04:25

Matches Advanced filtering expressions Preview 05:26

Custom Filter options Preview 07:41

Creating our first Look Preview 09:18

Editing our saved Look Preview 05:54

Looks options - Sending, Sharing, Scheduling, adding to Boards and more Preview 11:41

Creating our first Dashboard - Part 1 Preview 20:52

Creating our first Dashboard - Part 2 Preview 06:59

Dashboard filtering Preview 12:37

Cross-filtering Preview 03:27

Dashboard settings Preview 03:52

Dashboard options Preview 11:11

Explore the LookML environment Preview 04:34

Elements of LookML Preview 02:27

Fields Preview 02:20

Views Preview 02:02

Explore Preview 02:56

Models Preview 03:21

Project Preview 07:57

Dimension and Measure Fields Preview 03:49

Dimension Types Preview 05:07

Create Folders and tidy up your space Preview 06:10

Create a view Preview 04:28

Create dimensions on our view Preview 05:23

Create a measure in our view Preview 04:16

Commit Changes and Deploy to Production Preview 01:53

Join a View to an existing Model and Explore Preview 06:46

Create a new custom dimension based on calculation Preview 07:28

Create a new custom measure Preview 05:01

Decimals in our custom measure Preview 03:00

Add filters to your Explores using LookML - Always_Filter Preview 05:57

Add filters in LookML - Part 2 (sql_always_where) Preview 05:39

Add filters in LookML - Part 3 (sql_always_having) Preview 03:19

Add filters in LookML - Part 4 (conditionality_filter) Preview 05:31

Using commenting in LookML Preview 04:31

Create our first Model in LookML Preview 04:02

Create a join Preview 11:34

Limiting fields in a join Preview 03:55

Changing field names Preview 01:53

Dashboards - User-Defined vs LookML Dashboards Preview 04:26

Datagroups in LookML Preview 07:56

Apply the datagroup Preview 04:58

LookML reference Preview 07:36

The Looker Community Preview 04:25

Introduction to Git branches Preview 04:55

Creating a new Git branch Preview 03:28

Switch to another Git branch Preview 02:23

Managing Git branches Preview 02:39

Commiting changes Preview 04:07

Uncommitted changes Preview 02:40

View and Revert changes on single file Preview 01:45

Utilize the Looker documentation Preview 03:39

Thank you and Closing Remarks Preview 01:13

Bonus Lecture Preview 01:07