Curriculum
- 15 Sections
- 56 Lessons
- 22 Hours
Expand all sectionsCollapse all sections
- Module 1: Looker Basics + BI Workflow5
- 1.1What Looker is (semantic layer + governed BI)CopyCopyCopyCopyCopyCopyCopyCopy
- 1.2Looker vs Looker Studio (where each fits)CopyCopyCopyCopyCopyCopyCopyCopy
- 1.3Typical analytics workflow: warehouse → model → explore → dashboardCopyCopyCopyCopyCopyCopyCopyCopy
- 1.4Key terms: Explore, View, Model, LookML, Dimensions, MeasuresCopyCopyCopyCopyCopyCopyCopyCopy
- 1.5Tour Looker UI, open an Explore, run basic queries, save looksCopyCopyCopyCopyCopyCopyCopyCopy
- Module 2: Setup, Projects, and Looker IDE5
- 2.1Looker instance structure, folders, spaces, content governanceCopyCopyCopyCopyCopyCopyCopyCopy
- 2.2Looker Projects: why they matterCopyCopyCopyCopyCopyCopyCopyCopy
- 2.3Looker IDE basics: files, folders, validation, content checkCopyCopyCopyCopyCopyCopyCopyCopy
- 2.4Git connection basics (concept + workflow)CopyCopyCopyCopyCopyCopyCopyCopy
- 2.5Create/open a project, run validation, fix simple errorsCopyCopyCopyCopyCopyCopyCopyCopy
- Module 3: Connecting Data (Warehouse + Connections)4
- 3.1Connections: how Looker talks to DB/warehouseCopyCopyCopyCopyCopyCopyCopyCopy
- 3.2Understanding schemas, tables, views in a warehouseCopyCopyCopyCopyCopyCopyCopyCopy
- 3.3Connection best practices (naming, permissions, read-only users)CopyCopyCopyCopyCopyCopyCopyCopy
- 3.4Test connection (demo environment), preview tables, identify keysCopyCopyCopyCopyCopyCopyCopyCopy
- Module 4: LookML Foundations (Model + View + Explore)4
- Module 5: Dimensions & Measures That Make Sense4
- 5.1Dimension types: string, number, yesno, date/timeCopyCopyCopyCopyCopyCopyCopyCopy
- 5.2Measures: count, sum, avg, count_distinctCopyCopyCopyCopyCopyCopyCopyCopy
- 5.3Formatting, labels, value_format, group_labelCopyCopyCopyCopyCopyCopyCopyCopy
- 5.4When to create measures vs calculations in ExploreCopyCopyCopyCopyCopyCopyCopyCopy
- Module 6: Time Intelligence (Dates Done Properly)4
- 6.1date vs datetime fieldsCopyCopyCopyCopyCopyCopyCopyCopy
- 6.2timeframes and common reporting needsCopyCopyCopyCopyCopyCopyCopyCopy
- 6.3Period comparisons basics (what’s possible + workarounds)CopyCopyCopyCopyCopyCopyCopyCopy
- 6.4Handling fiscal calendars (approach + modeling hints)CopyCopyCopyCopyCopyCopyCopyCopy
- Module 7: Joins & Relationships (Avoid Wrong Numbers)4
- 7.1Primary key, foreign key thinkingCopyCopyCopyCopyCopyCopyCopyCopy
- 7.2Join types: left_outer, inner, full_outer (when to use)CopyCopyCopyCopyCopyCopyCopyCopy
- 7.3Relationship parameter: one_to_one, one_to_many, many_to_oneCopyCopyCopyCopyCopyCopyCopyCopy
- 7.4Fanout problem and how to catch itCopyCopyCopyCopyCopyCopyCopyCopy
- Module 8: Explores That Users Love (Clean, Governed, Fast)4
- 8.1Explore design principles: default fields, hiding noiseCopyCopyCopyCopyCopyCopyCopyCopy
- 8.2Field organization: group labels, views labelingCopyCopyCopyCopyCopyCopyCopyCopy
- 8.3Always_filter, always_join, access_filter conceptsCopyCopyCopyCopyCopyCopyCopyCopy
- 8.4Drill fields and link featuresCopyCopyCopyCopyCopyCopyCopyCopy
- Module 9: Derived Tables (SQL Derived Table + PDT Intro)3
- Module 10: Reusable LookML Patterns (Write Less, Scale More)3
- Module 11: Building Dashboards (Not Just Pretty Tiles)4
- 11.1Looks vs Dashboards vs TilesCopyCopyCopyCopyCopyCopyCopyCopy
- 11.2Dashboard filters (field filters, filter-only fields)CopyCopyCopyCopyCopyCopyCopyCopy
- 11.3Cross-filtering, drill-down workflowCopyCopyCopyCopyCopyCopyCopyCopy
- 11.4Layout + storytelling: what stakeholders expectCopyCopyCopyCopyCopyCopyCopyCopy
- Module 12: Governance + Metric Definitions (Single Source of Truth)4
- 12.1Defining “Revenue”, “Active Users”, “Conversion” properlyCopyCopyCopyCopyCopyCopyCopyCopy
- 12.2Avoiding duplicate metrics across teamsCopyCopyCopyCopyCopyCopyCopyCopy
- 12.3Naming/label rules and documentation in LookMLCopyCopyCopyCopyCopyCopyCopyCopy
- 12.4Content governance: spaces, folders, accessCopyCopyCopyCopyCopyCopyCopyCopy
- Module 13: Access Control (Roles, Groups, Row-Level Control)4
- 13.1Roles & groups overviewCopyCopyCopyCopyCopyCopyCopyCopy
- 13.2Model access vs content accessCopyCopyCopyCopyCopyCopyCopyCopy
- 13.3Row-level security concepts (user attributes + access_filter)CopyCopyCopyCopyCopyCopyCopyCopy
- 13.4Safe patterns for region/team-based data accessCopyCopyCopyCopyCopyCopyCopyCopy
- Module 14: Performance + QA (Make It Reliable)4
- 14.1Query performance basics: what affects runtimeCopyCopyCopyCopyCopyCopyCopyCopy
- 14.2Caching behavior overviewCopyCopyCopyCopyCopyCopyCopyCopy
- 14.3Common modeling mistakes that slow queriesCopyCopyCopyCopyCopyCopyCopyCopy
- 14.4QA checklist: validation, content checks, testing totalsCopyCopyCopyCopyCopyCopyCopyCopy
- Module 15: Capstone Project (End-to-End Delivery)0