Spécialisation Creating Business Value with Data and Looker

Create custom measures based on an existing dimension

Create custom groupings

Adding filters to custom measures

Create a modeled query.

Save the modeled query in LookML.

Use the modeled query to build a Look report.

Understand when and how to add persistence and incremental updates to derived tables.

Use aggregate awareness to optimize queries on rolled up or summarized data.

Create a refinement of an existing Explore.

Use dimensions, measures, filters, and pivots to analyze and visualize data

Create advanced metrics instantaneously with table calculations

Create visualizations using Looks and dashboards

Share Looker content with others

Recognize key concepts and features in Looker Studio, including the interface, data connections and basic visualizations.

Describe the main data visualization charts and build simple reports using common chart types and data sources.

Describe the differences between types of data sources and connect to data sources using connectors.

Use data blending techniques to combine data from multiple sources.

Define LookML basic terms and building blocks

Model new dimensions and measures using LookML and use dashboards to combine key queries and visualizations into a one page executive view

Model files of LookML projects to design and build custom Explores for business users

Use derived tables in Looker to create new custom tables and use datagroups to manage caching policies