| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| mds:lbi:start [18/09/2024 alle 21:25 (10 mesi fa)] – [Class calendar - (2024-2025)] Anna Monreale | mds:lbi:start [03/02/2025 alle 23:27 (5 mesi fa)] (versione attuale) – [Exam sessions] Anna Monreale |
|---|
| | Wednesday | 16:00 - 18:00 | Fib H-Lab | | | Wednesday | 16:00 - 18:00 | Fib H-Lab | |
| | Thursday | 11:00 - 13:00 | Fib A1 | | | Thursday | 11:00 - 13:00 | Fib A1 | |
| | Friday | 11:00 - 13:00 | Fib L1 | | | Friday | 11:00 - 13:00 | Fib C1 | |
| |
| |
| * [[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 - (2024-2025) ====== | ====== Class calendar - (2024-2025) ====== |
| ^ Day ^ Topic ^ Slides ^ Data/Software ^ References ^ Video Lectures ^ | ^ Day ^ Topic ^ Slides ^ Data/Software ^ Video Lectures ^ |
| |18.09| Introduction to the Course. BI Architectures. File data access. | {{ :mds:lbi:2024-lds.01.introduction.pdf | Introduction}} {{ :mds:lbi:2024-lds.02.bi_architectures.pdf | BI architectures}} {{ :mds:lbi:2024-lds.03.file_data_access.pdf | Files}} | |-** BI technology:** [[https://cacm.acm.org/magazines/2011/8/114953-an-overview-of-business-intelligence-technology/fulltext | An Overview of Business Intelligence Technology]] - **File access:** {{ :mds:lbi:filesystem.pdf | File System Interface}} | [[https://unipiit.sharepoint.com/:v:/s/Registrazioni628/EZeGVNiFuYlDq_UbKCecP6gB_kZpwz9DnIPvVoFfLM2laQ?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D&e=aaYsXE|video]] | | |18.09| Introduction to the Course. BI Architectures. File data access. | {{ :mds:lbi:2024-lds.01.introduction.pdf | Introduction}} {{ :mds:lbi:2024-lds.02.bi_architectures.pdf | BI architectures}} {{ :mds:lbi:2024-lds.03.file_data_access.pdf | Files}} | | [[https://tinyurl.com/4shae4c4|video]] | |
| |25.09| | | | | | | |25.09| Python Recap. + Exercises | {{ :mds:lbi:2024-lds.04.python.pdf | Python Recap}} | {{ :mds:lbi:2024-lds.04_supplementary.code.zip | supplementary code}} | [[https://tinyurl.com/337t8hxf|video]] | |
| |02.10| | | | | | | |02.10| Python File Access | {{ :mds:lbi:2024-lds.05.fileaccess-python.pdf | Python File Access}} | {{ :mds:lbi:data1.zip | Data ex files}} {{ :mds:lbi:lds04_solutions.zip | LDS04 sol}} | | |
| |09.10| | | | | | | |09.10| RDBMS access protocols | {{ :mds:lbi:2024-lds.06.relational_data_access.pdf | Relational Data Access}} {{ :mds:lbi:ex-customers.pdf}} | {{ :mds:lbi:data-customers.zip | Data ex files 2}} {{ :mds:lbi:lds05_fileaccesspython_solutions.zip |LDS05 sol}}| | |
| |22.10| | | | | | | |23.10| Python DB Access | slides previous lecture | | [[https://tinyurl.com/3dun69db|video]] | |
| |23.10| | | | | | | |24.10| Python DB Access | slides previous lecture |{{ :mds:lbi:2024-sample-db.zip |}} | [[https://tinyurl.com/yyku3xy6|video1]] [[https://tinyurl.com/55nzrh6w|video2]] | |
| |30.10| | | | | | | |29.10| Python DB Access: exercises | slides previous lecture | {{ :mds:lbi:lds05_fileaccesspython_excustomer.zip |ex-customer_sol}} | [[https://tinyurl.com/mtmt4hum|video]] | |
| |06.11| | | | | | | |30.10| SQL Server + SSIS + ToCSV| {{ :mds:lbi:2024-lds.07.sqlserver.pdf |SQL Server}} {{ :mds:lbi:2024-lds.08.etlandssis.pdf | ETL and SSIS}} | | [[https://tinyurl.com/3um46n3t|video]] | |
| |07.11| | | | | | | |06.11| SSIS: FromCSV + Project Discussion | slides previous lecture | | [[https://unipiit.sharepoint.com/:v:/s/a__td_65012/ER6z07WVERNLs1AgQg9qOggBIYYU0YCVZNhL724BiIVKyg?e=FMldZI|Video: Due to connection issues the recording could have some issues ]] | |
| |12.11| | | | | | | |07.11| SSIS: Pipeline| slides previous lecture | | [[https://unipiit.sharepoint.com/:v:/s/a__td_65012/EVZKAvV9s9xMmz-9DDU-mKIBE0YEkQ5U9bknurxkg-ZY8A?e=oU5eCz|Video: Due to connection issues the recording could have some issues]]| |
| |13.11| | | | | | | |13.11| SSIS: Stratified Sampling| slides previous lecture | {{ :mds:lbi:examples-2024.zip | Practice SSIS}}| [[https://unipiit.sharepoint.com/:v:/s/a__td_65012/EQBoMwBYK1JJvsIPYL2Ksj8Bwemnl2HCSbW8pSeg_vuEcA?e=LMw9JM|Video: Due to connection issues the recording could have some issues ]]| |
| |14.11| | | | | | | |14.11| SSIS: Surrogate Keys |slides previous lecture | |[[https://unipiit.sharepoint.com/:v:/s/a__td_65012/Ec3Y7VKIz2BCgLh3D5ZROmwBjxYxUrmMSFaCK-vtY0_P3Q?e=gaQyv7|Due to connection issues the recording could have some issues]] | |
| |19.11| | | | | | | |19.11| SSIS: Practice | | | | |
| |20.11| | | | | | | |20.11| SSIS: Practice | {{ :mds:lbi:ssis_dissimilarity_idx.pdf |Dissimilarity index}} | | | |
| |21.11| | | | | | | |21.11| CDC Process + Dissimilarity Index | {{ :mds:lbi:lds-ssis-projects-full.zip |}}| | | |
| |03.12| | | | | | | |26.11| Introduction to SSAS + DW|{{ :mds:lbi:2024-lds.09.dwandolap.pdf |DW and OLAP}} | | | |
| |04.12| | | | | | | |27.11| Olab Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf | SSAS }} |{{ :mds:lbi:foodmart_monreale_full-2024.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. As an alternative solution you mayimport the project from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).| | |
| |05.12| | | | | | | |28.11|Metrics + Excel power pivot integration | | {{ :mds:lbi:foodmart_monreale_complete-2024.zip |}}| | |
| |10.12| | | | | | | |03.12| MDX Queries| Same slides as in the previous lectures | {{ :mds:lbi:query-samples.zip |}}| | |
| |11.12| | | | | | | |04.12| MDX Queries| Same slides as in the previous lectures | | | |
| |12.12| | | | | | | |05.12| MDX Queries| Same slides as in the previous lectures | {{ :mds:lbi:2024-12-05-queries-demomdx.zip | new version of the query samples}} | | |
| | |11.12| MDX Queries| | | | |
| | |12.12| PowerBI + MDX practice| {{ :mds:lbi:2024-12-12-queries-demomdx.zip | File updated with new queries}}| {{ :mds:lbi:mdxqueryies-to_besolved.txt.zip |Queries to be solved}}| | |
| | |13.12| **No lesson in this date.** | | | | |
| | |18.12| Room C 1400-16:00| | | | |
| ====== Exams ====== | ====== Exams ====== |
| |
| Each part of the project **must be documented** with a brief pdf report (no more than 5 pages) describing your solution. | Each part of the project **must be documented** with a brief pdf report (no more than 5 pages) describing your solution. |
| |
| **Project to be delivered within 27/12/2024 ** | **Final Project version to be delivered within 27/12/2024 ** |
| * **Dataset:** | * **Dataset:** [[https://drive.google.com/file/d/1FzGqHC0urBhbXUhYQrjbLEhR9CqovOm8/view?usp=sharing|Link]] |
| | * First part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_1_20241126.pdf | Project Part 1 (updated 26/11/2024)}}. **Deadline**: 05/12/2024 |
| | * Second part of the project consists in the assignments described here: {{ :mds:lbi:2024_-_lds_project_-_part_2_20241218.pdf | Project Part 2 (updated 18/12/2024)}}. **Deadline**: 05/01/2025 (extended) |
| | |
| **Project to be delivered during the exam sessions ** | **Project to be delivered during the exam sessions ** |
| Students who did not deliver the above project by 27/12/2024 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work. After the delivery, the project 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 all teachers!** | Students who did not deliver the above project by 05/01/2025 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work. After the delivery, the project 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 all teachers!** |
| |
| |
| **Important:** the date of the discussion of the lab project will be communicated to you. The dates at the | **Important:** the date of the discussion of the lab project will be communicated to you. The dates at the |
| [[https://esami.unipi.it/esami2/|registration website]] regard **only** the written part of the DSD module. | [[https://esami.unipi.it/esami2/|registration website]] regard **only** the written part of the DSD module. |
| | |
| | **Oral Exam Date for LDS during the Winter Sessions:** |
| | * 27 Jan |
| | * 29 Jan |
| | * 30 Jan |
| | * 31 Jan |
| | * 03 Feb |
| | * 04 Feb |
| | * 14 Feb |
| | * 20 Feb |
| | * 21 Feb |
| |
| =====Past Editions ===== | =====Past Editions ===== |
