Analyzing and Visualizing Data in Looker
(1 day)
In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done only by SQL-savvy 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.
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 dashboards to combine and share visualizations
- Utilize folders and boards in Looker to organize content for navigability and discoverability.
Audience
- Business users who need to draw insights from data.
- Data analysts who are responsible for data analysis and visualization within their organizations.
Course Outline
Module 1: Introduction to Looker
- 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
- 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: Dashboards
- 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
- 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