22-25 April 2026

Francesco Bergamaschi

Consultant and corporate trainer in Business Intelligence (BI) and Business Analytics (BA), Adjunct Professor of BI and BA at Bologna University and Bologna Business School, co-founder of kubisco - a consultancy - he has been working for over twenty years in the field of data management. Today he deals with Power Pivot for Excel, Analysis Services Tabular and Power BI, dedicating himself to teaching and deepening the DAX language, being the first teacher in the world to teach it in a university. He implements BI in companies and integrates it with Statistics to create predictions through BA and has been promoting for years the dissemination and implementation of BI and BA throughout the territory of Northern Italy. He is a founding member of the Power BI User Group Italy and now manages kubisco, a blog on all MDP/DAX/Power BI/Power Apps/Analysis Services Tabular with articles, video, sample files. MEng, MEcon, MBA https://www.unibo.it/sitoweb/francesco.bergamaschi/en https://www.bbs.unibo.eu/faculty/bergamaschi-3/ www.kubisco.com

Sessions for 2026

Understanding DAX Pillars
 

DAX is a simple language (but not easy at all). Its pillars, though, need to be clearly understood in order not to get confused when they interact between them in your measures, calculated columns or calculated tables. In this session the five DAX pillars (filter context, row context, context transition, iterators and expanded tables) will be explained, with examples, one by one first and then in interaction between them. Examples will be in increasing complexity order.

Understanding CALCULATE, the queen of all DAX functions - Part 1
 

This session will show how to use CALCULATE and the basics on how it works, furthermore showing a full example of writing a complex DAX measure using CALCULATE starting from the definitions and getting to the final DAX code

Understanding CALCULATE, the queen of all DAX functions - Part 2
 

This session will show how to use CALCULATE and the basics on how it works, furthermore showing a full example of writing a complex DAX measure using CALCULATE starting from the definitions and getting to the final DAX code

Previous Sessions