Dismiss

Power BI - Dax training course

Name: DAX Training Course
Start: 2022-06-24 00:00
End: 2022-06-25 00:00
Location: Power BI - Dax training course

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

PRIVATE COURSES

Get a custom quote
Train a team
Free tasters

ENQUIRE

PUBLIC COURSES

Next on 27 Oct
£795.00+VAT
Live / Virtual

BOOK

Highlights Overview Audience Course Details Prices & Dates

Course Highlights

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

4.8 out of 5.0 average feedback
"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

FULL COURSE DETAILS
ENQUIRE / BOOK

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 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
ENQUIRE / BOOK

Audience

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

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

FULL COURSE DETAILS
ENQUIRE / BOOK