| Entrambe le parti precedenti la revisione
Revisione precedente
Prossima revisione
|
Revisione precedente
|
mds:lbi:start [21/11/2023 alle 09:15 (5 mesi fa)]
Anna Monreale [Class calendar - (2023-2024)] |
mds:lbi:start [22/03/2024 alle 21:21 (6 settimane fa)] (versione attuale)
Anna Monreale [Class calendar - (2023-2024)] |
| |15. |08.11 14:00-16:00| Project Support | | | | | Monreale, Pellungrini, Landi | | |15. |08.11 14:00-16:00| Project Support | | | | | Monreale, Pellungrini, Landi | |
| |16. |14.11 09:00-11:00| DW + SSAS | {{ :mds:lbi:lds.09.dwandolap.pdf |}}{{ :mds:lbi:lds.09.ssas-21.pdf |}} | |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 | [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/EY9SV0IEiG1DieCGnwtqBYgBX7NTwx2h7CaudAGfLxkJ7w?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19&e=3T8EC4|video]] | Monreale, Landi | | |16. |14.11 09:00-11:00| DW + SSAS | {{ :mds:lbi:lds.09.dwandolap.pdf |}}{{ :mds:lbi:lds.09.ssas-21.pdf |}} | |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 | [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/EY9SV0IEiG1DieCGnwtqBYgBX7NTwx2h7CaudAGfLxkJ7w?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19&e=3T8EC4|video]] | Monreale, Landi | |
| |17. |15.11 14:00-16:00| Olab Cube | |{{ :mds:lbi:15-foodmart_monreale_full.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 may[[ http://technet.microsoft.com/en-us/library/ms175630.aspx#bkmk_newusingwizard|import the project]] from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).| | [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/Ed9j5fa7SMhMjX0tjXMLELwBHuFNgarGx8t1nL0OMxEO1Q?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1FbWFpbCIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19&e=NyAVmX|video]] | Monreale, Pellungrini, Landi | | |17. |15.11 14:00-16:00| Olab Cube | |{{ :mds:lbi:15-foodmart_monreale_full.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 may[[ http://technet.microsoft.com/en-us/library/ms175630.aspx#bkmk_newusingwizard|import the project]] from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).| | [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/Ed9j5fa7SMhMjX0tjXMLELwBHuFNgarGx8t1nL0OMxEO1Q?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1FbWFpbCIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19&e=NyAVmX|video]] | Monreale, Landi | |
| | | |21.11 09:00-11:00| Canceled | | | | | | |
| | |18. |22.11 14:00-16:00| OLAP Cube, Measure setup, Calculated Members, Excel power pivot integration. | same slides of the last lecture | {{ :mds:lbi:foodmart_monreale_full.zip |}}| |[[https://unipiit.sharepoint.com/:v:/s/a__td_61299/EZNRBOWu8f9Fg38SZVtOv6YBp9OuwidZIDDOsEjj9OSQqQ?e=CP6ZhH|Video]] | Pellungrini, Landi| |
| | |19. |28.11 09:00-11:00| Visual Studio advanced Features and MDX first examples | same slides of the last lecture | | |[[https://unipiit.sharepoint.com/:v:/s/Registrazioni628/EXAG2WGKbu9GiBB578Q-_TwBZRmzFHEwtXeBFpOFsykrBQ?e=rvABxQ&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D|Video]] | Pellungrini, Landi| |
| | |20. |29.11 14:00-16:00| MDX | | | | [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/EQWfqpb76wdHk-ih_3oIPjUB07CpXiy-NsgJl3fGPp1VtA?e=fAgBsa|Video1]] [[https://unipiit.sharepoint.com/:v:/s/a__td_61299/EQH0oiTu6OVDpt7NWZGiGogBkZHQafN4ZlX-jfD_1If0SQ?e=6yerN6|Video2]]| Pellungrini, Landi| |
| | |21. |05.12 09:00-11:00| MDX | {{ :mds:lbi:mdx-practice.zip |}} {{ :mds:lbi:msx-queries-generate.zip |}} | | | | Monreale| |
| | |22. |06.12 14:00-16:00| MDX Practice | {{ :mds:lbi:practice2.mdx.zip |}} | | | |Pellungrini| |
| | |23. |12.12 09:00-11:00| PowerBI, PowerPivot, MDX Practice| {{ :mds:lbi:mdxqueryies-12dec.mdx.zip |}} | | | |Monreale| |
| | |24. |13.12 14:00-16:00| MDX Practice + Project Discussion| see the file with mdx queries of the previous lecture | | | |Monreale, Pellungrini, Landi| |
| ====== Exams ====== | ====== 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 with discussion on the topics of the second module (50% of the final grade). For the rules of the first module visit the [[http://didawiki.di.unipi.it/doku.php/mds/dsd/start|Module I: Decision Support Databases]]. | //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 [[http://didawiki.di.unipi.it/doku.php/mds/dsd/start|Module I: Decision Support Databases]]. |
| * First part of the project consists in the **assignments** described here: {{ :mds:lbi:lds_project_2023_part_1.pdf |}} | * First part of the project consists in the **assignments** described here: {{ :mds:lbi:lds_project_2023_part_1.pdf |}} |
| * Second part of the project consist in the **assignments** described here: {{ :mds:lbi:lds_project_2023_part_2.pdf |}} | * Second part of the project consist in the **assignments** described here: {{ :mds:lbi:lds_project_2023_part_2.pdf |}} |
| * Third part of the project consist in the **assignments** described here: | * Third part of the project consist in the **assignments** described here: {{ :mds:lbi: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. | * Remember to re-submit all three parts of the project with your third part, as specified in the document above. |
| * **Dataset:** {{ :mds:lbi:lds_project_2023.zip |}} | * **Dataset:** {{ :mds:lbi:lds_project_2023.zip |}} |
| ===== Exam sessions ===== | ===== Exam sessions ===== |
| |
| ^ Session ^ Date ^ Time ^ Room ^ Notes ^ Marks ^ | Registration to the written exam is mandatory (**pay attention at the deadline for registering!**): [[https://esami.unipi.it/esami2/|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 |
| | [[https://esami.unipi.it/esami2/|registration website]] regard **only** the written part of the DSD module. |
| |
| =====Past Editions ===== | =====Past Editions ===== |
