| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| mds:lbi:start [02/12/2024 alle 10:03 (4 mesi fa)] – [Class calendar - (2024-2025)] Anna Monreale | mds:lbi:start [03/02/2025 alle 23:27 (8 settimane fa)] (versione attuale) – [Exam sessions] Anna Monreale |
|---|
| |26.11| Introduction to SSAS + DW|{{ :mds:lbi:2024-lds.09.dwandolap.pdf |DW and OLAP}} | | | | |26.11| Introduction to SSAS + DW|{{ :mds:lbi:2024-lds.09.dwandolap.pdf |DW and OLAP}} | | | |
| |27.11| Olab Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf | SSAS }} |{{ :mds:lbi:foodmart_monreale_full-2024.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. As an alternative solution you mayimport the project from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).| | | |27.11| Olab Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf | SSAS }} |{{ :mds:lbi:foodmart_monreale_full-2024.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. As an alternative solution you mayimport the project from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).| | |
| |28.11|Metrics + Excel power pivot integration | | | | | |28.11|Metrics + Excel power pivot integration | | {{ :mds:lbi:foodmart_monreale_complete-2024.zip |}}| | |
| |03.12| | | | | | |03.12| MDX Queries| Same slides as in the previous lectures | {{ :mds:lbi:query-samples.zip |}}| | |
| |04.12| | | | | | |04.12| MDX Queries| Same slides as in the previous lectures | | | |
| |05.12| | | | | | |05.12| MDX Queries| Same slides as in the previous lectures | {{ :mds:lbi:2024-12-05-queries-demomdx.zip | new version of the query samples}} | | |
| |11.12| | | | | | |11.12| MDX Queries| | | | |
| |12.12| | | | | | |12.12| PowerBI + MDX practice| {{ :mds:lbi:2024-12-12-queries-demomdx.zip | File updated with new queries}}| {{ :mds:lbi:mdxqueryies-to_besolved.txt.zip |Queries to be solved}}| | |
| |13.12| **No lesson in this date.** | | | | | |13.12| **No lesson in this date.** | | | | |
| |18.12| Aula C 1400-16:00| | | | | |18.12| Room C 1400-16:00| | | | |
| ====== Exams ====== | ====== Exams ====== |
| |
| * **Dataset:** [[https://drive.google.com/file/d/1FzGqHC0urBhbXUhYQrjbLEhR9CqovOm8/view?usp=sharing|Link]] | * **Dataset:** [[https://drive.google.com/file/d/1FzGqHC0urBhbXUhYQrjbLEhR9CqovOm8/view?usp=sharing|Link]] |
| * First part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_1_20241126.pdf | Project Part 1 (updated 26/11/2024)}}. **Deadline**: 05/12/2024 | * First part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_1_20241126.pdf | Project Part 1 (updated 26/11/2024)}}. **Deadline**: 05/12/2024 |
| * Second part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_2_20241128.pdf | Project Part 2 (updated 28/11/2024)}}. **Deadline**: 27/12/2024 | * Second part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_2_20241218.pdf | Project Part 2 (updated 18/12/2024)}}. **Deadline**: 05/01/2025 (extended) |
| | |
| **Project to be delivered during the exam sessions ** | **Project to be delivered during the exam sessions ** |
| Students who did not deliver the above project by 27/12/2024 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work. After the delivery, the project 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!** | Students who did not deliver the above project by 05/01/2025 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work. After the delivery, the project 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!** |
| |
| |
| * 31 Jan | * 31 Jan |
| * 03 Feb | * 03 Feb |
| | * 04 Feb |
| * 14 Feb | * 14 Feb |
| * 17 Feb | |
| * 19 Feb | |
| * 20 Feb | * 20 Feb |
| * 21 Feb | * 21 Feb |
