Data Analyst Bootcamp

Data Analyst Bootcamp

Summary

This in-person course takes the new Looker developer/analyst from zero to hero in less than a day. The only technical knowledge needed to get up and running as a Looker developer is practical knowledge of SQL. This course will enable the trainee to build, administer and maintain standard Looker data models and establish the foundation necessary to learn Looker’s more advanced features.

Duration

7 hours

Prerequisites

Basic knowledge of SQL including grouping, aggregating, filtering in the WHERE clause, filtering in the HAVING clause and join types including INNER, LEFT OUTER, FULL OUTER and CROSS.

Outline

10:00 - 10:30 Setup, coffee, etc.
10:30 - 10:40 Intro to LookML / Defining Terms
10:40 - 11:05 Getting Started with Looker

  1. Creating a New Project
  2. Setting up Git
  3. Looker Development Environment

10:55 - 11:05 How Looker Writes SQL
11:05 - 11:35 Creating Dimensions and Measures

  1. Custom Dimensions and Measures
  2. Date Objects
  3. Referencing Other Views

11:35 - 12:00 Model Files

  1. Explores
  2. Join Logic
  3. Symmetric Aggregates

12:00 - 1:00 Lunch provided / First workshop
1:00 - 1:40 Derived Tables

  1. When to Use Derived Tables
  2. Creating a Derived Table
  3. Creating a Persistent Derived Table

1:40 - 2:00 Table Calculations
2:00 - 2:50 Second Workshop
2:50 - 3:20 Dashboards

  1. Creating User-Defined Dashboards
  2. Filters and Listeners

3:20 - 3:40 Basic Admin Training

  1. Users
  2. Roles

3:40 - 4:00 Looker Best Practices
4:00 - 5:00 Final workshop
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 18
Looker - New York Office Jan 25
Apr 12
Looker - San Francisco Office Feb 8

Classes in bold are guaranteed to run!

United Kingdom

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

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

New York, NY

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Thursday, January 11, 2018 9:00 AM EST.
  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Thursday, March 29, 2018 9:00 AM EDT.

San Francisco, CA

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

London

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