On our Microsoft Power BI course, you will learn how easy it is to import data into the Power BI Desktop and create powerful and dynamic visuals that bring your data to life. But what if you need to create your own calculated columns and measures; to have complete control over the calculations you need to perform on your data? DAX formulas provide this capability and many other important functions.
Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is Business Intelligence, and DAX will help you get there.
This course is available as both a public off-site course which you can book below, or as a private on-site course just for your business team. If you’re interested in a private course, it can be tailored to your custom needs and take place either at your offices or our training rooms in London. Please get in touch for a quote.
The course covers the ability to use Data Analysis Expressions (DAX) language to perform powerful data manipulations within Power BI Desktop. You’ll learn DAX concepts such as Filter Context and how this can be managed with functions like “SELECTEDVALUE” “ALL” and “CALCULATE” in DAX. We also look at the Data Model and how it can be influenced by DAX formula such as “USERELATIONSHIP”.
To get the most out of this course you should be a competent Microsoft Excel user. You don’t need any experience of using DAX but we recommend that you attend our 2-day Microsoft Power BI course prior to taking this course.