Analyzing and Visualizing Data in Looker

Who this course is for?

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

Prerequisite

• No pre-learning or knowledge prerequisites required

Course Outline

• Module 1: Introduction to looker
  • Define Looker and the capabilities it provides for working with data
  • Navigate the Looker user interface to access data and functionality
• Module 2: Core Analytics Concepts
  • 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
  • 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: Looks and Dashboards
  • Explain how to create and deliver Looks and dashboards in Looker to share results with stakeholders
  • Create and share standalone visualization reports called Looks
  • 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
  • Deliver data outside of Looker for access by other stakeholders or systems
• Module 5: Content Management
  • Use folders in Looker to organize content for navigability and discoverability
  • Create and share boards to centralize content that lives in different folders in a Looker instance