95029 - PRINCIPI DI BUSINESS INTELLIGENCE

Course Unit Page

SDGs

This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.

Quality education

Academic Year 2022/2023

Learning outcomes

At the end of the course students master the techniques to manage corporate data. They will understand how to join tables, create simple reports including KPI calculations and basic office automations.

Course contents

Introduction to corporate data management.

Data management in MS Excel through functions, pivoting, vlookup, primary keys, calculated fields, pivoting, pivot charting.

Data Management in MS Access through queries and macros.

Introduction to DAX for MS Excel Power Pivot.

Readings/Bibliography

Bergamaschi, Bianconi, Mattavelli / Business Intelligence per le PMI, Maggioli Editore, 2022 - chapters 1 to 4.

Teaching methods

Lectures and practical applications in laboratory.

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

Assessment methods

Practical test at the PC on MS Excel Pivots and Power Pivots and MS Access queries, 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

Teaching tools

Blackboard, slides, PCs.

Office hours

See the website of Francesco Bergamaschi