Google Cloud

Analyzing and Visualizing Data in Looker

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. You learn to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance. You also discover how to ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.

7 hours · Virtual
7 hours
Virtual

Define Looker and the capabilities it provides for working with data. Use dimensions, measures, and filters to analyze and visualize data. Use dashboards for multiple visualizations and boards to curate Looker content. Create advanced metrics by pivoting Looker data and writing table and offset calculations. Create visualizations using Looks and dashboards, and share Looker content with others.

Module 1: The Looker PlatformDefine the value proposition of the Looker platform. Explain Looker’s role in the data analysis process. Describe Looker's main user interface components. Interpret Looker’s hierarchical folder structure for content. Discuss different content locations within the Looker platform.Module 2: Data Analysis Building BlocksDefine the purpose of a dimension and measure in Looker. Identify where end users work with dimensions, measures, and filters.Explain how dimensions, measures, and filters contribute to the larger data analysis process in Looker. Identify what asset a dimension corresponds to in your database. • Identify what SQL functions a measure can correspond to. Explain how to filter by a dimension.Module 3: Working with Looker ContentExplain how to filter within a Look and a dashboard. Identify where users can work with dashboards and boards, and filter within Looks and dashboards. Explain how dashboards, boards, and filtering can contribute to the data analysis process. Define the purpose of a dashboard. Explain what a board is in Looker. Detail the process of creating a board. Detail the process for pinning Looks and dashboards to a board.Module 4: Customizing ExploresExplain the process of pivoting data. Identify where users can pivot data, write table calculations, and write offset calculations. Identify situations to consider pivoting data and writing a new table calculation.Explain how pivoting data, writing table calculations, and writing offset calculations can contribute to the data analysis process. Differentiate between a table calculation and an offset calculation. Discuss the various types of table calculations. Detail the process to write table calculations and offset calculations.Module 5: Creating New Looker ContentExplain how to create a new Look and dashboard in Looker. Identify where users can create new Looks and dashboards.Module 6: Sharing Looker Data with OthersList the options to share Looks and dashboards once or with a regular schedule. Identify where users can send or schedule Looks and dashboards, and configure tile-level dashboard alerts. Explain how to configure a shared or scheduled Look or dashboard. Discuss how to choose options that are appropriate for a given situation or business case. Identify the options to schedule a tile-level dashboard alert.

Business users who need to draw insights from data. Data analysts who are responsible for data analysis and visualization within their organizations.Prerequisite:None

Upcoming Sessions

Contact us for upcoming dates

There are currently no upcoming sessions scheduled for this course.

Request Information