The Power BI Next Step 2022 conference will host 3 concurrent full-day training sessions on September 19th.
Improve Power BI performance by optimizing DAX
When you create a Power BI report, you might hit some performance issues when you have a large amount of data, complex data models, or complex DAX expression in your measures. The first goal of this tutorial is to discover possible bottlenecks analyzing the execution of DAX calculations using tools such as DAX Studio and VertiPaq Analyzer. You see how to capture and read essential information from a DAX query plan. With this knowledge, the next step is to evaluate different strategies to improve query performance. During this training, you learn the most common patterns that could have performance issues and possible workarounds to solve them.
The training is delivered as a seminar, and the content is very dense. You can try the same techniques on your notebook during the course, but you should consider getting notes during the seminar and practice later.
The goal is to optimize the report execution and not the refresh time. Thus, this training only considers the performance of DAX expressions and does not cover refresh operation performance related to M code in Query Editor.
The examples are in Power BI, but you can also apply the concept of this training to Power Pivot, Analysis Services Tabular, and Azure Analysis Services.Auditorium BMon 09:00 – 17:00
Building Impactful Reports by Exploring the Art of Possible
This training covers many essential design principles (and how to apply them) to build impactful reports in Power BI Desktop. Students will learn about how to enhance report design by adding elements such as: drill through, bookmarks, report page tooltips, conditional formatting, custom visuals, and much more.
There is coverage on best practices and recommendations that build upon the functions and features available in Power BI Desktop, providing you with a strong design foundation upon which you can create your reports.
This course benefits both those new to Power BI and report design and those already familiar with Power BI. If you have a basic working knowledge of Power BI, this training will help fill in any gaps in your knowledge so you have a more complete set of skills.
Regardless of your experience in building visually attractive reports, this course will show you what a stunning Power BI report looks like. Reid will share the many things he does to make his reports stand out from the crowd.
When you apply what you learn to your own reports, you and your users are going to love the results.Room U11Mon 09:00 – 17:00
Analytics at scale with Power BI and Azure Synapse Analytics
For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabilities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons.
The advanced capabilities of both worlds can really complement each other. Learn how to design and build a truly scalable solution that spans both Power BI and Azure Synapse Analytics. We will help you to get the best out of both worlds, sharing our learnings and best-practices along the way in a demo-rich day and covering recent new developments like Power BI Datamarts and related technologies.
After the session you will be able to:
• Better design and implement complex data models, including hybrid tables, aggregations, and combined storage modes (import, DirectQuery, dual).
• Orchestrate the end-to-end data processing, with a pipeline chain from data ingest in the data lakehouse to the incremental Power BI dataset refresh.
• Use different techniques to identify performance bottlenecks in your solutions and how to solve those (“does it fold”?).
• Implement a cost-efficient solution, that still meets the scalability demands.Room U14Mon 09:00 – 17:00