Anno Accademico 2022/2023

Conoscenze e abilità da conseguire

At the end of the course students master the design, creation and interpretation of corporate Business Intelligence (BI) reports. They will understand the different design choices and technologies and the different options on how to implement a BI report. The course will also show how to include in a BI report forecasts and predictions (Business Analytics - BA).


Important: it is higly recommended to attend the course "Principi di Business Intelligence" (https://www.unibo.it/it/didattica/insegnamenti/insegnamento/2022/463901, taught in Italian) or to study in anyway the related contents before attending this course, as this will facilitate the learning process.


Data & big data management principles.

Databases architecture.

Business Intelligence in MS Excel through power pivoting.

Business Intelligence in Power BI Desktop and Cloud.

DAX functions, dashboarding, reporting.

Business Analytics using Power BI and R.


Russo, Ferrari / The definitive guide to DAX, Microsoft Press, 2019 (2nd edition).

Rad / Pro Power BI Architecture, Apress, 2018.

Metodi didattici

Lectures and practical applications in laboratory.

Important note: up to 20 Erasmus students can be accepted, the criteria will be "first come, first served".

Modalità di verifica e valutazione dell'apprendimento

Practical test at the PC on MS Excel Power Pivot / MS Power BI, plus a few theory open questions.

The course mark is numeric (from 0 to 30), numeric marks correspond to the following grades:

<18 insufficient
18-23 sufficient
24-27 good
28-30 very good
30 cum laude excellent

Strumenti a supporto della didattica

Blackboard, slides, PCs.

Orario di ricevimento

Consulta il sito web di Francesco Bergamaschi


Istruzione di qualità

L'insegnamento contribuisce al perseguimento degli Obiettivi di Sviluppo Sostenibile dell'Agenda 2030 dell'ONU.