• Post category:StudyBullet-8
  • Reading time:9 mins read


Learn LookML, Google Looker’s modeling language, to get complete control of the visualization process | LookML mastery

What you will learn

Learn LookML – the language that powers Looker

Dimensions in Looker and managing them using LookML

Measures in Looker and managing them using LookML

Types of joins and syntax in LookML

Version control using Git

Description

If you are searching for a course to learn LookML, the language that powers Google Looker, then this is the training for you.

In this course, we will start from the very basic level and cover all the important aspects of LookML

This is a concise, only four hour course and can be easily completed in just one weekend.

Below are some frequently asked questions about LookML and Looker:

What is LookML used for?

LookML is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database. Looker uses a model written in LookML to construct SQL queries against a particular database.

Is LookML easy to learn?

Looker ML is a very simple language that anyone can learn, once they have mastered the fundamentals. In this course, we will go step-by-step to learn this from beginner level to advanced level.

Is LookML similar to SQL?

In short, LookML is SQL evolved. It leverages SQL’s power in a way that’s familiar to analysts, while abstracting away the low-level concerns that analysts usually have to manage. It’s a powerful language with a huge community of developers who support each other.

A Verifiable Certificate of Completion is presented to all students who undertake this LookML course.

Why should you choose this course?

This is a complete and concise tutorial on LookML which can be completed within 4-5 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant operations.


Get Instant Notification of New Courses on our Telegram channel.


What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. We have in-depth understanding on and practical exposure to Google Looker and Data Visualization.

We are also the creators of some of the most popular online courses – with over 1,000,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! – Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. – Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, Google Looker, LookML or anything related to any topic, you can always post a question in the course or send us a direct message.

And so much more!

By the end of this course, your confidence in using LookML will soar. You’ll have a thorough understanding of how to use LookML for creating insightful dashboards and beautiful reports.

Go ahead and click the enroll button, and I’ll see you in lesson 1 of this Google Data Studio course!

Cheers

Start-Tech Academy

English
language

Content

Introduction

Why to use LookML

LookML

Advantages of LookML
Milestone!
LookML important terms
Interface of LookML
How to create Views in LookML
SQL runner in Looker

Dimensions in Looker

Dimensions – Syntax ed
Dimensions – Number
Dimensions – String
Dimensions – YesNo
Dimensions – Tier
Dimensions – Location – Tier
Dimensions – Date Time and Others

Creating Dimensions in Looker

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

Measures

Measures – Syntax
Measures – Average
Measures – Average Distinct
Measures – Count and Count Distinct
Measures – Other common measures
Measures – Running total
Measures – Percent of previous
Measures – Percent of total
Measures – List
Measures – YesNo

Creating Measures in Looker

Measures in Looker – Data Sample and Measures calculation
Measures in Looker – Creating Measures
Measures in Looker – Measures in a look

Substitution operator

Substitution operator

Joins Prerequisites

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

Creating Joins in Looker

Joins in Looker – Syntax
Joins in Looker – Syntax Example
Joins in Looker – Creating joins
Joins in Looker – Exploring joins in a look

Customization in Looker

Customizing explore menu – Concepts and Syntax
Customizing explore menu – Application in looker
Customizing Field Picker – Concepts and Syntax

Git and Github : Basics

Customizing Field Picker – Application in Looker
Git and Github : Basics

Congratulations & About your certificate

The final milestone!
Bonus Lecture