Analyzing and Visualizing Data with Looker (AVDL)
Virtual Learning:550€ + IVA
Duração:
1 dia
Próxima Data:
Consulte-nos
Local:
Online
Descrição
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. 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.
*PVP por participante. A realização do curso nas datas apresentadas está sujeita a um quórum mínimo de inscrições.
Destinatários
Business Users who need to draw insights from data. Data Analysts who are responsible for data analysis and visualization within their organizations.
-
Área: Google Cloud
Programa:
Module 1: The Looker platform
This module provides an overview of the Looker user interface and its key components for data explorers.
Lessons:
- What is Looker?
- Looker user interface
- Organizing content with folders
Module 2: Data analysis building blocks
This module reviews three data analysis building blocks - dimensions, measures, and filters.
Lessons:
- Dimensions in Looker
- Measures in Looker
- Example: Exploring measures using customer data
- Using dimensions and measures
- Example: Combining dimensions and measures
- Filtering dimensions
- Filtering measures
- Example: Filtering with measures
- Lab: Analyzing and Visualizing Data in Looker
Module 3: Working with Looker content
This module explores the use of dashboards for multiple visualizations and boards to curate Looker content.
Lessons:
- Filtering Looks
- Introducing dashboards
- Filtering dashboards
- Curating Looker content in boards
- Example: Board creation
Module 4: Customizing Explores
This module explores pivoting data in Looker to turn a selected dimension into several columns. The module also covers the writing of table calculations to instantaneously create new metrics and offset calculations to programmatically reference values from other rows or columns in your query results to calculate new values.
Lessons:
- Pivoting data in Looker
- Example: Working with pivots
- Introduction to table calculations
- Types of table calculations
- Writing table calculations
- Example: Writing and visualizing table calculations
- Example: Percent of total table calculations
- Introducing offset functions
- Writing offset calculations
- Example: Writing offset calculations
- Lab: Getting Started with Table Calculations and Offsets in Looker
Module 5: Creating new Looker content
This module explores the creation of single, stand-alone reports (Looks) and dashboards, which can be used to combine individual visualizations.
Lessons:
- Creating new Looks
- Creating new dashboards
Module 6: Sharing Looker data with others
This module explores how you can share or export content from Looker.
Lessons:
- Sharing and scheduling Looks
- Sharing and scheduling dashboards
- Tile-level dashboard alerts
Partilha: