Masterclasses

Focused, practitioner-led cohorts with habits for quality, governance, and reproducibility. Pick your track below.

Excel Mastery (Cohort)

A structured cohort that takes participants from the fundamentals of formulas through pivot tables, data cleaning, and dashboard creation. We emphasize not only technical proficiency but also the habits of quality assurance that prevent errors and ensure reliability in business reporting. By the end, you’ll know how to design workbooks that scale, communicate insights clearly, and stand up to real-world use in finance, operations, and decision support.

Formulas Pivot Tables Power Query Dashboards QA & Governance

Outcomes

  • Reliable models (XLOOKUP / INDEX-MATCH, SUMIFS, named ranges).
  • Repeatable cleaning via Power Query; lineage notes.
  • Dashboards with KPIs, slicers, and refresh discipline.
  • QA pack: test tabs, checks, and change-log.

Cadence

  • 6 weeks · 2×/week · 90 min live + labs.
  • Capstone (finance ops / CRM / inventory).
  • Badge with verifier link.
Apply Full syllabus
Excel dashboards and QA checks

SQL for Analysts

This workshop builds a strong foundation in SQL for data professionals. Starting from basic SELECTs and filtering, we progress through joins, aggregations, subqueries, and window functions. Participants will learn how to translate analytical questions into efficient, reusable SQL patterns, and practice performance tuning for large datasets. The course is hands-on, focusing on problem-solving with PostgreSQL and practical scenarios analysts face in reporting, product analytics, and BI pipelines.

PostgreSQL Joins Windows CTEs Performance

Outcomes

  • Robust patterns (cohorts, funnels, sessionization).
  • Correctness + speed: EXPLAIN (ANALYZE, BUFFERS).
  • Naming, comments, QA habits; change control.

Format

  • 2 days (or 4× half-days) with labs.
  • Sample datasets; graded exercises.
  • Optional take-home tuning pack.
Enroll Full syllabus
SQL query plans and window functions

Analytics for Decisions

A practitioner-focused workshop on using analytics to drive impact rather than just generate charts. We cover KPI design linked to strategy, how to read and interpret experiments correctly, and the pitfalls of “dashboard theater” where visuals replace evidence. Participants will work through case studies on product growth, program evaluation, and business operations, leaving with frameworks to design metrics that matter and to communicate findings persuasively to decision-makers.

KPI Design Experimentation Decision Science Causal Inference Communication

Outcomes

  • Metric trees, target setting, guardrails.
  • AB/DID designs; power & MDE basics.
  • Decision memos that trigger action.

Logistics

  • 4 Saturdays · 3 hours each.
  • Hybrid delivery (in-person + online).
  • Templates: metric tree, experiment kit, memo.
Register Full syllabus
Metric tree and experiment readout
Back to top