- Docente: Stefano Rizzi
- Credits: 6
- SSD: ING-INF/05
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Cesena
-
Corso:
Second cycle degree programme (LM) in
Computer Science and Information Technology (cod. 8030)
Also valid for Second cycle degree programme (LM) in Computer Science and Engineering (cod. 8614)
Learning outcomes
After the course, the student is skilled in business intelligence architectures and functionalities. In particular, the student is capable of designing and administrating enterprise data warehouses.
Course contents
- Business intelligence:
- the role of BI in the corporate information system;
- data warehousing;
- data mining;
- what-if analysis;
- Business Performance Management.
- architectures;
- techniques for data analysis;
- lifecycle:
- data source analysis;
- requirement analysis;
- conceptual design;
- workload and data volume;
- logical design;
- design of loading procedures;
- physical design.
Readings/Bibliography
- Slides.
- M. Golfarelli, Stefano Rizzi. Data Warehouse Design: Modern principles and methodologies. McGraw-Hill, 2009.
- M. Berry, G. Linoff. Data mining techniques for marketing, sales, and customer support. John Wiley & Sons, 1997.
- B. Devlin. Data warehouse: from architecture to implementation. Addison-Wesley Longman, 1997.
- W.H. Inmon. Building the data warehouse. John Wiley & Sons, 1996.
- M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis. Fundamentals of data warehouse. Springer, 2000.
- R. Kimball, L. Reeves, M. Ross, W. Thornthwaite. The data warehouse lifecycle toolkit. John Wiley & Sons, 1998.
- I. Witten, E. Frank. Data mining. Morgan Kaufmann Publishers, 2000.
Teaching methods
- Lessons and exercises in the classroom
- Seminars from enterprise consultants
- Practice in the laboratory on widespread data warehousing tools
Assessment methods
Written examination on design techniques.
Teaching tools
Downloadable didactic material.
Office hours
See the website of Stefano Rizzi