This is the second module of Decision Support Systems (801AA, 12 ECTS), previously called Laboratory of Data Science (664AA, 6 ECTS).

Instructors:

• Anna Monreale
  • KDD Laboratory, Università di Pisa
  • http://pages.di.unipi.it/amonreale/
  • anna [dot] monreale [at] unipi [dot] it
  • Office hours: Tuesday: 11:00-13:00 online using Teams or at the Department of Computer Science, room 374/E (Please ask an appointment by email).
  • Telephone +39-050-2213119

• Cristiano Landi
  • KDD Laboratory, Univesità di Pisa
  • cristiano [dot] landi [at] phd [dot] unipi [dot] it
  • Office hours: Tuesday: 14:00-16:00 online using Teams or at the Department of Computer Science, room 343 (Please ask for an appointment by email).

Classes

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.

• The slides used in the course will be inserted in the calendar after each class.
• Recordings of each lecture will be made available for non-attending students.

• 2016/17 text, 2015/16 text and 2015/16 solution, 2014/15 text and 2014/2015 solution, 2013/14 text, 2012/13 text and 2012/13 solution.

• Anaconda with Python 3.7 (Please, avoid Python 3.8)
• SQL Server 2019 Developer Edition or next:SQL Server 2019 Management Studio.
• Visual Studio Community 2022. Install/include SSDT workload in installation manager of visual studio: instructions here Italian: Data Tools Visual Studio 2022 IT English: Data Tools Visual Studio 2022 EN.
• Microsoft Excel
• Power BI Desktop

Note: preconfigured virtual machines can be found in the Teams channel for both AMD64 (Intel/AMD) and ARM (Apple Silicon) architectures.

• Connection to wi-fi
• F.A.Q.s about the labs
• Unipi VPN
• Unipi Authentication to access the VPN, make sure that network access services are enabled on you profile. Follow this link to access your Unipi profile.

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).

PROJECT

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

• First part of the project consists in the assignments described here: lds_project_2023_part_1.pdf
• Second part of the project consist in the assignments described here: lds_project_2023_part_2.pdf
• Third part of the project consist in the assignments described here: lds_project_2023_part_3.pdf
• Remember to re-submit all three parts of the project with your third part, as specified in the document above.
• Dataset: lds_project_2023.zip
• Deadline: First deadline 15 November
• Deadline: Second deadline 8 December
• Deadline: Third deadline -

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 all teachers!

Registration to the written exam is mandatory (pay attention at the deadline for registering!): register here

Please indicate in the notes “Only Lab” for doing only the discussion of the lab project; “Only DSD” for doing only the written+oral part of the DSD module; or “DSD+Lab” for doing both.

Important: the date of the discussion of the lab project will be communicated to you. The dates at the registration website regard only the written part of the DSD module.

• Decision Support Systems - Module II (6 ECTS): LABORATORY OF DATA SCIENCE (2022/2023)
• LABORATORY OF DATA SCIENCE (2021/2022)
• LABORATORY OF DATA SCIENCE (2020/2021)
• LABORATORY OF DATA SCIENCE (2019/2020)
• LABORATORY OF DATA SCIENCE (2018/2019)
• BUSINESS INTELLIGENCE LAB (2017/2018)