Looker and LookML in Practice: Model Once, Explore Everywhere
Signature Course No. 449 — A Signature AI Socratic Coaching Course.
No experience needed — your coach starts where you are.
A New Kind of Learning
Socratic coaching, delivered by an agentic AI coach.
Not a course you watch. An AI coach you work with.
The Lighthouse Coach begins by discovering how you think about the subject, teaches what is missing, and gives you realistic practice before asking you to prove that you can use it. You may test out of concepts you already understand, while capstones turn the learning into a practical plan, decision, conversation, or other real-world result.
The curriculum is deliberately authored; the AI delivers it through coaching. It is not an AI randomly generating lessons.
A coach that teaches by asking — not by lecturing
The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's Looker and LookML in Practice: Model Once, Explore Everywhere course, in the Personal Effectiveness & Well-Being category. It does not play videos at you. It holds a conversation: it asks you a question, listens to your answer, names the misconception it hears, affirms what you got right, and asks the next question — the way a great coach works in the room.
A number that is defined in five places is defined in no place. That is this course's premise. Every company of any size eventually has the same meeting: finance projects one revenue figure, marketing's dashboard shows another, and the room discovers that nobody is lying and nobody agrees — because "revenue" was defined three times, in three places. The data was never the problem. The definitions were never governed. Looker's wager is the semantic layer: define each field, each measure, and each join once, in LookML — and let every explore, dashboard, and answer inherit those definitions instead of reinventing them.
It starts with the model. You will build the model on Vornwick Provisions, a fictional meal-kit and grocery delivery company whose third-quarter revenue appears in three places with three values — $3,709,440 net of refunds on finance's board dashboard, $4,032,000 gross on the growth team's, and a third figure, mixed region by region, on a manager's saved report. Nobody made an arithmetic error. The model underneath never settled which number the word "revenue" names — so this course settles it in the model, concept by concept, and keeps it settled.
It works in two movements. First, Module 1 — The Model: One Definition, Held Once — work through Concepts 1–9, finishing with The One-Number Audit; then, Module 2 — Governing the Model at Scale — work through Concepts 10–18, finishing with The Governed Expansion.
Both capstones produce real artifacts — a Definition Audit of Vornwick's model: every competing definition of revenue, customers, and orders inventoried from its rules rather than its label, the headline figure traced hop by hop, the structural defects proven with reconciliations, and rulings issued on names and fields; and a Governed Expansion Plan that grows the same estate in three directions at once — a wholesale division modeled by reuse, a partner doorway sized to the grocery chains' decisions and rights, and "active subscriber" redefined from 60 days to 45, in the open, with the whole expansion tested before launch.
The honesty standard is part of the course. This course teaches Looker and LookML at the level of workflow and modeling judgment — no click-paths, no menu sequences, no claims about what any particular version shows on any particular screen, because interfaces change between releases and the judgments here are the ones that survive the next release. Every figure in the course that is presented as computed is computed from figures stated in the same passage, and you can check each one with a pencil.
The course is self-paced and always on — roughly 30 minutes per concept, about 9 hours in full, taken in as many sittings as you like. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies. Learners who already know the material can test out concept by concept.
Looker and LookML in Practice: Model Once, Explore Everywhere is part of The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning delivers.
Course Facts
One full concept, coached end to end — free: verify your email and we’ll send you a link to start.
Already enrolled? Enter the course →
Diagnose → Learn & Practice → Prove → Capstone
Every learner moves through the same discipline a Cognosco instructor would insist on in the room.
Diagnose
The Coach starts where the course starts: with your most-quoted number. How many distinct places declare what it means — and could you list them all without searching? When two dashboards disagreed most recently, where was the disagreement resolved: in the shared model, or in one of the dashboards? And who, by name, can approve a change to what your headline metric means — and where would that change be recorded? Every concept opens with three questions that locate where you actually stand, and your answers shape how deeply the Coach works the concept with you. Everyone begins with Module 1 — no skipping the foundations you only think you have.
Learn & Practice
Work each concept in conversation with the Coach — spoken or written — then practice it against realistic situations until it holds up.
Prove
Every concept ends in proof: answer the check cold and demonstrate the skill. Know it already? Test out and take credit immediately.
Capstone
Finish with two capstones — The One-Number Audit for Module 1 and The Governed Expansion for Module 2 — that pull the whole course together, and earn the certificate.
What You'll Learn
Model once, explore everywhere. Every skill in this course is the same discipline at a different depth: hold each definition once, in the model, where it can be read, argued with, and tested — and let every surface inherit it, so a company argues from the same figures because there was only ever one figure to argue from.
Module 1 builds the model. The Semantic Layer; Views; Dimensions; Measures; Explores; Joins and Fanout; Grain; Naming and Description; and Reuse Without Forking — the semantic layer itself, honest views, dimensions that cut without distorting, measures with their rules attached, doorways admitted on purpose, fanout diagnosed and defended against, grain declared, labels treated as promises, and definitions reused without forking.
Module 2 governs it at scale. Derived Tables; Access in the Model; Content Governance; Changing a Definition in the Open; Performance Judgment; Testing the Model; Version Control and Review; Audiences and Model Sets; and The Modeler's Standard — precomputation bought at a stated price, who-sees-what written where it belongs, dashboards governed as publications, amendments made in the open, explores that answer at the speed of decisions, proof by reconciliation, reviewed change, doorways sized to their audiences, and the standard the modeler signs.
And it holds its boundary throughout. This course begins where transformation work ends: the warehouse models exist — how they are built and shipped is taught in the neighboring analytics-engineering course on this shelf — and the question here is how their meaning is declared, governed, and explored inside Looker. Other platforms solve neighboring problems in neighboring ways and are not taught here; the discipline — one governed semantic model, defined once in LookML, explored everywhere — is taught on its own terms.
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.
Everything in the course
- All 18 concepts of Looker and LookML in Practice: Model Once, Explore Everywhere, in 2 modules
- A starting-point check first — the Coach finds where you actually stand before teaching
- Learn, Practice, Prove for every concept — no passive video watching
- A test-out on every concept: prove you know it and move on
- The Voice Coach: talk with the Coach out loud — it speaks, listens, and replies
- A personal Learner Record of your work across the course
- Two capstone exercises: The One-Number Audit and The Governed Expansion
- A printable session summary whenever you pause
- The Lighthouse Coach completion certificate (Signature Series)
- Your progress is saved as you go — stop anytime, resume where you left off
Built for the people who answer for the numbers
Analytics engineers and LookML developers — who own a Looker project and need the full modeling discipline, not just the next feature; and data analysts moving into modeling who build explores and dashboards today and want to own the definitions underneath them.
BI and reporting leads, and data team leads and analytics managers — who answer for the numbers a company runs on, set conventions, review model changes, and decide who may see what, defined where, and who need a standard they can hold every model and dashboard to.
Analysts arriving from another platform — who know reporting tools well and need this platform's central idea, the governed semantic model, as a discipline rather than a feature list. This course assumes working SQL literacy — you can read a join and an aggregation and say what each returns — and general familiarity with what a business dashboard is for. It assumes no prior LookML.
Prefer to learn live and in person? The same material anchors Cognosco's one-day programs — browse the in-person catalog.
Start with The Semantic Layer
$195 — introductory price. One payment. No subscription, no password to manage.
Here is exactly what happens when you enroll:
- Pay securely with Stripe — you are taken straight into the course
- Create your learner profile and begin the Module 1 starting-point check
- Save the access key you are given — it restores your enrollment on any device
- Learn at your pace; your progress is stored in your browser on your device
For the full voice experience, use Chrome and allow the microphone when asked. Typing your answers works everywhere, all the time. Questions before you enroll? Email hello@cognoscolearning.com.
Before you enroll
What is a Socratic coaching session?
A conversation, not a video. Your coach asks a question; you answer — out loud by voice, or by typing — and the coach responds to what you said: naming the misconception it hears, affirming what you got right, and asking the next question. You advance only when you have mastered each concept, so a finished course means the learning held.
How long does it take — and how long do I have?
About 30 minutes per concept. Learn in sittings of any length; your progress is saved as you go. You have a full year from purchase to finish, and you can revisit and retake within that year.
What does the certificate verify?
That you completed every concept and both capstones of this course. Anyone can confirm a Cognosco certificate online — enter its certificate ID on our verification page.
What if it isn't for me — what are the refunds?
If you have not started, cancel for a full refund within seven days of purchase. Once you have started, there is no cash refund — stop before finishing and we credit the full amount you paid toward any other course in the library (credit valid one year from your original purchase). Once you complete the course, no refund or credit applies.
More Signature Courses are coming
Looker and LookML in Practice: Model Once, Explore Everywhere is Signature Course No. 449. Leave your email and we'll send you news of future Signature Courses and Lighthouse updates as they are announced — nothing else.