What Looker is (semantic layer + governed BI)CopyCopyCopyCopyCopy

Looker vs Looker Studio (where each fits)CopyCopyCopyCopyCopy

Typical analytics workflow: warehouse → model → explore → dashboardCopyCopyCopyCopyCopy

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

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

Looker instance structure, folders, spaces, content governanceCopyCopyCopyCopyCopy

Looker Projects: why they matterCopyCopyCopyCopyCopy

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

Git connection basics (concept + workflow)CopyCopyCopyCopyCopy

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

Connections: how Looker talks to DB/warehouseCopyCopyCopyCopyCopy

Understanding schemas, tables, views in a warehouseCopyCopyCopyCopyCopy

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

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

LookML file types and structureCopyCopyCopyCopyCopy

Model file: connection, includes, exploresCopyCopyCopyCopyCopy

View file: dimensions, measures, timeframesCopyCopyCopyCopyCopy

Explore: what users see and queryCopyCopyCopyCopyCopy

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

Measures: count, sum, avg, count_distinctCopyCopyCopyCopyCopy

Formatting, labels, value_format, group_labelCopyCopyCopyCopyCopy

When to create measures vs calculations in ExploreCopyCopyCopyCopyCopy

date vs datetime fieldsCopyCopyCopyCopyCopy

timeframes and common reporting needsCopyCopyCopyCopyCopy

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

Handling fiscal calendars (approach + modeling hints)CopyCopyCopyCopyCopy

Primary key, foreign key thinkingCopyCopyCopyCopyCopy

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

Relationship parameter: one_to_one, one_to_many, many_to_oneCopyCopyCopyCopyCopy

Fanout problem and how to catch itCopyCopyCopyCopyCopy

Explore design principles: default fields, hiding noiseCopyCopyCopyCopyCopy

Field organization: group labels, views labelingCopyCopyCopyCopyCopy

Always_filter, always_join, access_filter conceptsCopyCopyCopyCopyCopy

Drill fields and link featuresCopyCopyCopyCopyCopy

When derived tables are required (complex logic, pre-aggregation)CopyCopyCopyCopyCopy

SQL Derived Table vs Persistent Derived Table (PDT)CopyCopyCopyCopyCopy

Basic datagroups concept for refresh controlCopyCopyCopyCopyCopy

include, extend, refinementsCopyCopyCopyCopyCopy

DRY modeling: reuse views across exploresCopyCopyCopyCopyCopy

Basic LookML style guide: naming conventions, commentsCopyCopyCopyCopyCopy

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

Avoiding duplicate metrics across teamsCopyCopyCopyCopyCopy

Naming/label rules and documentation in LookMLCopyCopyCopyCopyCopy

Content governance: spaces, folders, accessCopyCopyCopyCopyCopy

Roles & groups overviewCopyCopyCopyCopyCopy

Model access vs content accessCopyCopyCopyCopyCopy

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

Safe patterns for region/team-based data accessCopyCopyCopyCopyCopy

Query performance basics: what affects runtimeCopyCopyCopyCopyCopy

Caching behavior overviewCopyCopyCopyCopyCopy

Common modeling mistakes that slow queriesCopyCopyCopyCopyCopy

QA checklist: validation, content checks, testing totalsCopyCopyCopyCopyCopy