# Power BI - Dax training course

## Maximise Power BI's features to create complex Calculations in DAX - the formula language used throughout Power BI. Go further and beyond with this DAX - Power BI Training.

#### Public Courses

05/08/24 - 1 days
£795 +VAT
16/09/24 - 1 days
£795 +VAT
28/10/24 - 1 days
£795 +VAT

#### Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day

• 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

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

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.

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.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR