EXCEPTIONAL TRAINING FOR DATA ANALYSTS & IT PROFESSIONALS

DAX Training Course

NEXT COURSE
11 Jan London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

DAX training course (code: DAX)

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


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

Our Dax  training course for Microsoft Power BI 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 produce stunning visuals and how DAX can be used in order to create complex calculations which will allow you flexibility beyond that offered by the standard toolset.

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...


DETAILHIGHLIGHTS

DAX

DAX Basics review
Table Functions
Evaluation Contexts o Filter and Row Context o CALCULATE
Evaluation Contexts and Relationships
Time Intelligence Calculations
DAX as a Query Language: use of DAX Studio
Advanced Table Functions
Advanced Evaluation Context DAX (Understanding Cross filters)
Calculations over Hierarchies
Parent/Child Hierarchies  
Creating Dynamic titles
Using parameter table
Capturing and debugging queries with Dax Studio

Data modelling

Creating a Bridge Table
Role Playing Tables with DAX
Role Playing Tables without DAX
Mismatched Granularies

  • DAX
  • Data modelling
Receive the latest version of this course into your inbox


PUBLIC COURSES (LONDON, UK)
 

11th Jan 2019 - 1 days £999
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


Get in touch
0800 028 6400




Excellent feedback, consistently !

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"


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