| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| mds:lbi:start [29/09/2026 alle 20:23 (5 settimane fa)] – [Class calendar - (2026-2027)] Anna Monreale | mds:lbi:start [02/11/2026 alle 23:52 (92 minuti fa)] (versione attuale) – [Class calendar - (2026-2027)] Anna Monreale |
|---|
| |3. |23.09| Python Excercises + File Access in Python | {{ :mds:lbi:2025-lds.05.fileaccess-python.pdf | File Access in Python}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQB5hSvgCXfUR7hpkpSDBrx-AVY3drYY8NEfoP7z_RM9kc4?e=97cy8e|Video]] | | Landi | | |3. |23.09| Python Excercises + File Access in Python | {{ :mds:lbi:2025-lds.05.fileaccess-python.pdf | File Access in Python}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQB5hSvgCXfUR7hpkpSDBrx-AVY3drYY8NEfoP7z_RM9kc4?e=97cy8e|Video]] | | Landi | |
| |4. |24.09| Python File Access + Exercises | {{ :mds:lbi:data1.zip | Data ex files}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQBJ7XV0JChoRZF8qh29hKwlAUEJXN-UWcDrtX5PIrzBDDk?e=0Sa8tu|Video]] | |Monreale, Landi| | |4. |24.09| Python File Access + Exercises | {{ :mds:lbi:data1.zip | Data ex files}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQBJ7XV0JChoRZF8qh29hKwlAUEJXN-UWcDrtX5PIrzBDDk?e=0Sa8tu|Video]] | |Monreale, Landi| |
| |5. |25.09| Python File Access + Exercises | {{ :mds:lbi:ex-customers.pdf |}} {{ :mds:lbi:data-customers.zip|}} {{ :mds:lbi:python_recap_and_data_access.zip | Exercise solutions}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQBa13C3bdnxS7TmtdaNRAOOAXlJjaHjbLDCRbp_X0uWEfs?e=wqyw4W&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D|Video Ex.]] [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQB28AlzNWUaRqWsFTGW7X40AecNTwsyWH_HpM88cOD8a2k?e=Y54mYW&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D|Project Presentation]]| | | | | |5. |25.09| Python File Access + Exercises + Project Presentation | {{ :mds:lbi:ex-customers.pdf |}} {{ :mds:lbi:data-customers.zip|}} {{ :mds:lbi:python_recap_and_data_access.zip | Exercise solutions}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQBa13C3bdnxS7TmtdaNRAOOAXlJjaHjbLDCRbp_X0uWEfs?e=wqyw4W&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D|Video Ex.]] [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQB28AlzNWUaRqWsFTGW7X40AecNTwsyWH_HpM88cOD8a2k?e=Y54mYW&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D|Project Presentation]]| | Monreale, Landi | |
| |6. |06.10| RDBMS access protocols + Python DB Access + Project Presentation | | | | | |6. |06.10| Exercise Corrections + RDBMS access protocols | {{ :mds:lbi:2024-lds.06.relational_data_access.pdf | Python DB Access}} {{ :mds:lbi:2025_excustomer_sol.zip | 2026_excustomer_sol}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQATQnqFb6szTrr_vN5OkBLSAdy4uGYE9bxEN35vA0z-v2s?e=a7tk8o|Video]] | | Landi, Monreale | |
| |7. |13.10| Exercises correction + Stratified sampling Exercise | | | | | |7. |13.10| Python DB Access + Demo DB access | {{ :mds:lbi:2026-db.zip |}}| [[https://unipiit.sharepoint.com/:v:/s/a__td_72114/IQBLAU_RVjrTQJq4E3AFmpOjAZzMN98rgY4Qk-KnmLspwsQ?e=Dm6PZs|Video]]| |Monreale, Landi | |
| |8. |20.10| Python DB Access: exercises | | | | |8. |20.10| Python DB Access: exercises | {{ :mds:lbi:ssis_dissimilarity_idx.pdf |Dissimilarity}} | | | Monreale, Landi | |
| |9. |27.10| SQL Server + SSIS + ToCSV + FromCSV| | | | |9. |27.10| SQL Server + SSIS + ToCSV| {{ :mds:lbi:2026-lds.07.sqlserver.pdf | SQL Server}} {{ :mds:lbi:2026-lds.08.etlandssis.pdf | SSIS}} | | | Landi | |
| |10. |28.10| SSIS: Pipeline + Stratified Sampling assignmt| | | | |10. |28.10| SSIS: Demo, FromCSV, and Pipeline Exercise | {{ :mds:lbi:lds_2026-27_20261028.zip |SSIS Ex 28.10}} | | | Landi | |
| |11. |29.10| Correction of exercise in python on customers | | | | |11. |29.10| SSIS Exercises and Stratified Sampling assignment | {{ :mds:lbi:lds_2026-27_20261029.zip | SSIS Ex 29.10}} | | | Landi | |
| |12. |03.11| SSIS:Update, Surrogate Keys | | | | |12. |03.11| SSIS:Update, Surrogate Keys | | | |
| |13. |11.11| Correction of Stratified Sampling + SCD workflow for new customers | | | | |13. |05.11| SSIS:Correction of Stratified Sampling | | | |
| |14. |17.11| SCD workflow for update customers + SSIS practice | | | | |14. |11.11| SCD workflow for new customers | | | |
| |15. |18.11| SSIS practice + Solutions of Dissimilarity and MPD| | | | |15. |17.11| SCD workflow for update customers + SSIS practice | | | |
| |16. |19.11| CDC Process | | | | |16. |18.11| SSIS practice + Solutions of Dissimilarity and MPD| | | |
| |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. |19.11| CDC Process | | | |
| |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. |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 | |
| |19. |27.11| PROJECT CHECK -MANDATORY | | | | |19. |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.| |
| |20. |01.12| Metrics + Excel power pivot integration | | | |20. |27.11| PROJECT CHECK -MANDATORY | | | |
| |21. |03.12| MDX Queries | | | | |21. |01.12| Metrics + Excel power pivot integration | | |
| |22. |04.12| MDX Queries | | | | |22. |03.12| MDX Queries | | | |
| |23. |09.12| MDX Queries | | | | |23. |04.12| MDX Queries | | | |
| |24. |10.12| PowerBI + MDX practice| | | | | |24. |09.12| MDX Queries | | | |
| | |25. |10.12| PowerBI + MDX practice| | | | |
| |
| |
