Skip to main content
A workshop of short, hands-on modules for analytics engineers and BI admins moving from Tableau, Looker, or Power BI toward TextQL — whether that’s a full migration or long-term coexistence. The framing throughout: migrate questions, not artifacts. Your BI tool was the right tool for its era; this is the playbook for what carries forward, what translates, and what gets replaced by something better than a dashboard. Total time: about 2.5 hours.

​
Who this is for

  • Analytics engineers who own LookML models, Tableau calcs, or Power BI measures- BI admins responsible for a dashboard estate (and its license bill)- Data leads planning a migration or a deliberate coexistence- Anyone who has counted their dashboards and felt tired

​
What you’ll be able to do

After moduleYou can…
0Inventory the estate: what exists, what’s actually used, what the semantic layer contains
1Translate LookML / calcs / measures into governed ontology metrics, conflicts surfaced
2Rebuild the flagship dashboard conversationally, with side-by-side discipline
3Prove parity with golden queries — and triage every mismatch to its cause
4Say honestly what doesn’t migrate, and what replaces dashboards entirely
5Run coexistence: usage-based deprecation, BI tool as a data source during transition
6Measure adoption weekly with a playbook

​
Workshop modules

ModuleTime
0 · Inventory the Estate00_INVENTORY.md20 min
1 · Translate the Semantic Layer01_TRANSLATE_SEMANTIC_LAYER.md25 min
2 · Rebuild the Flagship Dashboard02_REBUILD_FLAGSHIP.md25 min
3 · Parity Testing03_PARITY_TESTING.md20 min
4 · What Doesn’t Migrate — And What Replaces It04_WHAT_DOESNT_MIGRATE.md15 min
5 · Coexistence & Cutover05_COEXISTENCE_CUTOVER.md20 min
6 · Measure Adoption06_MEASURE_ADOPTION.md15 min

​
How to use this workshop

  • Prerequisites: your warehouse connected to TextQL (see Connect Your Data), and — strongly recommended — your BI tool connected too (Tableau and Power BI connectors exist; they make coexistence real rather than aspirational).- Bring exports: dashboard/workbook lists, usage stats from your BI tool’s admin views, and your semantic-layer source (LookML files, workbook calc exports, measure definitions). Modules 0–1 work on these as uploaded files.- Work in order — the inventory’s usage data drives every later decision, and parity testing (Module 3) gates any cutover.- Swap [bracketed] placeholders for your own tool names, dashboard names, and metrics.
T-minus-1-day pre-flight: run the workshop’s key prompts end-to-end in the session workspace — confirm logins, connectors, and the features this workshop touches are enabled for every attendee; have a fallback demo workspace ready in case a customer connector fails live. Pacing: when a long prompt is running (2–4 min), fire it first, then discuss the concept while Ana works — never watch a spinner in silence. If behind schedule, cut sections marked optional, never the checkpoints. Group sessions: attendees drive, you narrate; collect every miss or wrong answer in a shared doc — that list is the ontology backlog. With 10+ attendees on one warehouse, stagger the heavy prompts.
🤖 Prefer to have Ana run this workshop? Open a thread with your data connected and paste the prompt below — Ana walks you through it on your own data, one step at a time. You run each prompt; she coaches. (Air-gapped / VPC tenants where Ana can’t reach the web: download ana-runner.md and paste its module list instead.)
Run with Ana
▶ Open in Ana — prompt loaded Ana fetches the steps from the link — no copy/paste of the workshop needed. (Air-gapped / VPC tenants where Ana can’t reach the web: paste the module list from this workshop’s ana-runner.md instead.)