Training sessions

The Power BI Next Step 2022 conference will host 3 concurrent full-day training sessions on September 19th.

  • 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 2
    Mon 09:00 – 17:00
    • Intermediate
    • Design
    • Vizualizing
  • 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.

    Room 1
    Mon 09:00 – 17:00
    • Advanced
    • DAX
    • External tools
    • VertiPaq
  • Take your Power BI Solution to the Next Level Using Dataflow

    Power BI Solutions can be an all-in-one solution but may not be easily maintainable. Dataflow offers the separation of the ETL layer of the solution, which is a cloud-based service, but it is also making the solution a multi-layer implementation. In this training session, you will learn what dataflow is, how you can use it in your Power BI Solution, how it can level up your Power BI solution to a better solution, How it can be implemented, tips and tricks for moving from Power Query to dataflows, and some advanced transformations in the dataflows that helps your solution and data model. And not just only that, you will learn how dataflow can help in structuring your dimensional model and star schema with best practices and advanced data transformation scenarios.

    This workshop is recommended for everyone who uses Power Query for data transformation and load in Power BI. Reza Rad, Author of Dataflow articles in Microsoft documentation and author of 12 books on Power BI, shares his experience and tips and tricks about dataflows and Power Query-based ETL architecture for better data modeling.

    The content covered is as below;
    – Data modeling 101
    – What are Dataflows and their use cases
    – Creating and using dataflows
    – Migrating Power Query from Power BI Desktop to dataflow
    – Performance considerations and best practices
    – Advanced transformations in Power Query
    – Error handling and troubleshooting
    – Power Query transformations for a better data model
    – Power BI architecture using dataflows and shared datasets

    At the end of this workshop, you will be able to use your learning to build a multi-developer and easy-to-maintain solution using dataflows in Power BI. You will be able to move your queries from the Desktop into dataflows, troubleshoot, and follow the best practices to have a better Power BI solution.

    Room 3
    Mon 09:00 – 17:00
    • Advanced
    • Dataflow
    • Modeling
    • Power Query
Agenda Management powered by Sessionize.com

Training day speakers