Power BI - Dax training course

Maximise Power BI's features to create complex Calculations in DAX - the formula language used throughout Power BI

NEXT COURSE 18 December (1 days £795 + VAT) BOOK NOW

JBI training course London UK

  • Gain an introduction to commonly used DAX functions
  • Apply Sum, Average, Count and DistinctCount
  • Learn to create a measure table
  • Understand how to use Variables, Calculations and Cumulative Totals
  • Acquire skill in Copying and Moving Measures
  • Use Variables in Calculation
  • Explore Different granularity: calculate allocated weight
  • Use Dax as a query language in Dax Studio
  • Capture and debug queries with Dax Studio
  • Use DAX studio to increase performance
  • Evaluate Contexts and Relationships
  • Understand the use of CALCULATE
  • Learn Table Functions: ALL, ALLEXCEPT, FILTER, DISTINCT, VALUES
  • Explore Advanced Evaluation Context DAX
  • Roll totals for different periods
  • Learn IF, HasOneValue
  • Use a Safe Divide Function and the Blank() Function

FULL COURSE DETAILS

Our Dax training course is aimed at Power BI users who are looking to get even more out of this popular tool.

We will show you how to use Power BI's functionality to create complex calculations that will allow you flexibility beyond that offered by the standard toolset.

Learn about Variables, Time Intelligence calculations, cumulative totals and dynamic titles, and how to use DAX Studio to debug and increase performance.   ​​​

A number of optional topics exist which can be requested for private courses, depending on your organisation's business requirements.


FULL COURSE DETAILS
JBI training course London UK
JBI training course London UK

Business Analysts, Financial Analysts, Data Scientists.  

Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth.

Developers and Super Users/ Power Users looking to get more out of Power BI.

Learn to build Dashboards like this - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...

 


FULL COURSE DETAILS

Related Courses

DAX

  • Commonly Used DAX Functions
  • Sum, Average, Count, DistinctCount
  • Create a measure table
  • Copying and Moving Measures
  • Use Variables in calculation
  • Different granularity: calculate allocated weight

DAX STUDIO

  • Dax as a query language
  • Capturing and debugging queries with Dax Studio
  • Power BI referencing

 

 

 

CONTEXT

  • Filter context 
  • Evaluation Contexts and Relationships
  • Understand the use of CALCULATE
  • Table Functions: ALL, ALLEXCEPT, FILTER
  • Table Functions: DISTINCT, VALUES
  • Advanced Evaluation Context DAX  
  • Context transition
  • Iterator -> nested row context
  • Row context and Totals
  • Row context and cumulative total

 

 

 

 

TIME INTELLIGENCE 

  • Time Intelligence prerequisites
  • Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
  • YTD, MTD with CALCULATE
  • Rolling totals for different periods
  • IF, HasOneValue
  • Using a Safe Divide Function
  • Using the Blank() Function
  • Build an Example Time Intelligence Report
  • Creating Dynamic titles
  • Using parameter table
  • What is scenarios

 

 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
0800 028 6400

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address 1345 High Road, London, N20 9HR