Advanced Analysis and Visualization with Looker

Now you can also build robust data-driven experiences by creating more than just reports and dashboards with agility never experienced before

Duration

16-hrs training course with 4 sessions of 4-hrs each

Level

Intermediate to Advanced Level

Design and Tailor this course

As per your team needs

Edit Content

This advanced course on Looker is built for experienced data analysts, data scientists, and data engineers who want to go beyond just fancy reports and visualizations. In this instructor-led advanced course on Analyzing and Visualizing using Looker, you will come across topics such as content management, LookML projects, version control, data groups and caching. These topics are covered with help of expensive hands-on lab exercises to help you gain proficiency.

After completing this course you will be able to:

Perform Table and Offset Calculations in Looker
Create and manage Looks, Dashboards, and Folders
Apply LookMl for creating Dimensions and Measures
Make use of Model files, Derived tables, Caching, and Data Groups for performance tuning

Edit Content

Quick walkthrough of Looker Concepts

Analytical Concepts
Looker UI
Pivoting Data in Looker

Table Calculations

Types of table calculations
Example: Writing and visualizing table calculations
Types of offset calculations
Example: Writing offset calculations
Lab: Working with Table Calculations and Offsets in Looker

Looks & Dashboards

Creating Looks
Adding filters to a Look
Delivering data from Looks
Creating and editing dashboards
Adding filters to a dashboard
Delivering data from dashboards

Content Management

Organizing content with folders
Creating and browsing boards

Looker & Look ML platform

Understanding your users’ experience
LookML project hierarchy
The Looker development environment

Modeling Dimensions & Measures

Modeling dimensions
Example: Creating dimensions using LookML
Modeling measures
Example: Creating measures using LookML
Advanced logic for dimensions and measures
Lab:: Creating Dimensions and Measures with LookML

Project Version Control Slided

Project version control with Git
Example: Git workflow in Looker

Model Files

How Looker writes SQL
Explores and join logic
Symmetric aggregation
Filtering Explores

Derived Table

Types of derived tables
Example: Creating SQL derived tables
Example: Creating native derived tables
Useful parameters for native derived tables
Persistent derived tables
Lab: Creating Derived Tables with LookML

Caching & DataGroups

Caching in Looker
Example: Implementing DataGroups in Looker

Labs | Getting Started with Looker

Looker Data Explorer
Filtering and Sorting Data in Looker
Merging Results from Different Explores in Looker
Looker Functions and Operators
Looker Developer
Creating Measures and Dimensions Using LookML
Creating Derived Tables Using LookML
Filtering Explores with LookML
Caching and Datagroups with LookML

Labs | Applying Advanced LookML Concepts in Looker

Getting Started with Liquid to Customize the Looker User Experience
Enhancing User Interactivity in Looker with Liquid
Creating dynamic SQL derived tables with LookML and Liquid
Answering Complex Questions Using Native Derived Tables with LookML

Labs | Manage Data Models in Looker

Modularizing LookML Code with Extends
Troubleshooting Data Models in Looker
Employing Best Practices for Improving the Usability of LookML Projects
Caching and Datagroups with LookML
Optimizing Performance of LookML Queries

Edit Content

FIND YOUR COURSE

Topics

Brands

Advanced Analysis and Visualization with Looker

Duration

Level

Design and Tailor this course

Quick Links

our Offerings

Get in touch

Sign up for DataCouch Communications

Connect

we'd love to have your feedback on your experience so far