Democratize data - Self-Service model design in Power BI en hu

One of the core promises of Power BI was democratizing access to data. For this to truly happen we need to build a data model that can be understood and used easily.
In this session we will look through all the features and best practices that will help any self-service user to easily use the datasets that was built for them.

Content is designed for experienced Power BI developers and contains free tools that anyone can use immediately.
This can be delivered as a speak or a workshop (2/4 hrs).

Democratize data - Self-Service model design in Power BI en hu

One of the core promises of Power BI was democratizing access to data. For this to truly happen we need to build a data model that can be understood and used easily.
In this session we will look through all the features and best practices that will help any self-service user to easily use the datasets that was built for them.

Content is designed for experienced Power BI developers and contains free tools that anyone can use immediately.
This can be delivered as a speak or a workshop (2/4 hrs).

Optimize data preparation with Power Query Best Practices en hu

Data preparation is a fundamental part of data modelling. In this session we will explore best practices to make your data transformations:

- robust = fewer refresh failures
- leaner = smaller dataset size
- dynamic = automatically adjust to data changes
- cleaner = better data quality
- structured = easier to understand and debug

This is a hands-on session where you can follow along the step on a prepared dataset.

Best if you have a basic understand of the Power BI query editor

Optimize data preparation with Power Query Best Practices en hu

Data preparation is a fundamental part of data modelling. In this session we will explore best practices to make your data transformations:

- robust = fewer refresh failures
- leaner = smaller dataset size
- dynamic = automatically adjust to data changes
- cleaner = better data quality
- structured = easier to understand and debug

This is a hands-on session where you can follow along the step on a prepared dataset.

Best if you have a basic understand of the Power BI query editor

Optimize Power BI Models: Master Tools & Techniques for Peak Performance en hu

Slow reports kill user adoption. Discover the systematic approach to diagnosing and eliminating Power BI performance bottlenecks using a comprehensive toolkit of expert-grade, free tools.

What you'll master:
• Identify visual-level bottlenecks using Performance Analyzer to pinpoint exactly where reports slow down
• Optimize DAX queries with DAX Studio and DAX Query View, achieving 5-10x speed improvements
• Automate model quality checks using Tabular Editor for consistent, maintainable implementations
• Monitor production workloads with SQL Server Profiler and Azure Log Analytics for proactive issue detection
• Stress-test at scale using the Power BI Load Testing Tool before production deployment
• Apply proven optimization patterns for common performance killers (relationships, calculations, visuals)

You'll leave with a clear, actionable framework for analyzing and optimizing any Power BI model, plus downloadable tools and scripts you can use immediately.

Target Audience: Experienced Power BI developers and data modelers
Format: 60-minute session or 2-4 hour hands-on workshop
Takeaways: Optimization checklist, tool configuration templates, sample PBIX files
Prerequisites: Intermediate Power BI development experience
Tools: All tools featured are free and immediately accessible

Optimize Power BI Models: Master Tools & Techniques for Peak Performance en hu

Slow reports kill user adoption. Discover the systematic approach to diagnosing and eliminating Power BI performance bottlenecks using a comprehensive toolkit of expert-grade, free tools.

What you'll master:
• Identify visual-level bottlenecks using Performance Analyzer to pinpoint exactly where reports slow down
• Optimize DAX queries with DAX Studio and DAX Query View, achieving 5-10x speed improvements
• Automate model quality checks using Tabular Editor for consistent, maintainable implementations
• Monitor production workloads with SQL Server Profiler and Azure Log Analytics for proactive issue detection
• Stress-test at scale using the Power BI Load Testing Tool before production deployment
• Apply proven optimization patterns for common performance killers (relationships, calculations, visuals)

You'll leave with a clear, actionable framework for analyzing and optimizing any Power BI model, plus downloadable tools and scripts you can use immediately.

Target Audience: Experienced Power BI developers and data modelers
Format: 60-minute session or 2-4 hour hands-on workshop
Takeaways: Optimization checklist, tool configuration templates, sample PBIX files
Prerequisites: Intermediate Power BI development experience
Tools: All tools featured are free and immediately accessible

Excel + Power BI: Your Gateway to Organization-Wide Data Adoption hu en

Excel remains the world's most widely used analytics tool, yet most organizations underutilize its true potential. Discover how connecting Excel to Power BI semantic layers transforms everyday Excel users into self-service analysts—eliminating IT bottlenecks and accelerating data-driven decision making across your entire organization.

What you'll master:
• Access Power BI semantic layers directly from Excel using multiple connection methods optimized for different user personas
• Design semantic layer best practices specifically for Excel users, including Detail Rows Expression and MDX availability settings
• Build dynamic, interactive dashboards in Excel using MDX formulas that rival traditional BI visualizations
• Leverage hidden Excel settings that dramatically improve usability and performance for connected workbooks
• Enable scalable self-service analytics where business users create their own reports without IT intervention

You'll leave with immediately applicable strategies to multiply your data's value, reduce time-to-insight from days to minutes, and empower every Excel user in your organization to become data-driven.

Target Audience: BI developers, data architects, analytics leaders, and Excel power users
Format: 45-minute session or 2-4 hour hands-on workshop
Takeaways: Connection templates, semantic layer design checklist, Excel configuration guide, sample workbooks
Prerequisites: Basic understanding of Excel and Power BI fundamentals
Technologies: Power BI, Excel, Azure Analysis Services

Excel + Power BI: Your Gateway to Organization-Wide Data Adoption hu en

Excel remains the world's most widely used analytics tool, yet most organizations underutilize its true potential. Discover how connecting Excel to Power BI semantic layers transforms everyday Excel users into self-service analysts—eliminating IT bottlenecks and accelerating data-driven decision making across your entire organization.

What you'll master:
• Access Power BI semantic layers directly from Excel using multiple connection methods optimized for different user personas
• Design semantic layer best practices specifically for Excel users, including Detail Rows Expression and MDX availability settings
• Build dynamic, interactive dashboards in Excel using MDX formulas that rival traditional BI visualizations
• Leverage hidden Excel settings that dramatically improve usability and performance for connected workbooks
• Enable scalable self-service analytics where business users create their own reports without IT intervention

You'll leave with immediately applicable strategies to multiply your data's value, reduce time-to-insight from days to minutes, and empower every Excel user in your organization to become data-driven.

Target Audience: BI developers, data architects, analytics leaders, and Excel power users
Format: 45-minute session or 2-4 hour hands-on workshop
Takeaways: Connection templates, semantic layer design checklist, Excel configuration guide, sample workbooks
Prerequisites: Basic understanding of Excel and Power BI fundamentals
Technologies: Power BI, Excel, Azure Analysis Services

Advanced Excel Pivot table techniques with Power BI en

How to use Excel and Pivot tables effectively with Power Pivot, Power BI or Azure Analysis Services. What are the advanced features and possibilities. During the session we are going to explore Filters, Sets, Formulas and Pivot Charts to create a dynamic and interactive excel dashboard.

Journey to Agentic Report Development en hu

Embark on the evolution from traditional report building to autonomous development! Join Mihaly Kavasi, Group Manager Delivery Lead and Trainer at Avanade, as he guides you through the transformative landscape of AI-powered Power BI development.
In this forward-looking session, you'll discover:

How the new PBIR format unlocks unprecedented possibilities for AI-assisted development
Progressive techniques from AI code completion to fully agentic development workflows
Live demonstrations of Claude Code's agentic capabilities in report creation
Real-world implementation strategies and current challenges in autonomous development

Experience live demos showcasing the spectrum of AI assistance—from intelligent code suggestions to autonomous agentic tools that can independently architect and build complex reports.
As Power BI embraces code-first methodologies, position yourself at the forefront of this revolution. Learn how agentic development tools are reshaping the entire development lifecycle, dramatically reducing time-to-delivery while elevating report sophistication and maintainability.
This isn't just about faster coding—it's about reimagining what's possible when AI becomes your development partner.

This session can be delivered as a 45-min talk or 2-4 hour workshop.

Unlock Self-Service Analytics: Master the Human & AI-Friendly Semantic Layer en hu

Transform your organization's data strategy by mastering the essential bridge between IT and Business. This session reveals how to build semantic layers that empower both human users and AI assistants (including Copilot) to extract maximum value from your data assets.

What you'll master:
• Implement optimal responsibility division between IT/BI teams and business users for scalable self-service
• Design semantic layer structures that balance usability, performance, and AI compatibility
• Optimize naming conventions and metadata specifically for Copilot and AI assistant readability
• Leverage advanced model features (field parameters, perspectives, calculation groups) that accelerate report creation
• Apply performance optimization techniques that deliver instant insights even with billions of rows
• Master code-first semantic layer design using TMDL and modern development workflows
• Train AI Coding Agents to efficiently implement these improvements

You'll build semantic layers that slash report development time by 60%, eliminate IT bottlenecks, and position your organization for success in the AI-augmented analytics era.

Target Audience: BI developers, data architects, analytics leaders
Format: 30-minute lightning talk, 60-minute session, or 2-4 hour hands-on workshop
Takeaways: Semantic layer design checklist, naming convention guide, Copilot optimization templates
Level: Intermediate to advanced Power BI/Fabric developers
Topics Covered: Power BI, Microsoft Fabric, Azure Analysis Services, AI Coding Agents

Unlock Self-Service Analytics: Master the Human & AI-Friendly Semantic Layer en hu

Transform your organization's data strategy by mastering the essential bridge between IT and Business. This session reveals how to build semantic layers that empower both human users and AI assistants (including Copilot) to extract maximum value from your data assets.

What you'll master:
• Implement optimal responsibility division between IT/BI teams and business users for scalable self-service
• Design semantic layer structures that balance usability, performance, and AI compatibility
• Optimize naming conventions and metadata specifically for Copilot and AI assistant readability
• Leverage advanced model features (field parameters, perspectives, calculation groups) that accelerate report creation
• Apply performance optimization techniques that deliver instant insights even with billions of rows
• Master code-first semantic layer design using TMDL and modern development workflows
• Train AI Coding Agents to efficiently implement these improvements

You'll build semantic layers that slash report development time by 60%, eliminate IT bottlenecks, and position your organization for success in the AI-augmented analytics era.

Target Audience: BI developers, data architects, analytics leaders
Format: 30-minute lightning talk, 60-minute session, or 2-4 hour hands-on workshop
Takeaways: Semantic layer design checklist, naming convention guide, Copilot optimization templates
Level: Intermediate to advanced Power BI/Fabric developers
Topics Covered: Power BI, Microsoft Fabric, Azure Analysis Services, AI Coding Agents

Journey to Agentic Report Development en hu

Embark on the evolution from traditional report building to autonomous development! Join Mihaly Kavasi, Group Manager Delivery Lead and Trainer at Avanade, as he guides you through the transformative landscape of AI-powered Power BI development.
In this forward-looking session, you'll discover:

How the new PBIR format unlocks unprecedented possibilities for AI-assisted development
Progressive techniques from AI code completion to fully agentic development workflows
Live demonstrations of Claude Code's agentic capabilities in report creation
Real-world implementation strategies and current challenges in autonomous development

Experience live demos showcasing the spectrum of AI assistance—from intelligent code suggestions to autonomous agentic tools that can independently architect and build complex reports.
As Power BI embraces code-first methodologies, position yourself at the forefront of this revolution. Learn how agentic development tools are reshaping the entire development lifecycle, dramatically reducing time-to-delivery while elevating report sophistication and maintainability.
This isn't just about faster coding—it's about reimagining what's possible when AI becomes your development partner.

This session can be delivered as a 45-min talk or 2-4 hour workshop.

Agentic Development for Analytics: Subagents & Skills in Analytics Engineering en

Manual DAX optimization, brittle ETL pipelines, and repetitive data quality checks consume 80% of analytics development time. The future is agentic AI—where specialized subagents autonomously handle data pipeline automation, semantic model development, and quality monitoring while portable skills provide reusable analytics expertise. Discover how this orchestrator-worker pattern can transform data engineering and BI development.

What you'll master:
- **Architect multi-agent analytics workflows** using specialized subagents for data pipeline automation, DAX generation, and semantic model optimization
- **Leverage Power BI MCP servers** that convert natural language into DAX queries and automate Tabular Object Model (TOM) development tasks
- **Build intelligent data pipelines** where AI agents detect schema changes, adapt transformations automatically, and reduce data quality incidents by 70%
- **Create portable analytics skills** packaging DAX patterns, SQL optimization techniques, and data modeling best practices into reusable agent expertise
- **Design specialized subagents** for code review (finding 31+ issues in Power BI models), testing, documentation, and end-to-end report generation
- **Automate enterprise analytics tasks** including metadata generation, data quality monitoring, exploratory data analysis, and semantic layer maintenance

Experience live demonstrations of AI agents building Power BI reports end-to-end, generating optimized DAX measures, and autonomously maintaining data pipelines that adapt to changes without breaking.

Position yourself at the forefront of agentic analytics—where data engineers and BI developers orchestrate teams of specialized AI agents rather than writing every line of code manually.

- Target Audience: Data engineers, BI developers, analytics engineers, Power BI developers, data architects
- Format: 60-minute session or 3-hour hands-on workshop (with live demonstrations)
- Takeaways: Skill templates for analytics, Power BI MCP usage guide
- Prerequisites: Experience with Power BI/DAX, data modelling, or data preparation; basic understanding of AI coding assistants
- Technologies: Power BI, VS Code, Claude Code, Model Context Protocol (MCP)
- Level: Intermediate to advanced analytics professionals ready to move beyond manual development