Analyzing and Visualizing Data with Looker (GO-AVDL)

This course is an introductory-level training that outlines Looker’s capabilities for working with data and provides guided demos and hands-on practice with Looker functionality for data exploration, analysis and visualization.


This course enables learners to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Participants will learn how to leverage Looker's modern analytics platform to find and explore relevant content in their organization’s Looker instance, ask questions of 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.


Prerequisites

None.


Course Objectives

Upon completion of this course, participants will be able to:

  • 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 dashboards to combine and share visualizations.
  • Use folders and boards in Looker to organize content for navigability and discoverability.

Not covered in this course:

  • LookML (Looker Modeling Language)
  • Looker admin features and functions
Show details


Detailed Course Outline

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


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


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


Module 4 - Dashboards

Topics - Looker dashboards, data delivery options

  • Understand how to use dashboards in Looker to share data and results with stakeholders
  • Create dashboards to visualize multiple aspects of a business topic or domain
  • Add new content to an existing dashboard
  • Add filters to a dashboard for flexible analysis of a subset of the data
  • Deliver data outside of Looker for access by other stakeholders or systems


Module 5 - Content Management

Topics - Looker content organization, folders, boards

  • Explain how to use folders in Looker to organize content for navigability and discoverability
  • Create and share boards to centralize content pertaining to one topic or theme