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

Calendar-based Time Intelligence in Power BI

In this session you will see how easy it is now in Power Bi to set up anykind of non-gregorian calendars and have standard time-intelligence functions on top of it. Furthermore, you will see how the gregorian-calendar time intelligence gets simplified in terms of DAX.

Understanding CALCULATE, the queen of all DAX functions

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 DAX Pillars

This session shows, gradually, all the fundamentals of DAX in a practical way.

User-Defined Functions (UDFs) in Power BI: overview and applications

In this session, User-Defined Functions (UDFs) will be explained and applied to real business cases, also going into the difference between model dependent and model independent UDFs

Table Functions in DAX

In DAX, filters are tables. Therefore, being able to create tables means being able to generate filters that can be used in your measures to create interesting KPIs. In this session you will learn how to use the most important DAX table functions, along with practical examples.

Visual Calculation vs Measures in Power BI: which to choose, when and why

In this session Visual Calculations will be introduced and compared in terms of pros and cons to classic model measures

What NOT TO DO in DAX

In this session you will learn what things should not be done in DAX to avoid performance issues and incorrect calcuations