Analyzing and Visualizing Data with Looker (AVDL)

Virtual Learning:550€ + IVA

Duração icon

Duração:

1 dia

Próxima Data icon

Próxima Data:

Consulte-nos

Local icon

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

Quero inscrever-me

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

Quero inscrever-me

Partilha: