Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

--- mds:lbi:start [25/09/2025 alle 16:58 (9 giorni fa)] – [Class calendar - (2024-2025)] Anna Monreale
+++ mds:lbi:start [02/10/2025 alle 09:17 (3 giorni fa)] (versione attuale) – [Class calendar - (2025-2026)] Anna Monreale
@@ Linea 8: / Linea 8: @@
     * [[http://pages.di.unipi.it/amonreale/]]
     * [[anna.monreale@unipi.it]]
-    * Office hours: Tuesday: 11:00-13:00 online using Teams or at the Department of Computer Science, room 374/E (Please ask for an appointment by email).
+    * Office hours: Friday: 14:30-15:30 online using Teams or at the Department of Computer Science, room 374/E (Please ask for an appointment by email).
     * Telephone +39-050-2213119
@@ Linea 16: / Linea 16: @@
     * Office hours: Wednesday: 14:00-16:00 online using Teams or at the Department of Computer Science, room 343 (Please ask for an appointment by email).
-**If you are not asking for office hours, always email both instructors and include [LDS] at the beginning of the subject line.**
+**Always email both instructors and include [LDS] at the beginning of the subject line.**
@@ Linea 22: / Linea 22: @@
 ^  Day of Week  ^  Hour  ^  Room  ^
-|  Tuesday  |  9:00 - 11:00  |  Fib H-Lab   |
+| Tuesday | 9:00 - 11:00 | Fib H-Lab |
-|  Wednesday| 11:00 - 13:00  |  Fib C1 |
+| Wednesday | 11:00 - 13:00 | Fib C1 |
-|  Thursday | 11:00 - 13:00  |  Fib C  |
+| Thursday | 11:00 - 13:00 | Fib C |
-|  Friday  |  09:00 - 11:00  |  Fib C  |
+| Friday | 09:00 - 11:00 | Fib C |
-A [[https://teams.microsoft.com/l/channel/19%3Aead0080c194243dbabdc9ef2b826d701%40thread.tacv2/Module%20II%20-%20Laboratory%20of%20Data%20Science?groupId=a9d127ae-4a11-4a6b-a045-555d1bab8b85&tenantId=c7456b31-a220-47f5-be52-473828670aa1|Teams channel]] is used 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 from this or the previous years will be made available for non-attending students. The recording publication could receive some delays (one week of delays),
+A [[https://teams.microsoft.com/l/channel/19%3Aead0080c194243dbabdc9ef2b826d701%40thread.tacv2/Module%20II%20-%20Laboratory%20of%20Data%20Science?groupId=a9d127ae-4a11-4a6b-a045-555d1bab8b85&tenantId=c7456b31-a220-47f5-be52-473828670aa1|Teams channel]] is used to post news, Q&A, and other stuff related to the course. The lectures will be only in person and will **NOT** be live-streamed, but recordings of the lecture from this or the previous years will be made available for non-attending students. The recording publication could receive some delays (one week of delays).
 ====== Learning Material ======
@@ Linea 42: / Linea 42: @@
 ===== Software=====
-  * Anaconda (Please avoid Python 3.12)
+  * Anaconda
- * Microsoft Excel
+  * SQL Server 2019 Management Studio or newer:[[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16|SQL Server 2019 Management Studio]].
+  * Visual Studio Community 2022. Install/include SSDT workload in the installation manager of Visual Studio: instructions Italian: [[https://learn.microsoft.com/it-it/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-visual-studio-2022|Data Tools Visual Studio 2022 IT]] English: [[https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-visual-studio-2022|Data Tools Visual Studio 2022 EN]].
+  * Microsoft Excel
   * [[https://powerbi.microsoft.com/it-it/desktop/| Power BI Desktop]]
+  * [[https://start.unipi.it/help-ict/vpn/ | Unipi VPN ]]
+**Note**: preconfigured virtual machines will be available to download in the Teams channel for both AMD64 (Intel/AMD) and ARM (Apple Silicon) architectures. The virtual machines come with all the required software installed and tested, except for Microsoft Excel: you can download it for free from [[http://office.com|office.com]] using your University credentials.
 ===== F.A.Q. =====
@@ Linea 52: / Linea 56: @@
   * [[https://start.unipi.it/help-ict/vpn/ | Unipi VPN ]]
   * [[https://autenticazione.unipi.it/auth/auth.signin | Unipi Authentication]] to access the VPN, make sure that network access services are enabled on your profile. Follow this link to access your Unipi profile.
-====== Class calendar - (2024-2025) ======
+====== Class calendar - (2025-2026) ======
-^ Day  ^ Topic ^ Slides  ^ Data/Software ^ Video Lectures ^
+^ Day  ^ Topic ^ Slides  ^ Data/Code ^ Video Lectures ^
-|01.10| Introduction to the Course. BI Architectures. File data access. |  |  |  |
+|01.10| Introduction to the Course. BI Architectures. File data access. |{{ :mds:lbi:2025-lds.01.introduction.pdf |}} {{ :mds:lbi:2025-lds.02.bi_architectures.pdf |}} {{ :mds:lbi:2025-lds.03.file_data_access.pdf |}}| |  |
+|02.10| File data access. Python Recap. | {{ :mds:lbi:2025-lds.04.python_no_hint.pdf | Python Recap}} | {{ :mds:lbi:2024-lds.04_supplementary.code.zip | supplementary code}} |
+|14.10| Python Exercises.  Python File Access | |  |
 ====== Exams ======
-__//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 or written test with discussion on the topics of the second module (50% of the final grade). See [[mds:dsd:start|Module I: Decision Support Databases]] for the theory part. **The project of Module II can be discussed only after passing Module I and not later than one year since then.**
+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 or written test with discussion on the topics of the second module (50% of the final grade). See [[mds:dsd:start|Module I: Decision Support Databases]] for the theory part. **The project of Module II can be discussed only after passing Module I and not later than one year since then.**
 The lab project has to be submitted within the specified deadline that will be communicated asap.
@@ Linea 65: / Linea 73: @@
 **PROJECT **
-A project consists of a set of assignments corresponding to a BI process: data integration, construction of an OLAP cube, querying of the OPLAP cube, and reporting.
+A project consists of a set of assignments corresponding to a BI process: data integration, construction of an OLAP cube, querying of the OLAP cube, and reporting.
 The project has to be performed by a team of 3 students.
@@ Linea 78: / Linea 86: @@
 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
+**Important:** The date of the discussion of the lab project will be communicated to you by the instructors. The dates reported in the
-[[https://esami.unipi.it/esami2/|registration website]] regard **only** the written part of the DSD module.
+[[https://esami.unipi.it/esami2/|registration website]] refear **only** the written part of the DSD module.
-**Oral Exam Date for LDS during the Winter Sessions:**
+**Oral Exam Date for LDS during the Winter Sessions:** TBD
 =====Past Editions =====