LookML A-Z: Google Looker for Developers

LookML describes dimensions, aggregates, calculations, and data relationships, enabling reusable fields, version control, precise debugging, and support for many-to-one to many-to-many joins to simplify complex data models for dashboards.

Celebrate reaching the milestone and stay motivated as you progress through LookML A-Z: Google Looker for Developers, while learning to rate the course and use Q&A and AI assistant.

Learn LookML terms such as local project, views, explores, and models, and how dashboards link to explores. Understand dimensions and measures with aggregates like count, sum, average, min, and max.

Define a dimension with type number to compute profit as revenue minus cost, and format the result with value format options such as usd, rupee, integer, or two decimals.

Explore the boolean yes/no data type in LookML dimensions, where status equals paid yields yes and not paid yields no, using a case when expression to create a boolean variable.

Learn to plot data on a map by creating a location dimension in LookML, specifying latitude and longitude fields to visualize store locations.

Define time data types in LookML by creating a dimension with a type and a square block, exploring daytime date, date time of the day, and hour data types.

Define a running total measure in LookML by naming the measure, setting type to running total on a field, and optionally formatting as USD for sales dashboards.

Learn how yes/no measures evaluate conditions on aggregated data in Looker. Create a boolean measure like is_large_total to test whether total sales price exceeds a threshold.

Explore creating two Looker measures from flight data to assess airport performance: a median departure delay by airport and an average taxi-out time, revealing efficiency differences across airports.

LookML lesson on measures: create a median departure delay measure to mitigate outliers from weather or accidents, add a taxi out time measure using average, then validate syntax.

Master the substitution operator to reference columns from the connected table, refer to dimensions and measures in the current or other views, and reuse base table columns with precise syntax.

Explore the four join types in Looker—cross join, left outer join, full outer join, and inner join—and understand how cross join yields all combinations between two tables.

Explore how to perform joins across tables using a common key such as the DNA ID column, and master 1-to-1, many-to-one, one-to-many, and many-to-many relationships in LookML for Looker developers.

Learn to create a left join in Looker LookML, linking flights to airports with a many-to-one relation on origin, supporting multi-view joins and validation without errors.

Learn to customize the explore menu using label, group label, and description to rename models and explorers, organize with subheadings, and hide explorers on front end without back end changes.