Strumenti Utente

Strumenti Sito


mds:lbi:start

Differenze

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

Link a questa pagina di confronto

Entrambe le parti precedenti la revisione Revisione precedente
Prossima revisione
Revisione precedente
Prossima revisione Entrambe le parti successive la revisione
mds:lbi:start [18/11/2021 alle 10:53 (2 anni fa)]
Anna Monreale [Class calendar - (2021-2022)]
mds:lbi:start [09/12/2021 alle 10:06 (2 anni fa)]
Anna Monreale [Class calendar - (2021-2022)]
Linea 67: Linea 67:
     * Telephone +39-050-2212728     * Telephone +39-050-2212728
 ====== News ===== ====== News =====
 +  * [01-12-2021]: Third and final part of the project is up
   * [16-11-2021]: Instructions for the SSAS project in the Lecture of today: 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 ruggieri_foodmart 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).    * [16-11-2021]: Instructions for the SSAS project in the Lecture of today: 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 ruggieri_foodmart 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). 
   * [15/10/2021] Instructions for installing Data Tools for Visual Studio 2019 are in the software section of the wiki. Please follow them closely, step by step.   * [15/10/2021] Instructions for installing Data Tools for Visual Studio 2019 are in the software section of the wiki. Please follow them closely, step by step.
Linea 127: Linea 128:
 |13. | 04.11 9:00-10:45  | Project Support & Discussion |  |  |  |   | Monreale  | |13. | 04.11 9:00-10:45  | Project Support & Discussion |  |  |  |   | Monreale  |
 |14. | 08.11 11:00-12:45  | SSIS: Surrogate keys + Slowly changing dimensions |  |  |  |   | Monreale  | |14. | 08.11 11:00-12:45  | SSIS: Surrogate keys + Slowly changing dimensions |  |  |  |   | Monreale  |
-|15. | 11.11 9:00-10:45  | SSIS: Slowly changing dimensions + Datawarehousing and OLAP recap. | {{ :mds:lbi:lds.09.dwandolap.pdf |}}  | |  |   | Monreale +|15. | 11.11 9:00-10:45  | SSIS: Slowly changing dimensions + Datawarehousing and OLAP recap. | {{ :mds:lbi:lds.09.dwandolap.pdf |}}  | {{ :mds:lbi:2021-lds-etl-project_full.zip |}}  |  |   | Monreale 
-|16. | 15.11 11:00-12:45  |  OLAP with SQL Server Analysis Services (SSAS): data source views, dimensions, hierarchies. Data cubes, Parent-child hierarchies. | {{ :mds:lbi:lds.09.ssas-21.pdf |}} | {{ :mds:lbi:2021-lds-etl-project_full.zip |}}  |  |   | Monreale +|16. | 15.11 11:00-12:45  |  OLAP with SQL Server Analysis Services (SSAS): data source views, dimensions, hierarchies. Data cubes, Parent-child hierarchies. | {{ :mds:lbi:lds.09.ssas-21.pdf |}} | {{ :mds:lbi:foodmart_monreale_full-cube.zip |}} |  |   | Monreale 
-|17. | 18.11 11:00-12:45  |  Cube deployment. Measure setup, Calculated Members, Excel power pivot integration. ROLAP, MOLAP, HOLAP definition and setup. Cache management.|  | |  |   | Pellungrini  |+|17. | 18.11 11:00-12:45  |  Cube deployment. Measure setup, Calculated Members, Excel power pivot integration. ROLAP, MOLAP, HOLAP definition and setup. Cache management.| {{ :mds:lbi:foodmartexplorative.xlsx |}} {{ :mds:lbi:foodmart_monreale_complete.zip |}}|  |   | Monreale 
 +|18. |  22.11 11:00-12:45 | Introduction to MDX |  | {{ :mds:lbi:2021-mdxquery-demo-partial.mdx.zip |}}| |  Since the video of this lecture has some issue I'm linking the Video of the last year. It is not exactly equal but very similar. The videos are two because the lectures of these year could not be completely aligned. [[https://web.microsoftstream.com/video/691fe567-b0f9-4994-8ec8-1b4dc5a3d9c4 | Video1]] [[https://web.microsoftstream.com/video/f1392414-f329-4769-9475-cb3457dbd712|Video2]]| Monreale | 
 +|19. |  25.11 09:00-11:00 | Practice on MDX | Exercises to be done before next lecture: 1) Queries you have already answered by Excel in Lecture N.17 2) This list of queries: {{ :mds:lbi:mdx-ex.pdf |}} |  {{ :mds:lbi:2021-mdxquery-demo.mdx.zip |}}  | | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/General-20211125_091132-Registrazione%20della%20riunione.mp4?web=1|Video 1]] [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/General-20211125_103239-Registrazione%20della%20riunione.mp4?web=1|Video 2]] | Monreale|  
 +|20. |  29.11 11:00-12:45 | Practice on MDX |  |  {{ :mds:lbi:lbi.09.mdxpractice.mdx.zip |}}  | | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lecture-20211129_111215-Registrazione%20della%20riunione.mp4?web=1|Video 1]] | Pellungrini|  
 +|21. |  02.12 09:00-10:45 Practice on MDX |  | {{ :mds:lbi:mdx_exercises_2021.txt.zip |}} {{ :mds:lbi:mdxquerytop.mdx.zip |}} | | | | | 
 +|22. |  09.12 09:00-10:45 | Practice on MDX + PowerBI |  | | | | | 
 +|23. |  13.12 11:00-13:00 ROOM C| Lecture by Microstrategy|  | | | | | 
 +|24. |  16.12 09:00-10:45 | Lecture only ONLINE dedicated to Project discussion with groups|  | | | | | 
 + 
 + 
  
  
Linea 145: Linea 155:
   * A note about the first part of the project: for the 'language' attribute in the geography table, you should search for the necessary information elsewhere. Some examples are: http://download.geonames.org/export/dump/countryInfo.txt and http://www.fullstacks.io/2016/07/countries-and-their-spoken-languages.html   * A note about the first part of the project: for the 'language' attribute in the geography table, you should search for the necessary information elsewhere. Some examples are: http://download.geonames.org/export/dump/countryInfo.txt and http://www.fullstacks.io/2016/07/countries-and-their-spoken-languages.html
   * Second part of the project consist in the **assignments** described here:{{ :mds:lbi:lds_project_2021_part_2.pdf |}}   * Second part of the project consist in the **assignments** described here:{{ :mds:lbi:lds_project_2021_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_2021_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:data2021.zip |}}   * **Dataset:** {{ :mds:lbi:data2021.zip |}}
   * **Deadline**: First deadline - <del>15 Nov 2021</del> 22 Nov 2021   * **Deadline**: First deadline - <del>15 Nov 2021</del> 22 Nov 2021
 +  * **Deadline**: Second deadline - 10 Dec 2021
 +  * **Deadline**: Third deadline - 31 Dec 2021
  
 **Project to be delivered during the exam sessions ** **Project to be delivered during the exam sessions **
mds/lbi/start.txt · Ultima modifica: 22/03/2024 alle 21:21 (6 giorni fa) da Anna Monreale