Analyzing and Visualizing Data with Looker (AVDL)

 

Course Overview

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.

Who should attend

  • Business users who need to draw insights from data.
  • Data analysts who are responsible for data analysis and visualization within their organizations.

Course Objectives

  • Define Looker and the capabilities it provides for working with data
  • Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots)
  • Use dimensions, measures, filters, and pivots to analyze and visualize data
  • Create advanced metrics instantaneously with table calculations
  • Create and share visualizations using Looks and dashboards
  • Discuss the use of folders and boards in Looker to manage and organize content

Follow On Courses

Outline: Analyzing and Visualizing Data with Looker (AVDL)

Module 1 - Introduction to Looker

Topics - Looker interface and components

  • Define Looker and the capabilities it provides for working with data
  • Navigate the Looker interface to access data and functionality
  • 1 demo, 1 quiz

Module 2 - Core Analytics Concepts

Topics - Dimensions, measures, filters, pivots

  • Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots)
  • Use dimensions to access data attributes
  • Use measures to aggregate data attributes
  • Combine dimensions and measures for richer data analysis and visualization
  • Filter dimensions and measures to analyze a subset of the data
  • Use pivots to restructure and group data
  • 4 demos, 1 quiz, 1 lab

Module 3 - Table Calculations

Topics - Table calculations, offset functions

  • Explain how table calculations and offset functions are used to work with data in Looker
  • List the types of table calculations and offset functions available in Looker
  • Create new metrics instantaneously with table calculations and offset functions
  • 4 demos, 1 quiz, 1 lab

Module 4 - Looks and Dashboards

Topics - Looks, Looker dashboards, data delivery options

  • Explain how to create and deliver Looks and dashboards in Looker to share results with stakeholders
  • Discuss how to create and share standalone visualization reports called Looks
  • Discuss how to create and share dashboards to combine multiple visualizations for a business topic or domain
  • Add new content to an existing dashboard
  • Add filters to a Look or dashboard for flexible analysis of a subset of the data
  • Discuss the delivery of data outside of Looker for access by other stakeholders or systems
  • 1 demo, 1 quiz

Module 5 - Content Management

Topics - Looker content organization, folders, boards

  • Explain how to use folders in Looker to organize content for navigability and discoverability
  • Discuss the creating and sharing of boards to centralize content that lives in different folders in a Looker instance
  • 1 demo, 1 quiz

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • Online Training: CAD 785
  • Online Training: US$ 595
Classroom Training

Duration
1 day

Price
  • Canada: CAD 785

Click on town name or "Online Training" to book Schedule

Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.

United States

Online Training 09:00 US/Central Enroll

Canada

Online Training 09:00 Canada/Central Enroll