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 Dec 2017 Jan 2018 Feb 2018 Mar 2018 Apr 2018
Looker - Santa Cruz Office Jan 19
Looker - New York Office Jan 26
Mar 2
Apr 13
Looker - San Francisco Office Feb 9

Classes in bold are guaranteed to run!

United Kingdom

Location Dec 2017 Jan 2018 Feb 2018 Mar 2018 Apr 2018
Looker - London Office Feb 16

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, January 5, 2018 9:00 AM PST.

New York, NY

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, January 12, 2018 9:00 AM EST.
  • 10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, February 16, 2018 9:00 AM EST.
  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, March 30, 2018 9:00 AM EDT.

San Francisco, CA

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, January 26, 2018 10:00 AM PST.

London

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Friday, February 2, 2018 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