Course in Power BI advanced calculations
For those have already built a data model and a report but you need some inspiration to create the right measures in DAX so that your users gain the right knowledge directly from Power BI.
“Focus on getting the right set of numbers before performance”, but do you feel overwhelmed or confused by the function language, Data Analysis Expressions (DAX) language and its use in Power BI.
About the course
This course will provide a broad knowledge of the most important DAX functions you must master, combined with the foundational concepts in DAX as the importance of working with star schema data models, measure vs. calculated columns, filter and row context, CALCULATE, Roche’s Maxim of data transformation and much more.
After the course, you will have a better idea of the learning path you need to enter, gain greater knowledge on where to get help and which resources visit to master upcoming DAX challenges. Our ambition is to get you on a comfortable level of writing DAX which we will aim by using our practical and hands-on experiences (and pains) working with DAX.
Course content
Introduction to DAX & Data Modelling
Basic DAX & Iterator Functions
Evaluation Context
Time Intelligence
Calculation Groups
Practical information
The course is aimed at those who are already working with Power BI. You have built a data model and associated report, but you need inspiration to create the right measures in DAX, so your users receive accurate insights directly in Power BI.
Data, location, price og registration
The course is held regularly in Copenhagen, Aarhus and Kolding.
The price is DKK 4,000 ex-VAT, including meals and refreshments. Please note that we offer a multiple enrollment discount and individual and company-specific courses can be arranged. Contact us for more information.