- Docente: Francesco Bergamaschi
- Crediti formativi: 6
- SSD: SECS-P/08
- Lingua di insegnamento: Inglese
- Modalità didattica: Convenzionale - Lezioni in presenza
- Campus: Bologna
- Corso: Laurea in Management e marketing (cod. 8406)
Conoscenze e abilità da conseguire
At the end of the course student masters a broad array of issues managers face in the selection and management of information technology. He/She learns how information technology systems support business operations and help implement business strategies.
Contenuti
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.Testi/Bibliografia
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.
Murach / MySQL, Mike Murach & Associates Inc, 2015 (2nd edition).
McFedries / Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, Wiley, 2010 (2nd edition).
Metodi didattici
Lectures in class and practical applications in laboratory.
Modalità di verifica e valutazione dell'apprendimento
Practical test in laboratory on MS Excel Power Pivot and MS Access queries, plus a few theory open questions.
Strumenti a supporto della didattica
Blackboard, slides, PCs.
Orario di ricevimento
Consulta il sito web di Francesco Bergamaschi