PostgreSQL + dbt
Warehouse modeling lab
Star schema design, slowly changing dimensions, and integrity checks you can defend in a design review.
6 wk · Hybrid lab $640
Lab bulletin
Monthly memo on dataset rotations, mentor office hours, and when we intentionally break a pipeline for class.
380+
Documented query critiques logged since 2019
52
Distinct warehouse diagrams archived for reuse
18
Cohort-specific rollback scripts versioned
9.1 / 10
Internal mentor rubric average (last eight intakes)
112
Office-hour threads answered within 36h median
380+ reviewed SQL diffs in mentor sessions
We teach analytics for people who ship evidence, not decks full of fog. English instruction with explicit notes for VN cohorts sharing partial overlap with Americas hours.
Open course slate
Teams from logistics, fintech, and education ops have used our memo format in prod reviews.
Data analytics & SQL, taught as craft
Cohorts rehearse failures, write lineage notes, and leave with rubrics instead of vague promises. Subtopic depth: Data Analytics and SQL.
- Live and hybrid labs with pinned datasets
- Portfolio checkpoints tied to warehouse and reporting tracks
- Transparent calendars—no hidden overlap costs
Inside each cohort sprint
You get facilitator scripts, anonymized data contracts, and critique slots where mentors mark up your SQL as if it were going to production Monday. We publish what is not included: airfare, software licenses billed by vendors, and 1:1 staffing outside scheduled windows.
Course explorer
Filter fourteen open tracks by level, tool stack, duration, delivery mode, and portfolio requirement.
Level Delivery Portfolio Weeks
No rows match—widen filters or clear search.
Quick modality contrast
| Signal | Live studio | Hybrid lab | Async + hours |
|---|---|---|---|
| Mentor presence | High, fixed windows | Split blocks + labs | Threaded, batched replies |
| Dataset drama | Resolved in-room | Coordinated releases | Documented self-serve |
| Best when | You learn aloud | You want hands + reflection | Time zones bite |
From raw tables to stakeholder-ready briefs
01 · Freeze the question
We refuse pretty charts until the grain sentence is written in SQL comments.
02 · Stress the pipeline
Mentors inject realistic breaks so triage language becomes muscle memory.
03 · Ship the memo
Every sprint ends with a brief someone outside analytics could follow without you in the room.
04 · Archive artifacts
Rubrics, rollback snippets, and critique notes land in a shared vault for your team.
05 · Retro in public
We log what felt rushed—no toxic positivity, just adjustments for the next intake.
Teams that borrowed our memo formats
Mosaic Freight
Delta Ledger
Northline Health
Pulseboard
Harbor Tuition
Lantern Grid
Signals from recent desks
“The Warehouse modeling lab forced me to write why each surrogate key existed. I still open that memo before architecture reviews.”
Windowing intensive was dense; worth it for the sessionization drills.
Metric layer studio surfaced three conflicting “active user” definitions we had politely ignored. Uncomfortable week, healthier dashboards.
Experiment readouts module was almost too honest about peeking risks—which I now appreciate. Slides landed quieter but stuck.
Staging pipelines lab expects you to narrate failures out loud. My team adopted the runbook format even for internal-only DAGs.
Geospatial lite was the first time H3 clicked; still wish we had one more office hour on CRS edge cases.
Field notes
Browse essaysoperations
Cohort checklists we reuse before every SQL lab opens
A plain-language checklist for mentors covering datasets, broken pipe drills, and rollback scripts.
governance
When metric dictionaries stall (and how we unblock them)
Three patterns that freeze metric work, plus facilitation prompts that get finance and product speaking the same sentence.
teaching
Notebook etiquette that keeps hybrid cohorts readable
Small formatting rules that make peer review pleasant when half the class is async.
Desk FAQs
Do you teach in Vietnamese?
Instruction is English-first; we provide bilingual glossaries for SQL keywords and finance terms.
What is the honest time load?
Plan six to nine focused hours weekly for practitioner tracks; async tracks batch heavier weekends.
Can we invoice in USD?
Yes—pricing lists USD totals; installments must match the summed schedule in your agreement.
Where do mentors sit?
Core mentors operate from our Barquisimeto studio and remote pods across Americas hours.
Download the syllabus pack
PDF outlines modules, tooling, and what we intentionally leave out. If you need a live walkthrough, schedule a call after you skim—it keeps conversations grounded.