Power BI DAX Basis - Schulung in Hannover

After the training you will be familiar with the DAX basics for Power BI and will be able to use DAX effectively.

Description

DAX (Data Analysis Expressions) is a formula language used in the background of Power BI. It includes a collection of functions and links that are used in a formula or expression to calculate and return one or more values. With the content of the training you can also collect, structure and visualize complex company data sensibly.

Target group

Power BI users

Duration

1 day

Content in detail

Introduction to Data Analysis Expressions (DAX)

• Overview
• Calculated Columns
• Calculated Tables
• Measures
• Calculated Columns vs Measures

Overview of essential DAX functions

• Aggregation functions
• Date and time functions
• Text functions

Introduction to filter logics

• Filter context
• FILTER functions
• ALL and ALLEXCEPT
• CALCULATE function
• Time intelligence calculations

Construction and use of control structures and logic functions

• Introduction and overview of logic functions
• IF function
• Control structures / IFERROR

Introduction to Finance Functions

• Overview
• RATES

Consideration and use of table relationships in DAX

• Overview of table relationships
• Active and inactive relationships
• USERELATIONSHIP function< /li>

Working with variables

• Overview
• Reducing complexity through variables

ATVISIO consulting practice: “Best practice” and avoidable errors

New: Now book as online training

On the mutually agreed training day, your trainer will contact you and first mirror his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your day-to-day business.

For further information, call us.< /p>

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email [email protected] or by phone 0631/4140140