Prof. Umberto Nanni
"Sapienza" Università di Roma
Facoltà di Ingegneria dell'Informazione, Informatica e Statistica
Dipartimento di Ingegneria Informatica, Automatica e Gestionale "Antonio Ruberti"
AA 2016-2017 - Enterprise Information Systems
MGER1 - Master's Degree in Management Engineering (Corso di Laurea Magistrale in Ingegneria Gestionale) D.M. 270
PROGRAM OF THE COURSE
This course will provide students with the knowledge of technologies and methodologies related to Enterprise Information Systems, from the description of the organization in terms of business processes and information assets. By discussing a simple project, the student is required to know and use practical technology (with examples suggested within Data Warehouse / Business Intelligence) as part of the examination.
The student has the opportunity to gain the capacity to address concrete problems and build (or help to build, in team with other specialists) solutions based on appropriate technologies, workflow management and / or information management.
- 0. Presentation of the course
- 1. Information in Organizations
- - organization, information system and data processing, efficiency and effectiveness
- - information technology, information resources
- 2. Process Management
- - process classification
- - identification, description and decomposition of processes; organizational variables
- - Business Process Reengineering (BPR), Benchmarking
- 3. Process Modeling
- - State Diagrams, Data Flow Diagram (DFD), WIDE
- - basic notions of Action Workflow and Petri Nets
- 4. Operational Support
- - types of information, institutional and operational application portfolio
- - manufacturing enterprise portfolio and integrated solutions: CIM, MRP, ERP, CRM, e-procurement
- - service enterpise portfolio: front office and back-office
- 5. Management Information Systems:
- - main issues; Business Intelligence architecture, management information
- - analysis of directional requirements: Critical Success Factors (CSF), Key Performance Indicators (KPI), references to the Balanced Scorecard method (BSC)
- 6. Introduction to Data Warehousing for Enterprise Information Systems:
- - motivations and basic concepts; OLTP / OLAP, DW architectures, ETL, Data Mart
- - multidimensional model, dimensional hierarchies, actors
- - DW design, logical models, outline of physical design and views
- 7. Basic techniques for Data Mining
- 8. Introduction to Social Networks as a modeling paradigm
- 9. A software platform for data warehousing (with working sessions):
- - general features and installation
- - DW exploration, construction of data marts, OLAP session
- - KPI and Dashboards, Data Mining.
- Seminars and case studies
Exam (6 CFU)
The following tests are carried out in order to support the
examination, carried out in any order (even in different appeals),
which retain validity until completion of the test:
- a written test, which affects the overall evaluation of the exam
with a weight of TWO THIRD of the final grade;
- the discussion of a Tesina, conducted individually or in small
groups, which affects the overall evaluation of the exam with a
weight equal to ONE THIRD, and may be accompanied a possible short
For the preparation of the Written Examination, consisting of a brief
set of questions related to a small project problem, please consult
the Exercise Exam (see below).
Defense of the Project/Tesina
The Project ("Tesina"):
The project/tesina is split into an ANALYSIS part and an IMPLEMENTATION part.
- is practical
- can be developed individually or in small groups (say, up to three, or a bit more)
- weighs for ONE THIRD on the overall exam grade
- does NOT require a prior agreement with the teacher
- may be defended, indifferently, BEFORE OR AFTER the written test
- is discussed in a COLLOQUIUM performed JOINTLY by the group that developed the Tesina.
The ANALYSIS consists in the description of a business case that
clarifies the nature of the problem, with some "business questions"
followed by the definition of "key performance indicator" and the Data
Mart project covering the indicators introduced. The developed
analysis, following the definition of the problem, is similar to what
is required for the written test, possibly with more complex
requirements. For example, see two sample projects by former students.
The IMPLEMENTATION part consists in the actual development the "data
intelligence" activity defined in the analysis part. This may be the
definition of (a fragment of) a data warehouse and / or a data mining
and / or social network analysis. Any Data Warehouse or Data Mining
software environment may be used, given that the interview is
accompanied by computer demonstration of what has been done or
analyzed. Therefore, it is necessary to bring a computer with a
running installation, on which each member of the group must show an
individual operational capability. In the case of particular
logistical requirements (eg the necessity of a particular laboratory
instrumentation) the arrangements will be agreed upon.
Resources - technologies - reference software environments
Data Warehouse e Data Mining
Microsoft SQL Server + Analysis Services:
Free software and resources used for learning activities, thanks
It is suggested to use the latest stable release.
A large case study is also available, with documentation and detailed
- DATA - Sample case study: AdventureWorks Sample Databases (actual
page can change)
- DOCUMENTATION: SQL
Umberto Nanni (home page)