22-25 April 2026

AI for Developers, Not End Users: Master Agentic BI Development Workflows

50+50 minute session for SQLBits 2026Thursday - 01 Jan 1970 - 01:00 - 01:00

TL; DR

Transform BI development with AI agents that build, test, and maintain your analytics stack autonomously. Master agentic workflows orchestrating specialized agents for data pipelines, semantic models, and Power BI reports. Part 1

Session Details

End-user AI tools answer questions. Developer AI orchestrates specialized agents that build, test, and maintain your entire analytics stack. Discover the fundamental difference between AI copilots for report consumers and agentic workflows that transform how BI developers work with Data Pipeline, Databases, Power BI Semantic Layers and Reports.

What you'll master:
- Architect multi-agent BI workflows where specialized subagents handle data transformation, semantic modeling, and report development autonomously
- Leverage MCP servers providing AI agents direct access to SQL Server schemas, Power BI workspaces, and development environments
- Build intelligent development pipelines where agents detect data model changes, generate migration scripts, update semantic layers, and maintain report consistency automatically
- Create portable skills packaging DAX patterns, SQL optimization techniques, and BI best practices into reusable agent expertise
- Design specialized subagents for code review, testing DBT pipelines, validating TMDL semantic layers, and generating PBIR reports end-to-end

Experience live demonstrations: watch AI agents build complete BI solutions from raw data through data transformations to Power BI TMDL semantic models and PBIR reports—showcasing developer-grade AI orchestration, not simple chat interfaces.

Position yourself at the forefront where BI developers orchestrate agent teams rather than manually coding every transformation, measure, and visual. Part 1

3 things you'll get out of this session

What you'll master:
- Architect multi-agent BI workflows where specialized subagents handle data transformation, semantic modeling, and report development autonomously
- Leverage MCP servers providing AI agents direct access to SQL Server schemas, Power BI workspaces, and development environments
- Build intelligent development pipelines where agents detect data model changes, generate migration scripts, update semantic layers, and maintain report consistency automatically
- Create portable skills packaging DAX patterns, SQL optimization techniques, and BI best practices into reusable agent expertise
- Design specialized subagents for code review, testing DBT pipelines, validating TMDL semantic layers, and generating PBIR reports end-to-end

Speakers

Scott Bell

myyearindata.com