EXCEPTIONAL TRAINING FOR DATA PROFESSIONALS

Power BI - Dax Training Course

Maximise Power BI's features to create complex Calculations in DAX

NEXT COURSE
23 Oct London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Power BI - Dax training course (code: PowerBIDAX )

TRAINING COURSE OVERVIEW

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 in order to create complex calculations which will allow you flexibility beyond that offered by the standard toolset.

Learn how to use variables, create write time intelligence calculations, cumulative totals, dynamic titles, DAX studio to debug and increase performance  ​​​

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

AUDIENCE

Business Analysts, Financial Analysts, Data Scientists and 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...


CONTENT

DETAILHIGHLIGHTS

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
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 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
DAX STUDIO:
Dax as a query language
Capturing and debugging queries with Dax Studio
Power BI referencing

 

  • Dax

UPDATES
Receive the latest version of this course into your inbox



LONDON COURSES
- INCLUDES LUNCH -

23rd Oct 2019 - 1 days £795
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


CONTACT
0800 028 6400



Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

NEWSLETTER
Get exclusive news about upcoming programs, technical insights & special offers