Premium event
Advanced Data Modelling with PowerBI
Veranstalter
Image
Datum
27. Mai 2021
- 9:00
bis 17:00
Kategorie
Workshop
Ort
Online
Kontaktinformation
André Schmid
marketing@allgeier.ch
Beschreibung
This course was developed by the Microsoft Power BI Team. It focusses on Modelling techniques and DAX, the modelling language used in Power BI. By the end of this course, you will be able to use DAX to create calculations in a Power BI Desktop data model. After this training you will be able to:
- Understand basic concepts of Data Modeling
- Understand the consequences of data model design decisions
- Understand concepts of calculated columns and measures
- Gain familiarity with standard DAX patterns & CALCULATE
- Understand evaluation contexts and their impact on calculations
- Gain ability to parse data modeling formulas
The course is broken down into 7 Modules with presentations, discussions and lab exercises:
- Module 1: Data Modeling Basics & Power BI Desktop Internals
- Module 2: Data Modeling Best Practices
- Module 3: DAX Calculated Columns & Measures
- Module 4: CALCULATE
- Module 5: DAX Evaluation Contexts
- Module 6: Data Modeling: Time Intelligence Functions
- Module 7: DAX Best Practices
Prerequisites: Attendees should be familiar with basic Power BI Report design techniques and have attended some introductory training, such as the Dashboard in a Day session.
Language: English or German, depending on attendees. During Break-Out Sessions our Trainers will communicate in your preferred language.