> ## Documentation Index
> Fetch the complete documentation index at: https://docs.textql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Migrate from Your BI Tool

> 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…

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

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

## Workshop modules

<table><tr><th>Module</th><th>Time</th></tr><tr><td>0 · Inventory the Estate</td><td>`00_INVENTORY.md`</td><td>20 min</td></tr><tr><td>1 · Translate the Semantic Layer</td><td>`01_TRANSLATE_SEMANTIC_LAYER.md`</td><td>25 min</td></tr><tr><td>2 · Rebuild the Flagship Dashboard</td><td>`02_REBUILD_FLAGSHIP.md`</td><td>25 min</td></tr><tr><td>3 · Parity Testing</td><td>`03_PARITY_TESTING.md`</td><td>20 min</td></tr><tr><td>4 · What Doesn't Migrate — And What Replaces It</td><td>`04_WHAT_DOESNT_MIGRATE.md`</td><td>15 min</td></tr><tr><td>5 · Coexistence & Cutover</td><td>`05_COEXISTENCE_CUTOVER.md`</td><td>20 min</td></tr><tr><td>6 · Measure Adoption</td><td>`06_MEASURE_ADOPTION.md`</td><td>15 min</td></tr></table>

## How to use this workshop

* Prerequisites: your warehouse connected to TextQL (see [**Connect Your Data**](/workshops/connect-your-data/overview)), 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.

<Accordion title="For facilitators — running this as a guided session">
  **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.
</Accordion>

<Note>
  **🤖 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`](https://github.com/TextQLLabs/workshops/blob/main/bi-migration/ana-runner.md) and paste its module list instead.)*
</Note>

```text Run with Ana theme={null}
Hey Ana — facilitate the "Bi Migration" workshop with me in this thread, on the data connected here. Pull the steps from https://textqllabs.github.io/workshops/bi-migration/ and run it interactively: look at my data first (2–3 lines), then go ONE module at a time. For each module, give ME the prompt to copy and run as my next message, tell me what to look for, then wait and coach me on my result. Start with what you see, then Module 0.
```

[**▶ Open in Ana — prompt loaded**](https://app.textql.com/chat/new?prefill=Hey%20Ana%20%E2%80%94%20facilitate%20the%20%22Bi%20Migration%22%20workshop%20with%20me%20in%20this%20thread%2C%20on%20the%20data%20connected%20here.%20Pull%20the%20steps%20from%20https%3A//textqllabs.github.io/workshops/bi-migration/%20and%20run%20it%20interactively%3A%20look%20at%20my%20data%20first%20%282%E2%80%933%20lines%29%2C%20then%20go%20ONE%20module%20at%20a%20time.%20For%20each%20module%2C%20give%20ME%20the%20prompt%20to%20copy%20and%20run%20as%20my%20next%20message%2C%20tell%20me%20what%20to%20look%20for%2C%20then%20wait%20and%20coach%20me%20on%20my%20result.%20Start%20with%20what%20you%20see%2C%20then%20Module%200.)

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](https://github.com/TextQLLabs/workshops/blob/main/bi-migration/ana-runner.md) instead.)