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

Increase your audience - Excel Integration in Power BI hu en

Excel is the most used data analytics tool in the world. If your organization uses Power BI you can supercharge Excel to became the ultimate tool for data analytics.
In this session we will get familiar with all the way you can use Excel with Power BI and how that can increase the value of data tenfold.

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

Increase your audience - Excel Integration in Power BI hu en

Excel is the most used data analytics tool in the world. If your organization uses Power BI you can supercharge Excel to became the ultimate tool for data analytics.
In this session we will get familiar with all the way you can use Excel with Power BI and how that can increase the value of data tenfold.

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.

PBIR: Report Development by Code en

Current state of working with the new PBIR format. Game changer is enterprise report development in its early stages. Features, possibilities, current limitations.