Duration: 16 hours / 2 days
Knowledge: Intermediate
Potential trainer(s): Mihaela Banoci
Language: Croatian, English
Possible locations: PI EDU center, At client premises, Virtual education
So far you have used PBI, but you did not write DAX functions because they seemed too complicated?
Are you a PBI user and would like to improve your knowledge of data modeling and DAX calculations?
Are you a PBI user and writing DAX functions, but not sure if you’re using them correctly?
Are you a PBI user and write DAX functions, but you don’t always understand the results you get on the reports?
If any of the answers is true, then you are in the right place!
The fields marked with * are required
Join us for a two-day training on PBI modeling and DAX, where you will get a better understanding of how DAX machines “think” and work, tips and tricks on what to do and what to avoid in terms of best practices, and generally raise your DAX skills to a higher level.
The training is designed and prepared for PBI users who already have some experience working with PBI and are familiar with the basics of modeling (knowledge of star schema, dimensional modeling, measures, evaluation context) and some basic DAX functions.
With this training, you will increase your knowledge of Power BI, learn how DAX works and improve your reports by writing optimal code.
The basics that the participants of the education should know: old scheme, evaluation context, filter flow, measures, calculated columns.
An overview of the data model that will be used for educational purposes.
Formatting and commenting DAX queries, DAX variables, error handling.
Common scalar functions such as rounding (TRUNC, ROUND, ..), conversion (FORMAT, INT, DATE, ..), logical (IF, AND, OR, SWITCH, ..) and information functions (ISBLANK, ISERROR, ..).
CALCULATE modifiers, context transition, extended tables.
Creation of calculated tables, common filtering functions (ALL, ALLSELECTED, FILTER, SUMMARIZE, ..).
CROSSJOIN, UNION, INTERSECT, EXCEPT.
Extended tables, physical and virtual relationships, common relationship functions (RELATED, RELATETABLE, USERELATIONSHIP).
Iterator cardinality, nested iterators, context transition, common iterator functions (SUMX, COUNTX, RANKX, ..).
How to create a calendar table using DAX, comparison of customized time periods, working with fiscal calendars, common time intelligence functions (DATESYTD, DATEADD, PARALLELPARIOD, DATESINPERIOD, CALENDAR, ..).
You can officially register for the training via the registration form at the top of this page. After successfully sending the application, we will get back to you within 24 hours of receiving the application.
Mistakes in communication always happen, and if we don’t answer you, contact us directly at birdacademy@inteligencija.com
We currently do not support payment in multiple installments.
Of course, all our trainings can be followed virtually.
Students are entitled to a 10% discount on the price shown on this page.
BIRD Academy provides a computer, lunch, coffee and water for each participant. We strive to be the best host possible in every segment!
Duration: 24 hours / 3 days
Knowledge: Intermediate
Next Date:
Duration: 16 hours / 2 days
Knowledge: Beginner
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Beginner
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Intermediate
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Beginner
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Intermediate
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Intermediate
Next Date:
Soon
Duration: 16 hours / 2 days
Knowledge: Beginner
Next Date:
Duration: 8 hours / 1 day
Knowledge: Beginner
Next Date:
Soon
