Differenze

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

--- mds:lbi:start [14/12/2025 alle 22:50 (5 settimane fa)] – [Class calendar - (2025-2026)] Anna Monreale
+++ mds:lbi:start [18/12/2025 alle 15:17 (4 settimane fa)] (versione attuale) – [Exams] Anna Monreale
@@ Linea 57: / Linea 57: @@
   * [[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 - (2025-2026) ======
-^N. ^ Day  ^Room ^ Topic ^Lecture Material ^ Video Lectures ^
+^N. ^ Day  ^Room ^ Topic ^Lecture Material ^ Video Lectures ^ Refs ^
-|1.|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 |}} | |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDh0G1PpN6sT6CsDcFP6rcCARFDfU1sHLWvevsVzH__aYI?e=VVvwW7|Video]] |
+|1.|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 |}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDh0G1PpN6sT6CsDcFP6rcCARFDfU1sHLWvevsVzH__aYI?e=VVvwW7|Video]] |-** BI technology:** [[https://cacm.acm.org/magazines/2011/8/114953-an-overview-of-business-intelligence-technology/fulltext | An Overview of Business Intelligence Technology]] - **File access:** {{ :mds:lbi:filesystem.pdf | File System Interface}}   |
-|2.|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}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDpwaIIRE7kR59OFasMQnGrARRFlLnNYNHuccTtZXQ6vdU?e=3nhEFt|File data access]] [[https://tinyurl.com/337t8hxf|Python Recap (from previous years)]] |
+|2.|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}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDpwaIIRE7kR59OFasMQnGrARRFlLnNYNHuccTtZXQ6vdU?e=3nhEFt|File data access]] [[https://tinyurl.com/337t8hxf|Python Recap (from previous years)]] |  - **File Formats:** [[http://www.stat.auckland.ac.nz/~paul/ItDT | Introduction to data technologies(Chps. 5, 6)]],  [[http://weka.wikispaces.com/ARFF+(stable+version)|Weka ARFF Format]], [[http://weka.wikispaces.com/XRFF|XRFF Format]] - **Python reference:** [[https://www.spronck.net/pythonbook/ | Free python book with exercises]] |
 |3.|22.10| |Project Presentation + Python Excercises + File Access in Python |{{ :mds:lbi:2025-lds.05.fileaccess-python.pdf |}} {{ :mds:lbi:2025-10-23-code.zip |}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQB5nDV9rjo7SrjShEp85YBPAbPYpxpTrq7LGKmthX-kE6w?e=KrlfP9|Project Presentation]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBEFtKr75UVQYDVYHjE7LHYAbL0XEMoA2aCGHvphTEg73Q?e=M8fUNQ|File access Py]]|
 |4.|29.10| |Python File Access + Exercises | same slides used in the previous lecture{{ :mds:lbi:data1.zip | Data ex files}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDMPfG7S6G0QKu3-hvN1pRNAZiDPUVuXhHlDjeQlD6-qX8?e=W2T6zj|Video]]  |
@@ Linea 74: / Linea 74: @@
 |14.|25.11|Lab H  | SSIS practice + Solutions of Dissimilarity and MPD| | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQAS8i9_GYxyTax_x1t8OdgJARZVvDauNw62C8e4gdPN9zo?e=JcJ7ma|Video]]|
 |15.|26.11|Lab I  | CDC Process  |  | |
-|16.|27.11|Fib C  | Introduction to SSAS + DW | {{ :mds:lbi:2024-lds.09.dwandolap.pdf | SSAS Intro}} | |
+|16.|27.11|Fib C  | Introduction to SSAS + DW | {{ :mds:lbi:2024-lds.09.dwandolap.pdf | SSAS Intro}} | |1) SSAS (olap): documentation; 2) S. Harinath et al. Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX, Wrox publisher, 2012. Chps. 4-6 |
-|17.|28.11|Lab H  | Olap Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf |slides}}|{{ :mds:lbi:foodmart_monreale_full_2025.zip |}} Instructions for the SSAS project: to avoid conflicts in deployment/process follow this steps once the solution is opened: (1) rename the project as <your account>_foodmart (2) from project properties select 'Deployment', then rename the database as <your account>_foodmart; (3) click on the button “show all files” just above “Solution explorer” right click on “view code” on the .database file that is visualized, and then change the ID from current name into <your account>_foodmart, and finally save the file. (4) change the credentials of connection to database on SQL Server.|
+|17.|28.11|Lab H  | Olap Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf |slides}}{{ :mds:lbi:foodmart_monreale_full_2025.zip |}} Instructions for the SSAS project: to avoid conflicts in deployment/process follow this steps once the solution is opened: (1) rename the project as <your account>_foodmart (2) from project properties select 'Deployment', then rename the database as <your account>_foodmart; (3) click on the button “show all files” just above “Solution explorer” right click on “view code” on the .database file that is visualized, and then change the ID from current name into <your account>_foodmart, and finally save the file. (4) change the credentials of connection to database on SQL Server.|
 |18.|02.12|Lab H  | PROJECT CHECK -MANDATORY |  | |
 |19.|03.12|  | Metrics + Excel power pivot integration	|  Same slides as in the previous lectures	|
@@ Linea 81: / Linea 81: @@
 |21.|09.12|Lab H  | MDX Queries	| Same slides as in the previous lectures	|
 |22.|10.12|Lab H | MDX Queries	|  Same slides as in the previous lectures	|
-|23.|12.12|Lab H  | Strike |  |
+|  |12.12|Lab H  | Strike |  |
-|24.|17.12|Lab H  | PowerBI + MDX practice|  Same slides as in the previous lectures|
+|23.|17.12|Lab H  | PowerBI + MDX practice|  Same slides as in the previous lectures|
@@ Linea 99: / Linea 99: @@
 The project has to be performed by a team of 3 students.
-  * Project assignments: {{ :mds:lbi:lds_project_2025-2026.pdf | LDS Project 2025-26}}
+  * Project assignments: {{ :mds:lbi:lds_project_2025-2026_-_20251218.pdf | LDS Project 2025-26 **Updated dec 18th 2025**}}
   * Data: [[https://unipiit-my.sharepoint.com/:u:/g/personal/c_landi7_studenti_unipi_it/EZPEZTUo4ZBDqAbPfp3uGXUBFph9TafaN7o4oSlrz6GE6w?e=EZCAYM|Data]]