Skip to Scheduled Dates
Course Overview
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.
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.
- Use folders and boards in Looker to organize content for navigability and discoverability.
Course Outline
1 - Introduction to Looker
- Define Looker and the capabilities it provides for working with data
- Navigate the Looker interface to access data and functionality
- 1 demo
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
- 4 demos, 1 quiz, 1 lab
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
- 4 demos, 1 quiz, 1 lab
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
- 1 demo
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
- 1 demo