Advanced Power BI – DAX & Data Modeling

Niveau
Tijdsduur
Locatie
Online
Startdatum en plaats

Advanced Power BI – DAX & Data Modeling

Xebia Academy
Logo van Xebia Academy
Opleiderscore: starstarstarstarstar_half 8,6 Xebia Academy heeft een gemiddelde beoordeling van 8,6 (uit 105 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

computer Online: Virtual
11 nov. 2024 tot 12 nov. 2024
Toon rooster
event 11 november 2024, 09:00-17:00, Virtual, Dag 1
event 12 november 2024, 09:00-17:00, Virtual, Dag 2

Beschrijving

During this training you will learn how to perform advanced data transformations not available in the Query Editor. We will discuss how to leverage the embedded PowerBI programming language (M) to achieve this. The M basics will be covered as well as how to write custom functions empowering participants to work with poorly structured data and to prepare it for a star structure.

In addition, participants will learn how to enable dashboard users to write back to a source through Power Apps. We will cover Power Apps fundamentals, including how to create a Power App and add it as a visual on a Power BI dashboard.

Finally, as performance problems might occur when models grow larger and more compl…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Power BI, Business intelligence, Splunk, Microsoft Power Platform en Corporate Communicatie.

During this training you will learn how to perform advanced data transformations not available in the Query Editor. We will discuss how to leverage the embedded PowerBI programming language (M) to achieve this. The M basics will be covered as well as how to write custom functions empowering participants to work with poorly structured data and to prepare it for a star structure.

In addition, participants will learn how to enable dashboard users to write back to a source through Power Apps. We will cover Power Apps fundamentals, including how to create a Power App and add it as a visual on a Power BI dashboard.

Finally, as performance problems might occur when models grow larger and more complex, we will address the Vertpaq Analyzer and DAX studio, two powerful tools to diagnose and fix performance issues.

The Advanced Power BI training is perfect for

Power BI Key users with over a year of Power BI experience who want to bring their Data Modeling and DAX knowledge to the next level.

What will you learn during the training?

  • Performing complex operations on data in the Power Query Editor
  • Writing functions (yourself) in the M language (custom functions)​
  • Build, maintain and manage a Power BI model using the Tabular Editor
  • Use the Tabular Editor to create calculation groups
  • Applying Vertipaq Analyzer to analyze the structure of a data model
  • Applying DAX Studio to analyze and optimize DAX code

Power BI users that build models in more complex scenario’s tend to run into problems in these areas:

  • Having to perform transformations in the Query Editor that cannot be done by simply using the User Interface. Therefore, we will discuss how this can be done with the programming language available in Power BI (M).
  • Having to create and maintain a large amount of tables, columns and measures. This can result in a lot of frustrating time spent on creation and maintenance on the one hand and is error prone on the other. In order to be able to become more efficient and effective when it comes to Power BI model management, the Tabular Editor will be covered. This free tool is also widely used by Microsoft Power BI program managers in their instruction videos on Power BI.
  • Performance issues. When a user interacts with a dashboard, spinners that start running on visuals for more than one or two seconds result into poor user experience. In order to avoid that from happening, performance optimization will be covered. DAX studio is the go-to tool when it comes to optimization of DAX code. In DAX Studio, the way the Power BI Engine (Vertipaq) processes DAX code can be analyzed and therefore optimized. And recently, the Vertipaq analyzer has been integrated into DAX Studio. Therefore, DAX studio now also allows for analyzing the storage structures of a Power BI model.

Yes, I want to do more with Power BI!

After registering for this training, you will receive a confirmation email with practical information. A week before the training we will share literature if there's a need to prepare. See you soon!​

What else should I know?

  • The training is given per half day.
  • The training requires DAX Studio and Tabular Editor. These can be downloaded for free but for installation (temporary) admin rights are required.
  • This BI training is brought to you by Xebia Data. Xebia Data is part of Xebia, just like Xebia Academy. Xebia Data works with experts in their field who are always on the lookout for the most innovative ways to get the most out of data. Your trainer, Marnix Jansen is a long-time Power BI user and trainer who enjoys sharing their experiences to empower you to be more effective when crafting dashboards.​

Scale up your skills
Boost your career

Get the training you need to succeed, in every IT field.
Learn from the world's leading experts with public and in-company courses at Xebia Academy.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.
  • Vraag informatie aan over deze training. Je ontvangt vanaf dan ook een seintje wanneer iemand een ervaring deelt. Handige manier om jezelf eraan te herinneren dat je wilt blijven leren!
  • Bekijk gerelateerde producten mét ervaringen: Power BI.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Vraag nu gratis en vrijblijvend informatie aan:

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)