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 revisioneRevisione precedente
mds:lbi:start [09/11/2026 alle 18:35 (6 giorni fa)] – [Class calendar - (2026-2027)] Anna Monrealemds:lbi:start [09/11/2026 alle 18:36 (6 giorni fa)] (versione attuale) – [Class calendar - (2026-2027)] Anna Monreale
Linea 74: Linea 74:
 |12. |03.11| SSIS:SCD, Surrogate Keys | {{ :mds:lbi:2026-lds-ssis-sk.zip |SSIS Project for SK}}  |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_72114/_layouts/15/stream.aspx?id=%2Fsites%2Fa%5F%5Ftd%5F72114%2FShared%20Documents%2FModule%20II%20%2D%20Laboratory%20of%20Data%20Science%2FRecordings%2F12%2D2026%2DLDS%2D2026%2D11%2D03%2Emp4&share=cQryy2qblaasRqjXa3xtAJ0wEgUBuAV4cd80CxGyePhYafzanA|Video]] | | Monreale| |12. |03.11| SSIS:SCD, Surrogate Keys | {{ :mds:lbi:2026-lds-ssis-sk.zip |SSIS Project for SK}}  |[[https://unipiit.sharepoint.com/:v:/r/sites/a__td_72114/_layouts/15/stream.aspx?id=%2Fsites%2Fa%5F%5Ftd%5F72114%2FShared%20Documents%2FModule%20II%20%2D%20Laboratory%20of%20Data%20Science%2FRecordings%2F12%2D2026%2DLDS%2D2026%2D11%2D03%2Emp4&share=cQryy2qblaasRqjXa3xtAJ0wEgUBuAV4cd80CxGyePhYafzanA|Video]] | | Monreale|
 |13. |05.11| SSIS: completed the Surrogate Keys Exercise + Correction of Stratified Sampling | same slides as previous lecture {{ :mds:lbi:2026-lds-ssis-sk.zip |SSIS Project for SK}}| [[https://unipiit.sharepoint.com/:v:/r/sites/a__td_72114/_layouts/15/stream.aspx?id=%2Fsites%2Fa%5F%5Ftd%5F72114%2FShared%20Documents%2FModule%20II%20%2D%20Laboratory%20of%20Data%20Science%2FRecordings%2F13%2D2026%2DLDS%2D20261105%2Emp4&share=cQq8yyCvv2W8QpQ%5FXo0IPJZ6EgUBRRlu5R89%2DoCVOZp1Bya3Wg|VideoStratfiedSampling]] The video on the SK unfortunately is corrupted| |Monreale, Landi| |13. |05.11| SSIS: completed the Surrogate Keys Exercise + Correction of Stratified Sampling | same slides as previous lecture {{ :mds:lbi:2026-lds-ssis-sk.zip |SSIS Project for SK}}| [[https://unipiit.sharepoint.com/:v:/r/sites/a__td_72114/_layouts/15/stream.aspx?id=%2Fsites%2Fa%5F%5Ftd%5F72114%2FShared%20Documents%2FModule%20II%20%2D%20Laboratory%20of%20Data%20Science%2FRecordings%2F13%2D2026%2DLDS%2D20261105%2Emp4&share=cQq8yyCvv2W8QpQ%5FXo0IPJZ6EgUBRRlu5R89%2DoCVOZp1Bya3Wg|VideoStratfiedSampling]] The video on the SK unfortunately is corrupted| |Monreale, Landi|
-|14. |11.11| SCD workflow for new customers | | | +|14. |11.11| SSIS practice| | | 
-|15. |17.11| SCD workflow for update customers + SSIS practice | | | +|15. |17.11| SCD workflow for new customers + update customers | | | 
-|16. |19.11| SSIS practice + CDC Process + + PROJECT CHECK **MANDATORY** | | |+|16. |19.11| SSIS practice + CDC Process + PROJECT CHECK **MANDATORY** | | |
 |17. |24.11| Introduction to SSAS + DW | | | 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. |24.11| Introduction to SSAS + DW | | | 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 |
 |18. |25.11| Olap Cube| 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. |25.11| Olap Cube| 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.|  
mds/lbi/start.txt · Ultima modifica: da Anna Monreale

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki