This is the second module of Decision Support Systems (801AA, 12 ECTS), previously called Laboratory of Data Science ((664AA, 6 ECTS).
|Day of Week||Hour||Room|
|Tuesday||09:00 - 11:00||Room Lab. M|
|Wednesday||14:00 - 16:00||Room Lab. H|
A Teams channel will be used ONLY to post news, Q&A, and other stuff related to the course. The lectures will be only in presence and will NOT be live-streamed, but recordings of the lecture or of the previous years will be made available here for non-attending students.
|1.||19.09 09:00-11:00||Introduction to the Course. BI Architecture. File data access.||2023-lds.01.introduction.pptx2023-lds.02.bi_architectures.pptx2023-lds.03.file_data_access.pptx||- BI technology: An Overview of Business Intelligence Technology - File access: File System Interface||Video||Pellungrini|
|2.||20.09 14:00-16:00||Representation formats: CSV, FLV, ARFF, XML. Python Recap.||lds.04.python.pdf||- File Formats: Introduction to data technologies(Chps. 5, 6), Weka ARFF Format, XRFF Format - Python reference: Free python book with exercises||video||Pellungrini|
|3.||26.09 09:00-11:00||Python Recap. + Python Excercises||video1 Video2 video3||Monreale, Landi|
|4.||27.09 14:00-16:00||Python File Access + Exercises||data1.zip 270923solutions.zip||video||Pellungrini, Landi|
There are no mid-terms. The exam of Decision Support Systems (801AA, 12 ECTS) consists of a written part and an oral part on the topics of the first module (50% of the final grade), and a lab project with discussion on the topics of the second module (50% of the final grade). For the rules of the first module visit the Module I: Decision Support Databases. For details on the Lab project read with attention the next section. Module I and Module II must be passed at maximum distance of one year between them (they can be taken in any order).
A project consists in a set of assignements corresponding to a BI process: data integration, construction of an OLAP cube, qurying of a OPLAP cube and reporting.
The project has to be performed by a team of 2 students (at most 3 after asking authorization for that to the teachers).
Each part of the project must be documented with a brief pdf report (no more that 2/3 pages) describing your solution.
Project to be delivered within 31 December 2023
Project to be delivered during the exam sessions Students who did not deliver the above project within 31 December 2023 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work and after the delivery it will be discussed during the oral exam. For those students, the oral exams will also cover some practical parts that could not be included in the project. Please write to both teachers!