- 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)
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
Collie, Singh / Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016, Holy Macro! Books, 2016 (2nd edition) - chapters 1 to 7.
Jelen, Alexander / Pivot Table Data Crunching Excel 2016, Que Publishing, 2015 (2nd edition).
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.
Teaching tools
Blackboard, slides, PCs.
Office hours
See the website of Francesco Bergamaschi