- Docente: Francesco Bergamaschi
- Credits: 6
- SSD: SECS-P/07
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Forli
- Corso: First cycle degree programme (L) in Economics and business (cod. 9202)
-
from Feb 12, 2025 to Mar 20, 2025
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.
Introduction to Business Intelligence.
Data Management in Power Query and power Pivot for Excel and in Power BI.
Introduction to DAX.
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
SDGs
This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.