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
mds:lbi:start [12/11/2021 alle 01:29 (2 mesi fa)]
Anna Monreale [Class calendar - (2021-2022)]
mds:lbi:start [12/01/2022 alle 09:58 (5 giorni fa)] (versione attuale)
Anna Monreale [Exams]
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). 
   * [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.
   * [15/10/2021] **IMPORTANT** The first part of the project is available. Checkpoint: 15 November.   * [15/10/2021] **IMPORTANT** The first part of the project is available. Checkpoint: 15 November.
Linea 121: Linea 123:
 |8. | 14.10 9:00-10:45 |Stratified sampling | {{ :mds:lbi:lds.07.sqlserver.pdf |}} |  {{ :mds:lbi:stratifiedsampling.zip |}}|   |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lectures-20211014_090430-Registrazione%20della%20riunione.mp4?csf=1&web=1&e=XxhSv7|Video]] | Pellungrini|  |8. | 14.10 9:00-10:45 |Stratified sampling | {{ :mds:lbi:lds.07.sqlserver.pdf |}} |  {{ :mds:lbi:stratifiedsampling.zip |}}|   |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lectures-20211014_090430-Registrazione%20della%20riunione.mp4?csf=1&web=1&e=XxhSv7|Video]] | Pellungrini| 
 |9. | 18.10 12:00-12:45 | ETL Introduction | {{ :mds:lbi:lds.08.etlandssis.pdf |}} |  |   |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lecture-20211018_121039-Registrazione%20della%20riunione.mp4?csf=1&web=1&e=Nq6CMT|Video]] | Monreale|  |9. | 18.10 12:00-12:45 | ETL Introduction | {{ :mds:lbi:lds.08.etlandssis.pdf |}} |  |   |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lecture-20211018_121039-Registrazione%20della%20riunione.mp4?csf=1&web=1&e=Nq6CMT|Video]] | Monreale| 
-|10. | 21.10 9:00-10:45 | SSIS: toCSV, FromCSV |  | {{ :mds:lbi:2021-lds-etl-project.zip |}} |  | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lectures-20211021_091055-Registrazione%20della%20riunione.mp4|Video]]| Monreale  |+|10. | 21.10 9:00-10:45 | SSIS: toCSV, FromCSV |  | {{ :mds:lbi:2021-lds-etl-project.zip |}} |  | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lectures-20211021_091055-Regi{{ :mds:lbi:foodmart_monreale_full.zip |}}strazione%20della%20riunione.mp4|Video]]| Monreale  |
 |11. | 25.10 11:00-12:45 |SSIS exercises: Pipeline, Update |  {{ :mds:lbi:exercisefact_table.pdf |}} |  |  | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lecture-20211025_110645-Registrazione%20della%20riunione.mp4|Video]]| Monreale  | |11. | 25.10 11:00-12:45 |SSIS exercises: Pipeline, Update |  {{ :mds:lbi:exercisefact_table.pdf |}} |  |  | [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/LDS%20Lecture-20211025_110645-Registrazione%20della%20riunione.mp4|Video]]| Monreale  |
 |12. | 28.10 9:00-10:45  | SSIS exercises: Stratified Subsampling | {{ :mds:lbi:ex-midterm.pdf |}} |  |  |   | Monreale  | |12. | 28.10 9:00-10:45  | SSIS exercises: Stratified Subsampling | {{ :mds:lbi:ex-midterm.pdf |}} |  |  |   | Monreale  |
 |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  |  |{{ :mds:lbi:2021-lds-etl-project_full.zip |}}  |  |   | 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: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.|  | {{ :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|  | | | | | 
 + 
 +  
 + 
  
 ====== Exams ====== ====== Exams ======
Linea 140: 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 **
-Students who did not deliver the above project within 31 December 2021 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work and after the delivery it 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.+Students who did not deliver the above project within 31 December 2021 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work and after the delivery it 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 both teachers!**
  
  
mds/lbi/start.1636680555.txt.gz · Ultima modifica: 12/11/2021 alle 01:29 (2 mesi fa) da Anna Monreale