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.

Navigate the Looker interface in sandbox and production modes, using file and object browsers to edit models, views, and measures, then validate and push changes to production.

Create views from tables in Looker LookML by converting tables to views with dimensions and measures; use the file explorer to create views with a few clicks.

Explore ad hoc data analysis with Looker's sql runner in development mode, run dialect-specific queries, view results, create visualizations, and share the analysis via URL.

Learn to create dimensions in LookML by adding a dimension to a view, defining name, type, and logic in a square block, with a prophet example using revenue minus cost.

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.

Define a string dimension to hold text data such as first name, last name, and address, and concatenate them with a space to form a full name.

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.

Create a tiered dimension by binning a numeric field with a case statement, defining bins such as 0–30, 30–60, and 60+, using interval style or classic display.

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.

Build Looker views from tables in a sandbox, import data, and create location and address variables to plot airport and flight data on maps.

Create airport view dimensions in Looker by concatenating full name, city, state, and country into a full address, then build a map location using latitude and longitude.

Create a LookML model to enable exploring the view in Looker. Build an explore for airports data to view the created variables and verify the sandbox connection.

Build a LookML model for an airport dashboard with an airport view and explore, adding full address and map location variables to plot longitude and latitude on a map.

Create a flight speed dimension in Looker using LookML, computing speed as distance divided by time, and handle zero flight time with a case statement to prevent division by zero.

Learn how to define measures in LookML, creating aggregate values like average order and revenue, with syntax blocks and value format USD.

Explore the average measure in LookML, learn how to apply it to a specific column to compute the average order value, and format the result as currency per customer.

Explain how duplicates inflate order shipping costs and mislead averages, and demonstrate average_distinct with a distinct key on order_id and order_shipping to compute the true mean.

Define measures in LookML with count and count distinct to tally entries or distinct values, and use drill_fields to add interactive product details on dashboards.

Discover common measures in Looker, including min, max, and median, plus median distinct. Learn how sum distinct and percentile and percentile distinct handle distinct values and repeated rows.

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.

Explore how to use the percentage of previous measure to quantify month-over-month changes, showing how to calculate decreases and increases in order counts using a real-world example.

Calculate the percentage of total to show each month’s contribution to the gross margin total, dividing 43 and 68 by 233 to yield 19% and 30% in LookML.

Explore how the list function aggregates string values into comma separated lists per group, preserving all items for each authority.

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.

Learn to create and use measures in Looker, analyze taxi outbound time and median departure delay by origin airport, and apply filters to focus on airports with over 100 flights.

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.

Learn how to join multiple tables in Looker with left outer joins, preserving all left-table records while retrieving matching data from the right table.

Explore full outer joins by combining all data from both tables, including the common rows and unmatched records, illustrated with event id and user id examples.

Explore inner join behavior by matching common user id data across two tables to return only the intersecting garment data.

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 how to use Looker relationships to correctly join tables, prevent duplicate shipping costs in aggregates, and choose from one-to-one, one-to-many, many-to-one, and many-to-many relationships.

Learn how primary keys ensure correct joins in Looker by declaring primary keys for related views and using relationship types to preserve accurate totals.

Explore the syntax for joining multiple views in Looker, including join types, relationships, and join conditions, with practical examples like linking order items to orders.

Learn to join the flights and airports tables in Looker using a left join, many-to-one relationships, and origin airport code to enrich flights with airport details.

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.

Explore joining airport and flights data in a Looker explore to view airport and flights metrics, map airports colored by tax code, and drill down by state for insights.

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.

Learn to customize the explore menu in Looker by labeling models and explores, adding descriptions, and adjusting how explorer names, dimensions, and measures are displayed.

Learn to customize field display in Looker explorations by using label and description, hiding irrelevant fields, and grouping related fields under a group label for clearer dashboards.