top of page

Mon, Apr 20

|

Mezzo, hotel & business

Data Analysis eXpressions (DAX) - Basics (2 d)

Want to create smart measures that answer all your business requirements and stop designing new worksheets in case new questions are asked? This is the basic two day session to learn those powerful data analysis expressions (or the DAX language), a life changer for every controller and analyst.

Registration is Closed
See other events
Data Analysis eXpressions (DAX) - Basics (2 d)
Data Analysis eXpressions (DAX) - Basics (2 d)

Time & Location

Apr 20, 2020, 9:00 AM – Apr 21, 2020, 5:00 PM

Mezzo, hotel & business, Paalsesteenweg 170, 3583 Beringen, Belgium

About the Event

 Training Content

Big data and self-servicing Business Intelligence is the next big challenge for each Controller / Analyst. PowerPivot and DAX expressions can answer questions in a relative quick and easy way and perform calculations on large data sets. To meet the business intelligence needs of your company, you will learn how to efficiently solve real business problems using DAX expressions.

• Calculated Columns

• Measures

 ○ implicit measures

 ○ explicit measures

• Aggregation Functions

• Aggregation after Iteration Functions

• Fully Qualified versus Unqualified

• Error Handling

• DAX Evaluation Context

 ○ Row Context

 ○ Filter Context

 ○ Context Transition

• Filter Propagation

 ○ Prerequisites

• Filter Manipulation

 ○ Neglect

 ○ Neglect & Replace

 ○ Respect

 ○ Respect & Add

• Evaluation Context & Relationships

• CALCULATE with Complex Conditions

• Time Intelligence

 ○ Definition & Activation

 ○ Calendar Table

 ○ Hierarchies

 ○ Time Intelligence Functions

 ○ Time Intelligence Filters

 ○ Create Rolling 12 Months, Rolling 12 Months Average

• Many-to-Many Relationships

 ○ Row-by-Agonizing-Row

 ○ Batch-wise

 ○ Semantic Blocking

 ○ Bi-directional Filtering

 ○ Crossfiltering

• Dynamic Banding

• Disconnected Slicres

 Exercises

• Time Intelligence Management Report

• Banking Model Report

• Product Marketing Promotion Report

• Pareto Analysis Report + Chart + Conclusion

• Multi-functional Report with Dynamic Content based on Disconnected Slicer

📖 Documentation

Students will get 2-year access to the on-line in2Facts documentation platform

 Goal

Power Pivot Project and Tabular Data Modeling have the ability to read data from a wide range of data sources, to carry out in-memory calculations on them and to present the results to Excel, Power View and Reporting Services. 

This module will specifically use DAX formulas in Tabular BI Semantic Models (specific PowerPivot for Excel) and demonstrate step-by-step teaching instructions.

At the end of these two days the participant will be able to import data from various sources in a tabular model and create relationships between the different data sets. Also, the participant will add in a structured manner Measures and/or Calculated Columns to build reports that were  previously impossible and could only be developed by IT specialists. In addition the participant will define KPIs and add them to PivotTable reports  in such a way that the reporting of actuals versus budget is done in an automatic way without any form of maintenance. 

 Prerequisites

 Own Laptop 💻 + external mouse  

Power BI Desktop (see Microsoft's documentation Get Power BI Desktop).

 

You can get Power BI Desktop in two ways, each of which is described in the following sections:

🚫 Cancellations

Cancellations up to 8 days before the training course are at no charge. 

Cancellations after this date, as well as no-shows, will be liable for the full registration fee.

Tickets

  • Early Bird

    This ticket provides access to the professional training classes of the in2Facts Training Academy.

    €1,300.00
  • Trainee

    This ticket provides access to the professional training classes of the in2Facts Training Academy.

    €1,500.00

Total

€0.00

Share This Event

Early Bird Price

€ 650 / day
excl. VAT

First 5 seats are offered at an early bird entrance price.

Price

€ 750 / day
excl. VAT

Also KMO-Portefeuille registered

for providing training services.

Registration nr DV.O217305

Location

Mezzo Hotel - Paal

Perfect location at E313 exit 26 Paal,

just a 5 minute drive from the

cloverleaf (intersection E313 - E314) 

bottom of page