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

Model Performance and Quality Analysis en hu

This session introduces the tools and techniques to analyse Power BI models and identify performance and quality problems.

Tools introduced:
Power BI Desktop: Performance Analyzer, Dax Query View
Dax Studio: Query Traces, Vertipaq Analyzer
Tabular Editor: Best Practice Analyzer, Creating model documentation
SQL Server Profiler
Azure Log Analytics
Power BI Realistic Load Testing Tool

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).

Model Performance and Quality Analysis en hu

This session introduces the tools and techniques to analyse Power BI models and identify performance and quality problems.

Tools introduced:
Power BI Desktop: Performance Analyzer, Dax Query View
Dax Studio: Query Traces, Vertipaq Analyzer
Tabular Editor: Best Practice Analyzer, Creating model documentation
SQL Server Profiler
Azure Log Analytics
Power BI Realistic Load Testing Tool

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).

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

Excel remains the most widely used data analytics tool globally. Organizations leveraging Power BI can transform Excel into an even more powerful analytics platform.
This session explores comprehensive methods to integrate Excel with Power BI, dramatically increasing your data's value:

Learning various approaches to access the Power BI Semantic Layer directly from Excel
Designing Semantic Layer best practices optimized for Excel users, including Detail Rows Expression and Is Available in MDX
Implementing dynamic charting in Excel through MDX
Exploring hidden Excel settings that enhance usability
Deploying Organizational Data Types to extend data access to non-analysts

While beginners will find this session accessible, advanced users will discover valuable techniques to enhance their existing workflows.

This can be delivered as a speak or a workshop (2/4 hrs).

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

Excel remains the most widely used data analytics tool globally. Organizations leveraging Power BI can transform Excel into an even more powerful analytics platform.
This session explores comprehensive methods to integrate Excel with Power BI, dramatically increasing your data's value:

Learning various approaches to access the Power BI Semantic Layer directly from Excel
Designing Semantic Layer best practices optimized for Excel users, including Detail Rows Expression and Is Available in MDX
Implementing dynamic charting in Excel through MDX
Exploring hidden Excel settings that enhance usability
Deploying Organizational Data Types to extend data access to non-analysts

While beginners will find this session accessible, advanced users will discover valuable techniques to enhance their existing workflows.

This can be delivered as a speak or a workshop (2/4 hrs).

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.

Expand your reach with Organizational Data Types en

Learn how to add value to non-Power BI users by enabling them access to your master data through Excel. This technique can quadruple your reach and could change the entire organization data culture.

Build Better Reports Faster: Start writing PBIR Code with GitHub Copilot Today en hu

Transform your development approach! Join Mihaly Kavasi, Group Manager Delivery Lead and Trainer at Avanade, and revolutionize how you build Power BI reports through code.

Attend this session to:
*Navigate the new PBIR report structure confidently and accelerate your workflow.
*Leverage GitHub Co-Pilot to automate tedious code creation tasks.
*Understand current implementation challenges

Session contains live demo of code creation with CoPilot and report development by code

As Power BI shifts toward code-first development, secure your competitive advantage by learning techniques that slash development time and enhance report quality.

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 a semantic layer that empowers both human users and AI assistants to extract maximum value from your data assets.

What you'll learn:
*Implement the optimal division of responsibilities between IT/BI and Business teams
*Best practices in model design that accelerate user adoption
- Optimal semantic layer structure for usability and performance
- How to utilize naming conventions and descriptions to be AI optimized
- Less well-known features that support report creators
*Apply performance optimization techniques that deliver faster insights
*Configure your semantic layer to be fully Copilot-compatible
*Tools and techniques for code-first semantic layer design.

You will learn how to build a semantic layer that slashes report development time, reduces IT bottlenecks, and enables true self-service analytics across your organization.

Why attend:
Walk away with immediately applicable strategies to future-proof your data architecture and position your team for success in the AI-augmented analytics era

This session can be delivered as a 30-minute talk or 2-4 hours 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 a semantic layer that empowers both human users and AI assistants to extract maximum value from your data assets.

What you'll learn:
*Implement the optimal division of responsibilities between IT/BI and Business teams
*Best practices in model design that accelerate user adoption
- Optimal semantic layer structure for usability and performance
- How to utilize naming conventions and descriptions to be AI optimized
- Less well-known features that support report creators
*Apply performance optimization techniques that deliver faster insights
*Configure your semantic layer to be fully Copilot-compatible
*Tools and techniques for code-first semantic layer design.

You will learn how to build a semantic layer that slashes report development time, reduces IT bottlenecks, and enables true self-service analytics across your organization.

Why attend:
Walk away with immediately applicable strategies to future-proof your data architecture and position your team for success in the AI-augmented analytics era

This session can be delivered as a 30-minute talk or 2-4 hours workshop

Build Better Reports Faster: Start writing PBIR Code with GitHub Copilot Today en hu

Transform your development approach! Join Mihaly Kavasi, Group Manager Delivery Lead and Trainer at Avanade, and revolutionize how you build Power BI reports through code.

Attend this session to:
*Navigate the new PBIR report structure confidently and accelerate your workflow.
*Leverage GitHub Co-Pilot to automate tedious code creation tasks.
*Understand current implementation challenges

Session contains live demo of code creation with CoPilot and report development by code

As Power BI shifts toward code-first development, secure your competitive advantage by learning techniques that slash development time and enhance report quality.

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