What Looker is (semantic layer + governed BI)CopyCopyCopyCopyCopyCopyCopy

Looker vs Looker Studio (where each fits)CopyCopyCopyCopyCopyCopyCopy

Typical analytics workflow: warehouse → model → explore → dashboardCopyCopyCopyCopyCopyCopyCopy

Key terms: Explore, View, Model, LookML, Dimensions, MeasuresCopyCopyCopyCopyCopyCopyCopy

Tour Looker UI, open an Explore, run basic queries, save looksCopyCopyCopyCopyCopyCopyCopy

Looker instance structure, folders, spaces, content governanceCopyCopyCopyCopyCopyCopyCopy

Looker Projects: why they matterCopyCopyCopyCopyCopyCopyCopy

Looker IDE basics: files, folders, validation, content checkCopyCopyCopyCopyCopyCopyCopy

Git connection basics (concept + workflow)CopyCopyCopyCopyCopyCopyCopy

Create/open a project, run validation, fix simple errorsCopyCopyCopyCopyCopyCopyCopy

Connections: how Looker talks to DB/warehouseCopyCopyCopyCopyCopyCopyCopy

Understanding schemas, tables, views in a warehouseCopyCopyCopyCopyCopyCopyCopy

Connection best practices (naming, permissions, read-only users)CopyCopyCopyCopyCopyCopyCopy

Test connection (demo environment), preview tables, identify keysCopyCopyCopyCopyCopyCopyCopy

LookML file types and structureCopyCopyCopyCopyCopyCopyCopy

Model file: connection, includes, exploresCopyCopyCopyCopyCopyCopyCopy

View file: dimensions, measures, timeframesCopyCopyCopyCopyCopyCopyCopy

Explore: what users see and queryCopyCopyCopyCopyCopyCopyCopy

Dimension types: string, number, yesno, date/timeCopyCopyCopyCopyCopyCopyCopy

Measures: count, sum, avg, count_distinctCopyCopyCopyCopyCopyCopyCopy

Formatting, labels, value_format, group_labelCopyCopyCopyCopyCopyCopyCopy

When to create measures vs calculations in ExploreCopyCopyCopyCopyCopyCopyCopy

date vs datetime fieldsCopyCopyCopyCopyCopyCopyCopy

timeframes and common reporting needsCopyCopyCopyCopyCopyCopyCopy

Period comparisons basics (what’s possible + workarounds)CopyCopyCopyCopyCopyCopyCopy

Handling fiscal calendars (approach + modeling hints)CopyCopyCopyCopyCopyCopyCopy

Primary key, foreign key thinkingCopyCopyCopyCopyCopyCopyCopy

Join types: left_outer, inner, full_outer (when to use)CopyCopyCopyCopyCopyCopyCopy

Relationship parameter: one_to_one, one_to_many, many_to_oneCopyCopyCopyCopyCopyCopyCopy

Fanout problem and how to catch itCopyCopyCopyCopyCopyCopyCopy

Explore design principles: default fields, hiding noiseCopyCopyCopyCopyCopyCopyCopy

Field organization: group labels, views labelingCopyCopyCopyCopyCopyCopyCopy

Always_filter, always_join, access_filter conceptsCopyCopyCopyCopyCopyCopyCopy

Drill fields and link featuresCopyCopyCopyCopyCopyCopyCopy

include, extend, refinementsCopyCopyCopyCopyCopyCopyCopy

DRY modeling: reuse views across exploresCopyCopyCopyCopyCopyCopyCopy

Basic LookML style guide: naming conventions, commentsCopyCopyCopyCopyCopyCopyCopy

Looks vs Dashboards vs TilesCopyCopyCopyCopyCopyCopyCopy

Dashboard filters (field filters, filter-only fields)CopyCopyCopyCopyCopyCopyCopy

Cross-filtering, drill-down workflowCopyCopyCopyCopyCopyCopyCopy

Layout + storytelling: what stakeholders expectCopyCopyCopyCopyCopyCopyCopy

Defining “Revenue”, “Active Users”, “Conversion” properlyCopyCopyCopyCopyCopyCopyCopy

Avoiding duplicate metrics across teamsCopyCopyCopyCopyCopyCopyCopy

Naming/label rules and documentation in LookMLCopyCopyCopyCopyCopyCopyCopy

Content governance: spaces, folders, accessCopyCopyCopyCopyCopyCopyCopy

Roles & groups overviewCopyCopyCopyCopyCopyCopyCopy

Model access vs content accessCopyCopyCopyCopyCopyCopyCopy

Row-level security concepts (user attributes + access_filter)CopyCopyCopyCopyCopyCopyCopy

Safe patterns for region/team-based data accessCopyCopyCopyCopyCopyCopyCopy

Query performance basics: what affects runtimeCopyCopyCopyCopyCopyCopyCopy

Caching behavior overviewCopyCopyCopyCopyCopyCopyCopy

Common modeling mistakes that slow queriesCopyCopyCopyCopyCopyCopyCopy

QA checklist: validation, content checks, testing totalsCopyCopyCopyCopyCopyCopyCopy