Advanced Data Analyst Bootcamp

Advanced Data Analyst Bootcamp

Summary

This course empowers the Looker developer to take advantage of Looker’s most advanced features—consider it the grad school of Looker technical education. The course highlights the more complex Looker use cases, and includes ample co-development time with Looker analysts. Come expecting to learn a lot, get some real work done, and have a lot of fun!

Duration

7 hours

Prerequisites

Solid grasp of SQL and familiarity with creating Dimensions, Measures, Explores, Models and Derived Tables in Looker.

Outline

10:00 - 10:30 Setup, coffee, etc.
10:30 - 11:30 Advanced Looker Features

  1. HTML and Liquid Templating
  2. Reusing Code with Extends
  3. Filtering an Explore

11:30 - 12:00 Advanced Derived Tables

  1. Derived Tables with Templated Filters
  2. Cascading Persistent Derived Tables

12:00 - 1:00 Lunch provided and first workshop
1:00 - 1:45 Debugging Looker

  1. Unknown or Inaccessible Field
  2. When Looks break

1:45 - 2:15 Column Level Calculations

  1. Window Functions
  2. Correlated Subqueries

2:15 - 3:00 Second Workshop
3:00 - 3:30 Advanced Admin Training

  1. User Permissioning
  2. Roles
  3. Access Filter Fields
  4. Monitor & Explore Looker Instance

3:30 - 3:45 Looker Best Practices 
3:45 - 4:10 How to Train Looker End Users 
4:10 - 5:00 Final workshop / Codev
5:00 - 6:30 Happy hour!

Upcoming Classes

United States

Location Oct 2017 Nov 2017 Dec 2017 Jan 2018 Feb 2018
Looker - NEW! San Francisco Office Oct 27
Looker - New York Office Nov 9
Looker - Santa Cruz Office Dec 8

Classes in bold are guaranteed to run!

United Kingdom

Location Oct 2017 Nov 2017 Dec 2017 Jan 2018 Feb 2018
Looker - London Office Nov 24

Classes in bold are guaranteed to run!

Onsite Training

For groups of three or more

Request Quote

Public Training

Santa Cruz

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, November 24, 2017 9:00 AM PST.

New York, NY

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Thursday, October 26, 2017 9:00 AM EDT.

San Francisco, CA

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD

London

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, November 10, 2017 9:00 AM GMT.

Classes marked with Confirmed are guaranteed to run. Sign up now while there is still space available!


Don't see a date that works for you?

Request Class