Analyzing and Visualizing Data with Looker (AVDL) – Outline

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
  • 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