98704 - GESTIONE DEI DATI AZIENDALI LAB.

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

The course provides students with the basics of data management (self-service BI), including: the use of spreadsheets, simple databases and their interface with company information systems. At the end of the course, students have basic skills on: - usage of personal computers, spreadsheets and simple databases; - create simple KPIs for monitoring; - interface tools with company IT systems.

Course contents

Introduction to business data management.

Data management in MS Excel via functions, pivoting, vlookup, primary keys, calculated fields, pivots, pivot charts.

Data management in MS Excel Power Pivot and Power BI.

Introduction to the DAX language for MS Excel Power Pivot and Power BI.

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

Teaching tools

Blackboard, slides, PCs.

Office hours

See the website of Francesco Bergamaschi