DAX & Advanced Features for Microsoft Power BI

Download Course Outline

This course will cover using Data Analysis Expressions (DAX) to perform powerful data manipulations within Power BI Desktop, the advanced use of the Query Editor and Power BI Administration.

On our Microsoft Power BI course, you learnt how easy 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 capabilities as well. You will also learn how to merge and append data using the Query Editor to help you build better data models. When you get the information you need, you can begin to solve real business problems that affect your bottom line.

To get the most out of this course

You should have attended our 2-day Microsoft Power BI course course or be a competent Power BI user.


 Call us on 0800 0199 746  


Outline of our DAX & Advanced Features for Microsoft Power BI Course
Duration: 1 day  

You can download a PDF course outline using the link on the top right of this page.  

Importing Your Data and Creating the Data Model

  • Overview of importing data into Power BI Desktop and creating the Data Model.

Creating Calculated Columns 

  • How to use DAX expressions in Calculated Columns.
  • Using AND and OR operators (&& and ||).
  • Using BLANK and ISBLANK.
  • Using RELATED to look up values from related tables.
  • Understanding de-normalisation. 

Creating Measures 

  • Why use Measures and opposed to Calculated Columns?
  • Implicit and Explicit Measures.
  • How to Create a Measures using SUM & AVERAGE
  • Using COUNTROWS and DISTINCTCOUNT.
  • Using DAX aggregate functions; SUMX, AVERAGEX etc 
  • Using SELECTEDVALUE Function to return slicer selections

 Evaluation Context  

  • What is Evaluation Context?
  • The difference between evaluations using Row Context and evaluations using Filter Context. 

CALCULATE Function 

  • Exploring the importance of the CALCULATE function.
  • Using complex filters within CALCULATE using FILTER.
  • Using the ALLSELECTED Function.

Time Intelligence Functions

  • Why Time Intelligence Functions?
  • Creating a Date Table.
  • Finding Month to Date, Year To Date, Previous Month and Same Period Last Year.
  • Creating Moving Annual Totals and Moving Averages

Advanced Queries 

  • How to denormalise your data by merging queries.
  • Using Merge to find non-matching data.
  • Using Merge to summarise data.
  • Understanding Disable Load
  • Using the Append Queries option
  • Using the Connection to Folder to append
  • CSV files and Excel Files
  • Creating Query Parameters
  • Managing and editing Parameters 

Power BI Administration 

  •  Administering and securing Power BI users

 

 

 


 Call us on 0800 0199 746