Personal Effectiveness & Well-Being

Looker and LookML in Practice: Model Once, Explore Everywhere

Instructor: Cognosco Learning · Duration: Full Day, 9:00 AM–5:00 PM · In-Person
One-day, in-person course — $795 per person · 3–4 seats save 10% · 5+ seats save 20%

Looker and LookML in Practice: Model Once, Explore Everywhere

About This Course

Model once, explore everywhere: build a governed LookML semantic model — honest views, measures with their rules attached, explores as governed doorways, joins that cannot fan out silently — then govern it at scale, with access in the model, definitions changed in the open, testing, and review. One definition per term, traceable to its source.

What You'll Learn

What you will learn

  • State what the semantic layer is and why a definition held once, in the model, outranks every copy of it held anywhere else.
  • Design views that describe one table honestly — every field accounted for, nothing exposed that the table cannot support.
  • Choose dimensions with judgment: types, time handling, and groupings that cut a measure without distorting it.
  • Define measures whose rules travel with them — counts, sums, averages, and distinct counts that survive contact with real questions.
  • Build explores as governed doorways: a base view, declared joins, and nothing reachable that was not deliberately admitted.
  • Diagnose fanout — the join pattern that multiplies rows and silently inflates totals — and choose the modeling defense that fits.
  • Declare and defend the grain of every view, and refuse questions a view's grain cannot answer.
  • Name and describe fields so a user who has never met you can trust what a label promises.
  • Reuse model code across teams and audiences without forking definitions into competing copies.
  • Judge derived tables: when precomputation earns its storage, refresh, and staleness costs, and when it is an expensive hiding place.
  • Write access into the model — filters, attributes, and grants — so who-sees-what is a modeled decision, not an accident of sharing.
  • Govern content built on the model: which dashboards are certified, which are drafts, and what happens to each when a definition changes.
  • Change a published definition without breaking trust: version the change, state its effect on history, and tell everyone who relied on the old one.
  • Make performance judgments about explores — which joins and fields cost answers their speed, and what to simplify first.
  • Test a model the way an auditor tests books: reconcile to source, probe the edges, and refuse to ship a number you cannot trace.
  • Work on the model the way software ships: branches, reviewed changes, and a history that explains itself.
  • Shape models for audiences — executives, operators, external partners — so each sees a doorway sized to its decisions and its rights.
  • Hold the modeler's standard: own every definition you publish, and be able to say, for any number the model produces, exactly what it means and how far to trust it.

What's Included

  • A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor
  • A printed participant manual for every attendee
  • All course materials, exercises, and practice scenarios
  • Guided practice and small-group work throughout the day
  • Group savings built in: 3–4 seats save 10%, 5+ seats save 20%

How the Day Runs

1

9:00 AM – 5:00 PM

A full day in the room — seven learning hours — led by a Cognosco Learning instructor.

2

Practice, not lectures

Guided practice and small-group work throughout the day, with all course materials, exercises, and practice scenarios provided.

3

Take it with you

A printed participant manual for every attendee — yours to keep, and to keep working from after the day.

Who It's For

Individuals who want to work, and live, with more focus, resilience, and intention.

Your session’s location, date, and start time are set by Cognosco and confirmed with you after registration — the scheduling is handled for you.

Looking to bring learning to a whole team? See corporate learning →

Enroll in This Course

In-person · Full day · Taught by Cognosco Learning instructors

Number of seats1

Add 2 more seats to save 10%.

$795.00 × 1 seat$795.00
Total$795.00

No account required · Secure checkout

What happens next

  1. Choose your seats and enroll — no account required.
  2. Cognosco sets your session location, date, and start time, and confirms them with you.
  3. Check out securely; your confirmation is sent immediately.
Also Available · The Lighthouse Coach

Prefer to learn at your own pace?

Looker and LookML in Practice: Model Once, Explore Everywhere is also a Signature AI Socratic Coaching Course — the same material, taught one learner at a time by the Lighthouse Coach, whenever it suits you. Introductory price $195.

See the AI Course — $195 →Try a Free Preview

Finish the AI course and you earn a completion certificate that anyone can verify online.

Questions

Before You Enroll

What's included in a course day?

A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor, a printed participant manual for every attendee, and all course materials and exercises. One flat rate per person — no proposal required.

How are the location, date, and start time set?

They are set by Cognosco. When you register, we confirm your session’s location, date, and start time with you directly — you don’t need to propose or hold dates on your own.

How do the group savings work?

Automatically, at registration: 3–4 seats save 10%, and 5 or more seats save 20% off the $795 per-person rate. The discount is applied in the seat selector before you check out — no code, no negotiation.

Can we bring learning to a large group or a whole department?

Yes. Online registration handles up to 50 seats per course. For a larger group, a multi-course plan, or sessions across several locations, email us at hello@cognoscolearning.com and we’ll plan it with you.

What if we need to change our date?

Email us at hello@cognoscolearning.com as soon as you know — we’ll work with you to move your session to a date that works.