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 Oct 2017 Nov 2017 Dec 2017 Jan 2018 Feb 2018
Looker - NEW! San Francisco Office Oct 26
Looker - New York Office Nov 8
Looker - Santa Cruz Office Dec 7

Classes in bold are guaranteed to run!

United Kingdom

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

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, November 23, 2017 9:00 AM PST.

New York, NY

  • Confirmed
    10:00 AM - 5:00 PM
    $ 800.00 USD $ 700.00 USD before Wednesday, October 25, 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 Thursday, November 9, 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