> Markdown version of [/events/world-congress-2026-europe-virtual-stage/sessions/1498-beyond-dashboards](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1498-beyond-dashboards). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG


- **Event:** World Congress 2026 Europe - Virtual Stage

## Description

We all want to replace static dashboards with conversational AI. However, studies show that "out-of-the-box" LLMs struggle with Text-to-SQL on complex enterprise schemas. The missing link isn't a better model - it's the Semantic Layer.

In this fast-paced session, we will bridge the gap between 90s BI wisdom and the GenAI era.

We will cover:
- The Context Gap: Why zero-shot prompting fails and why locking semantics in BI is a dead end for AI agents.
- The Architecture: How modern solutions (e.g. UC Metric Views) bring semantics back to the Data Lakehouse, where they belong.
- Back to the Future: What we can learn from "ancient" tools like OBIEE/Cognos about governing complex data relationships.
- The "Semantic RAG" Pattern: How injecting your semantic model into the LLM prompt can allow the AI to understand table relationships and business logic (like a semantic layer) while retaining the flexibility to write raw SQL for ad-hoc queries.

Join this talk to learn what backend can finally make "Chat with Data" a reality.

## Speaker

### [Piotr Menclewicz](https://www.wearedevelopers.com/@piotr-menclewicz)

AI | Data Analytics | Data Science 


## Related talks at this congress

- [Conversational AI meets MS data agents to improve customer experience](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1518-conversational-ai) — Alexandra Mihai, Marina Stefan, Tomasz Kacala
- [Building an AI-Ready Content Lake: Scaling RAG and Document AI Beyond Demos](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1506-building-an-ai-ready) — Angel Borroy
- [Stop Guessing, Start Measuring: Evaluating RAG Systems with Synthetic Test Data](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1606-stop-guessing-start) — Csenge Szabo
- [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1651-why-your-ai-agent) — Tom Kaltofen, Xiaoheng Chen