- Docente: Francesco Bergamaschi
- Credits: 4
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: First cycle degree programme (L) in Business Administration (cod. 8871)
Learning outcomes
At the end of the course the student has acquired skills for the use of software which support business management. In particular, applications are proposed for the use of ERP and business intelligence applications
Course contents
Theory (in class / lectures)
Introduction to information systems.
Data & big data management.
Databases.
CRM.
ERP systems.
IT strategy and planning.
Applications (in laboratory / real business cases)
Office automations examples.
Business Intelligence in MS Excel through functions, pivoting, vlookup, primary keys, calculated fields, power pivoting, DAX functions, dashboarding.
Business Intelligence in MS Access through queries and macros.
SQL and Power BI basics.
Readings/Bibliography
Turban, Volonino, Wood / Information Technology for Management - International students version, Wiley, 2015 (10th edition) - chapters 1, 2, 3, 4, 10, 12 and 13.
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.
McFedries / Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, Wiley, 2010 (2nd edition).
Teaching methods
Lectures and practical applications in laboratory.
Assessment methods
Practical test in laboratory on MS Excel Power Pivot and MS Access queries, plus a few theory open questions.
Teaching tools
Blackboard, slides, PCs.
Office hours
See the website of Francesco Bergamaschi