DECISION SUPPORT SYSTEMS

Matteo GAETA DECISION SUPPORT SYSTEMS

0622700077
DIPARTIMENTO DI INGEGNERIA DELL'INFORMAZIONE ED ELETTRICA E MATEMATICA APPLICATA
EQF7
COMPUTER ENGINEERING
2021/2022

YEAR OF COURSE 2
YEAR OF DIDACTIC SYSTEM 2017
AUTUMN SEMESTER
CFUHOURSACTIVITY
324LESSONS
324EXERCISES
Objectives
THE COURSE PRESENTS THE METHODOLOGIES AND THE TECHNOLOGIES THAT ARE NEEDED FOR GATHERING, STORING, ANALYZING LARGE AMOUNTS OF DATA, WITH PARTICULAR REFERENCE TO DATA WAREHOUSES AND DECISION SUPPORT SYSTEMS.

KNOWLEDGE AND UNDERSTANDING:
METHODOLOGIES AND TECHNOLOGIES FOR GATHERING AND STORING LARGE AMOUNTS OF DATA TO PERFORM ANALYSIS AND PREDICTION OPERATIONS, AIMED AT SUPPORTING THE DECISION-MAKING BOTH AT SHORT AND AT MEDIUM AND LONG TERM.

APPLYING KNOWLEDGE AND UNDERSTANDING:
USING SOFTWARE TOOLS FOR THE REALIZATION OF APPLICATIONS THAT PROCESS LARGE AMOUNTS OF DATA AND THAT ALLOWS ADOPTING TECHNIQUES FOR THE ANALYSIS, MODELING, AND PREDICTION TO SUPPORT DECISIONS.
Prerequisites
FOR THE SUCCESSFUL ACHIEVEMENT OF THE OBJECTIVES, PRIOR KNOWLEDGE OF DATABASES IS RECOMMENDED.
Contents
COURSE INTRODUCTION: PRESENTATION OF THE COURSE; INTRODUCTION TO THE FUZZY LOGIC AND TO THE FUZZY CONTROL SYSTEMS
(LECTURE / PRACTICE / LABORATORY HOURS 2/1/0)

DECISION MAKING: DECISION PROCESSES; ANALYSIS OF COMPETING HYPOTHESES (ACH); PHYSIOLOGICAL BASIS OF THE DECISIONAL PROCESSES; BRAIN; COGNITIVE BIASES
(LECTURE / PRACTICE / LABORATORY HOURS 3/3/0)

DECISIONAL INFORMATION SYSTEMS: BUSINESS PROCESSES; MANAGERIAL PERSPECTIVES OF SIMON; ANTHONY’S PYRAMID; ACTIVITY-DECISION GRID OF GORRY AND SCOTT-MORTON; INTRODUCTION TO THE PROCESSES OF ANALYSIS AND KNOWLEDGE MANAGEMENT IN THE DIGITAL TRANSFORMATION ERA; KNOWLEDGE LIFECYCLE IN THE INDUSTRY 4.0 ECOSYSTEM
(LECTURE / PRACTICE / LABORATORY HOURS 3/0/0)

PROCESSING OF EXPLICIT KNOWLEDGE IN A STRUCTURED FORMAT AND THE KINDS OF INFORMATION AND ELABORATION SYSTEMS: TPS; MIS; DSS; BUSINESS INTELLIGENCE; OLAP TECHNOLOGY; DATA WAREHOUSE AND DATA MART; THE MAIN ARCHITECTURES FOR DATA WAREHOUSING (GENERAL, INMON, AND KIMBAL)
(LECTURE / PRACTICE / LABORATORY HOURS 3/0/0)

DATA WAREHOUSE/BUSINESS INTELLIGENCE SYSTEMS: DIMENSIONAL LIFECYCLE; ARCHITECTURE AND ELEMENTS OF A DW/BI SYSTEM; THE ETL SUBSYSTEM (DATA CLEANING; DATA INTEGRATION; DATA TRANSFORMATION; DATA REDUCTION); THE DIMENSIONAL MODEL (MEASURES; FACTS; CONTEXTS; DIMENSIONS)
(LECTURE / PRACTICE / LABORATORY HOURS 9/0/0)

CASE STUDY: DESIGN AND DEVELOPMENT OF DIMENSIONAL SCHEMAS
(LECTURE / PRACTICE / LABORATORY HOURS 0/6/0)

DECISION SUPPORT SYSTEMS: MAIN ARCHITECTURES (DATA-DRIVEN; MODEL-DRIVEN; KNOWLEDGE-DRIVEN; DOCUMENTATION-DRIVEN; COMMUNICATION-DRIVEN; SITUATION AWARENESS-DRIVEN)
(LECTURE / PRACTICE / LABORATORY HOURS 6/0/0)

CASE STUDY (DATA WAREHOUSES; ASSOCIATION RULES; A CONTEXT SPACE THEORY-BASED DSS; CONSENSUS-BASED GROUP DECISION MAKING; FUZZY-BASED USER SIGNATURE)
(LECTURE / PRACTICE / LABORATORY HOURS 0/12/0)

TOTAL LECTURE / PRACTICE / LABORATORY HOURS 26/22/0
Teaching Methods
THE COURSE IS CHARACTERIZED BY A DYNAMIC SETTING, RICH IN CASE STUDIES, WITH EXERCISES FOR THE APPLICATION OF DECISIONAL TECHNIQUES.
Verification of learning
THE EXAM CONSISTS OF AN ORAL EXAMINATION. THE ORAL EXAMINATION AIMS AT VERIFYING THE KNOWLEDGE RELATED TO THE ARGUMENTS OF THE COURSE AND FORESEES THE EXECUTION OF EXERCISES ON THE DESIGN OF DIMENSIONAL SCHEMAS OF DATA WAREHOUSE AND THE USE OF DECISION-SUPPORT TECHNIQUES AND THE DISCUSSION ON THESE EXERCISES WITH REFERENCES TO THE ARGUMENTS OF THE COURSE AND IN PARTICULAR: DECISION SUPPORT TECHNIQUES AND PROCESSES, MODELS AND ARCHITECTURES OF DATA WAREHOUSES AND DSS PRESENTED DURING THE COURSE. IT WILL BE EVALUATED, BESIDE THE ACCURACY OF THE ANSWERS AND THE RESOLUTION OF THE EXERCISES, ALSO THE SKILL OF THE LEARNER REGARDING THE PRESENTATION AND COMMUNICATION OF THE ANSWERS, THE SKILLS OF THE STUDENT TO MASTER THE LANGUAGE, THE METHODOLOGIES, AND THE TECHNIQUES USED IN THE REALIZATION OF THE EXERCISES.
Texts
REFERENCES TEXTS
REZZANI A., “BUSINESS INTELLIGENCE. PROCESSI, METODI, UTILIZZO IN AZIENDA”. APOGEO, 2012
M. GOLFARELLI, S. RIZZI “DATA WAREHOUSE. TEORIA E PRATICA DELLA PROGETTAZIONE”. MCGRAW-HILL.
G. BRACCHI, C. FRANCALANCI E G. MOTTA. “SISTEMI INFORMATIVI D’IMPRESA”. MCGRAW-HILL (CHAPTER 2; CHAPTER 6 AND CHAPTER 9)
CONSULTATION TEXTS
M. GOLFARELLI; S. RIZZI. “DATA WAREHOUSE DESIGN: MODERN PRINCIPLES AND METHODOLOGIES”. MCGRAW-HILL EDUCATION
R. KIMBALL. M. ROSS “THE DATA WAREHOUSE TOOLKIT: THE DEFINITIVE GUIDE TO DIMENSIONAL MODELING”. WILEY
P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE “BASI DI DATI – QUINTA EDIZIONE” MCGRAW-HILL ITALIA ISBN: 9788838668005 (CHAPTER 17)
DANIEL J. POWER. “DECISION SUPPORT SYSTEM: CONCEPTS AND RESOURCES FOR MANAGERS”; QUORUM
More Information
THE COURSE IS HELD IN ITALIAN

THE TEACHING MATERIAL IS AVAILABLE ON THE UNIVERSITY E-LEARNING PLATFORM (HTTP://ELEARNING.UNISA.IT) ACCESSIBLE TO STUDENTS USING THEIR OWN UNIVERSITY CREDENTIALS.
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2022-11-21]