# Gap Analysis — Data / Analytics

These 5 questions CANNOT be answered from your Jira export, Confluence extract, and Snowflake export alone. They require access to systems without MCP connectors.

1. **What does the full transaction history show for the merchants under investigation?**
   This requires: Snowflake (direct query access) — no MCP connector available.
   Today you would: log into Snowflake directly and look it up manually.

2. **What does your Data / Analytics dashboard show for this week's KPIs?**
   This requires: Tableau (dashboard admin) — no MCP connector available.
   Today you would: log into Tableau directly and look it up manually.

3. **What is the current status in Airbyte for your open cases this week?**
   This requires: Airbyte (connector config) — no MCP connector available.
   Today you would: log into Airbyte directly and look it up manually.

4. **What is the current status in DBT for your open cases this week?**
   This requires: DBT (model lineage) — no MCP connector available.
   Today you would: log into DBT directly and look it up manually.

5. **What would a complete view look like?**
   Combining data from Snowflake, Tableau, Airbyte, DBT, plus your existing 3 sources, would give you a 360° view. Which of these gaps causes the most pain in your daily work?

---

**Reflection:** The value of MCP is that it eliminates manual lookups for connected systems. The gap systems listed above represent the manual work that remains. Which one would save you the most time if connected?