| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| mds:lbi:start [25/11/2025 alle 12:05 (6 giorni fa)] – [Class calendar - (2025-2026)] Anna Monreale | mds:lbi:start [30/11/2025 alle 23:27 (17 ore fa)] (versione attuale) – [Class calendar - (2025-2026)] Anna Monreale |
|---|
| * [[https://autenticazione.unipi.it/auth/auth.signin | Unipi Authentication]] to access the VPN, make sure that network access services are enabled on your profile. Follow this link to access your Unipi profile. | * [[https://autenticazione.unipi.it/auth/auth.signin | Unipi Authentication]] to access the VPN, make sure that network access services are enabled on your profile. Follow this link to access your Unipi profile. |
| ====== Class calendar - (2025-2026) ====== | ====== Class calendar - (2025-2026) ====== |
| ^N. ^ Day ^Room ^ Topic ^ Slides ^ Data/Code ^ Video Lectures ^ | ^N. ^ Day ^Room ^ Topic ^ Lecture Material ^ Video Lectures ^ |
| |1.|01.10| |Introduction to the Course. BI Architectures. File data access. |{{ :mds:lbi:2025-lds.01.introduction.pdf |}} {{ :mds:lbi:2025-lds.02.bi_architectures.pdf |}} {{ :mds:lbi:2025-lds.03.file_data_access.pdf |}}| | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDh0G1PpN6sT6CsDcFP6rcCARFDfU1sHLWvevsVzH__aYI?e=VVvwW7|Video]] | | |1.|01.10| |Introduction to the Course. BI Architectures. File data access. |{{ :mds:lbi:2025-lds.01.introduction.pdf |}} {{ :mds:lbi:2025-lds.02.bi_architectures.pdf |}} {{ :mds:lbi:2025-lds.03.file_data_access.pdf |}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDh0G1PpN6sT6CsDcFP6rcCARFDfU1sHLWvevsVzH__aYI?e=VVvwW7|Video]] | |
| |2.|02.10| |File data access. Python Recap. | {{ :mds:lbi:2025-lds.04.python_no_hint.pdf | Python Recap}} | {{ :mds:lbi:2024-lds.04_supplementary.code.zip | supplementary code}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDpwaIIRE7kR59OFasMQnGrARRFlLnNYNHuccTtZXQ6vdU?e=3nhEFt|File data access]] [[https://tinyurl.com/337t8hxf|Python Recap (from previous years)]] | | |2.|02.10| |File data access. Python Recap. | {{ :mds:lbi:2025-lds.04.python_no_hint.pdf | Python Recap}} {{ :mds:lbi:2024-lds.04_supplementary.code.zip | supplementary code}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDpwaIIRE7kR59OFasMQnGrARRFlLnNYNHuccTtZXQ6vdU?e=3nhEFt|File data access]] [[https://tinyurl.com/337t8hxf|Python Recap (from previous years)]] | |
| |3.|22.10| |Project Presentation + Python Excercises + File Access in Python |{{ :mds:lbi:2025-lds.05.fileaccess-python.pdf |}} | {{ :mds:lbi:2025-10-23-code.zip |}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQB5nDV9rjo7SrjShEp85YBPAbPYpxpTrq7LGKmthX-kE6w?e=KrlfP9|Project Presentation]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBEFtKr75UVQYDVYHjE7LHYAbL0XEMoA2aCGHvphTEg73Q?e=M8fUNQ|File access Py]]| | |3.|22.10| |Project Presentation + Python Excercises + File Access in Python |{{ :mds:lbi:2025-lds.05.fileaccess-python.pdf |}} {{ :mds:lbi:2025-10-23-code.zip |}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQB5nDV9rjo7SrjShEp85YBPAbPYpxpTrq7LGKmthX-kE6w?e=KrlfP9|Project Presentation]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBEFtKr75UVQYDVYHjE7LHYAbL0XEMoA2aCGHvphTEg73Q?e=M8fUNQ|File access Py]]| |
| |4.|29.10| |Python File Access + Exercises | same slides used in the previous lecture{{ :mds:lbi:data1.zip | Data ex files}} | | | |4.|29.10| |Python File Access + Exercises | same slides used in the previous lecture{{ :mds:lbi:data1.zip | Data ex files}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDMPfG7S6G0QKu3-hvN1pRNAZiDPUVuXhHlDjeQlD6-qX8?e=W2T6zj|Video]] | |
| | |30.10| |Lecture canceld | | | | | |30.10| |Lecture canceled | | |
| |5.|04.11| |RDBMS access protocols + Python DB Access | {{ :mds:lbi:2024-lds.06.relational_data_access.pdf | Slides}}| | | |5.|04.11| |RDBMS access protocols + Python DB Access | {{ :mds:lbi:2024-lds.06.relational_data_access.pdf | Slides}} | |
| |6.|05.11| |Exercises correction + Stratified sampling Exercise | {{ :mds:lbi:lds05_fileaccesspython_solutions.zip |}} {{ :mds:lbi:ex-customers.pdf |}} {{ :mds:lbi:data-customers.zip|}} | | | | |6.|05.11| |Exercises correction + Stratified sampling Exercise | {{ :mds:lbi:lds05_fileaccesspython_solutions.zip |}} {{ :mds:lbi:ex-customers.pdf |}} {{ :mds:lbi:data-customers.zip|}} | | |
| |7.|11.11| Fib H|Python DB Access: exercises | {{ :mds:lbi:stratifiedsampling.zip |}}| | | | |7.|11.11| Fib H|Python DB Access: exercises | {{ :mds:lbi:stratifiedsampling.zip |}} | | |
| |8.|13.11| Fib C |SQL Server + SSIS + ToCSV + FromCSV| {{ :mds:lbi:2024-lds.07.sqlserver.pdf |SQL SERVER}} {{ :mds:lbi:2024-lds.08.etlandssis.pdf | SSIS}}| |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD7nBKuQMn2T4uPA28VKrm_AfY_DcoRW8at7xwcPkfDHZA?e=vo3Lfi|SISS-Part1]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD9kEOKGLhpToMk41gH9ikSAVKYBWiH3egoU888EmkVKh0?e=loKj3J|SSIS-Part2 includes SQL Server Connection by Management Studio]] | | |8.|13.11| Fib C |SQL Server + SSIS + ToCSV + FromCSV| {{ :mds:lbi:2024-lds.07.sqlserver.pdf |SQL SERVER}} {{ :mds:lbi:2024-lds.08.etlandssis.pdf | SSIS}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD7nBKuQMn2T4uPA28VKrm_AfY_DcoRW8at7xwcPkfDHZA?e=vo3Lfi|SISS-Part1]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD9kEOKGLhpToMk41gH9ikSAVKYBWiH3egoU888EmkVKh0?e=loKj3J|SSIS-Part2 includes SQL Server Connection by Management Studio]] | |
| |9.|14.11| Lab H |SSIS:Pipeline + Stratified Sampling assignment | | | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBmsWKTFkCPSbiCe2BaveyTATyy8FlAzaLqw60uwBpLhJo?e=3DOuJE|Pipeline-Worksflows]]| | |9.|14.11| Lab H |SSIS: Pipeline + Stratified Sampling assignmt| | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBmsWKTFkCPSbiCe2BaveyTATyy8FlAzaLqw60uwBpLhJo?e=3DOuJE|Pipeline-Worksflows]]| |
| |10.|18.11|Lab H |Correction of exercise in python on customers | | |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBHQr2Y2ZZSQrm9wm8FWwDZAZKDita_Y36dUWYoeeJ7LlM?e=jFgkBP|Correction Python Excercise on Customers]]| | |10.|18.11|Lab H |Correction of exercise in python on customers | {{ :mds:lbi:2025_excustomer_sol.zip | ExCustomer sol}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBHQr2Y2ZZSQrm9wm8FWwDZAZKDita_Y36dUWYoeeJ7LlM?e=jFgkBP|Correction Python Excercise on Customers]]| |
| |11.|19.11|Lab I |SSIS:Update, Surrogate Keys | | | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBjYKiUz8BZR68-hqrdmrxUAcFto20QK4okEdRRlnKC4Tw?e=VNf9pv|Video]]| | |11.|19.11|Lab I |SSIS:Update, Surrogate Keys | | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBjYKiUz8BZR68-hqrdmrxUAcFto20QK4okEdRRlnKC4Tw?e=VNf9pv|Video]]| |
| |12.|20.11| Fib C | | | | | | |12.|20.11| Fib C | Correction of Stratified Sampling + SCD workflow for new customers | | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD4y5RXLCDAQZEMM9iJ0BbkAbJwUcYo-yZO1VmT9TnGWaw?e=x1bpzr|Video]]| |
| |13.|21.11|Lab H | {{ :mds:lbi:ssis_dissimilarity_idx.pdf |}} {{ :mds:lbi:2015midterm1text.pdf |}} | | | | | |13.|21.11|Lab H | SCD workflow for update customers + SSIS practice |{{ :mds:lbi:ssis_dissimilarity_idx.pdf |Dissimilarity}} {{ :mds:lbi:2015midterm1text.pdf | MPD}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD2Bb5-iJQaTorx40XlgsHjAdO_so2YLUVHCub0JIvp_5Y?e=mOReyv|Video]]| |
| |14.|25.11|Lab H | | | | | | |14.|25.11|Lab H | SSIS practice + Solutions of Dissimilarity and MPD| | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQAS8i9_GYxyTax_x1t8OdgJARZVvDauNw62C8e4gdPN9zo?e=JcJ7ma|Video]]| |
| |15.|26.11|Lab I | | | | | | |15.|26.11|Lab I | CDC Process | | | |
| |16.|27.11|Fib C | | | | | | |16.|27.11|Fib C | Introduction to SSAS + DW | {{ :mds:lbi:2024-lds.09.dwandolap.pdf | SSAS Intro}} | | |
| |17.|28.11|Lab H | | | | | | |17.|28.11|Lab H | Olap Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf |slides}}|{{ :mds:lbi:foodmart_monreale_full_2025.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.| | |
| |18.|02.12|Lab H | PROJECT CHECK -MANDATORY | | | | | |18.|02.12|Lab H | PROJECT CHECK -MANDATORY | | | |
| |20.|03.12| | | | | | |19.|03.12| | | | |
| |21.|05.12| Lab H | | | | | | |20.|05.12| Lab H | | | | |
| |22.|09.12| | | | | | |21.|09.12| | | | |
| |23.|10.12| | | | | | |22.|10.12| | | | |
| |24.|11.12| | | | | | |23.|12.12| | | | |
| | |24.|17.12| | | | |
| |
| |
