LIVE Instructor-Led Courses
Dismiss

Power BI - Dax training course

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

JBI training course London UK

"Great coverage of DAX principles including basic DAX formulae and  time intelligence. The trainer was very knowledgeable and informative."

AW, Senior BI developer, Power BI - DAX, March 2021

TAILOR-MADE
Enquire & get a quote
PUBLIC COURSES
Next on 6 Jul - see prices
JBI training course London UK

  • Gain an introduction to commonly used DAX functions
  • Apply SUM, AVERAGE, COUNT and DISTINCTCOUNT
  • Housekeeping with Measure Groups
  • Using variables in calculations
  • Integrate tables of different granularity
  • Develop DAX queries in DAX Studio
  • Capture query traffic
  • Solve DAX performance problems
  • Understand the use of CALCULATE
  • Learn Table Functions: ALL, ALLEXCEPT, FILTER, VALUES
  • Evaluation contexts and relationships
  • Explore Advanced Evaluation Context DAX
  • Rollup totals for different periods
  • Apply IF, SELECTEDVALUE
  • Use a Safe Divide Function and the Blank() Function
  • Introducing DAX calculation groups to enhance measures flexibility and re-usability

DAX

  • Examples with SUM, AVG, COUNT, DISTINCTCOUNT
  • Common DAX patterns
  • Scenarios for FILTER, SELECTEDVALUE
  • Ranking functions, TOPN
  • When to use the X-functions
  • Create filtered measures with CALCULATE
  • Virtual tables
  • Percents of Total with ALL, ALLSELECTED, ALLEXCEPT

BEST PRACTICES

  • Safe DIVIDE
  • Housekeeping with measure groups
  • Interim measures
  • Measures for conditional formatting
  • Use of DAX variables
  • Using the BLANK() function

 

 

 

CONTEXT

  • Be clear on Measures vs Columns
  • Understand Filter Context
  • Propagate filter through Context Transition
  • Iterate with Row Context
  • Implement ABC Classification

RELATIONSHIPS

  • Filter flow direction through relationships
  • RELATED vs LOOKUPVALUE
  • Data tables vs lookup tables
  • Accommodating different table granularities
  • Data lineage

 

 

 

TIME INTELLIGENCE 

  • Benefits of Dates table
  • Year-on-year comparisons
  • SAMEPERIODLASTYEAR, PARALLELPERIOD
  • Cumulative Total to Date calculations
  • Fiscal years/quarters
  • Special accounting periods
  • Pro-rata view for incomplete trading periods
  • Events in progress
  • Budget vs Actual comparison methodology

PRODUCTIVITY  MISC

  • Understand IntelliSense syntax notation
  • Dynamic titles, CONCATENATEX
  • Introduction to DAX Studio
  • DAX query examples
  • Capture DAX query traffic
  • Identify and fix performance issues
  • Use Calculation Groups
  • What-if analysis
  • Design for budget and actual figures on same chart
JBI training course London UK

Business Analysts, Financial Analysts, Quants, 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.

Note : This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC

 


4.8 out of 5 average

"Great coverage of DAX principles including basic DAX formulae and  time intelligence. The trainer was very knowledgeable and informative."

AW, Senior BI developer, Power BI - DAX, March 2021

JBI training course London UK
 
Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

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

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course