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.
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
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
○ 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
• Filter Manipulation
○ Neglect & Replace
○ Respect & Add
• Evaluation Context & Relationships
• CALCULATE with Complex Conditions
• Time Intelligence
○ Definition & Activation
○ Calendar Table
○ Time Intelligence Functions
○ Time Intelligence Filters
○ Create Rolling 12 Months, Rolling 12 Months Average
• Many-to-Many Relationships
○ Semantic Blocking
○ Bi-directional Filtering
• Dynamic Banding
• Disconnected Slicres
• 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
Students will get 2-year access to the on-line in2Facts documentation platform
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.
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:
- Install as an app from the Microsoft Store.
- Download directly, as an executable you download and install on your computer.
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.
This ticket provides access to the professional training classes of the in2Facts Training Academy.€1,300.00
This ticket provides access to the professional training classes of the in2Facts Training Academy.€1,500.00
Early Bird Price
€ 650 / day
First 5 seats are offered at an early bird entrance price.
€ 750 / day
Also KMO-Portefeuille registered
for providing training services.
Registration nr DV.O217305
Mezzo Hotel - Paal
Perfect location at E313 exit 26 Paal,
just a 5 minute drive from the
cloverleaf (intersection E313 - E314)