| Entrambe le parti precedenti la revisione
Revisione precedente
Prossima revisione
|
Revisione precedente
Ultima revisione
Entrambe le parti successive la revisione
|
bdd-infuma:start [30/03/2020 alle 11:46 (4 anni fa)]
Anna Monreale [Class Calendar 2020] |
bdd-infuma:start [03/05/2020 alle 14:10 (4 anni fa)]
Anna Monreale [EXAM] |
| ====== Business Intelligent Technologies ====== | ====== ICT: Business intelligence and CRM ====== |
| |
| |
| |
| ====== EXAM ===== | ====== EXAM ===== |
| * Project to be delivered by email within 15 May 2020: {{ :bdd-infuma:exam-mains-2020.pdf |First Part of the project. }} | * Project to be delivered by email within 15 May 2020:{{ :bdd-infuma:exam-mains-2020-final.pdf |}} |
| * Note that in the last page of the project description the student can find the instructions to be followed for the delivery. | * Note that in the last page of the project description the student can find the instructions to be followed for the delivery. |
| | |
| | |
| |
| ====== Learning Material ===== | ====== Learning Material ===== |
| - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio ]] | - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio ]] |
| * For students with Mac OSX or Linux: [[https://www.valentina-db.com/en/valentina-studio-overview|Valentina Studio]] | * For students with Mac OSX or Linux: [[https://www.valentina-db.com/en/valentina-studio-overview|Valentina Studio]] |
| | * **Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.** |
| ====== Data ===== | ====== Data ===== |
| * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} | * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} |
| |4. | 23.03.2020 14:00-18:00 | Exercises on SQL + Advances SQL & Exercises | {{ :bdd-infuma:text-ex-sql.pdf |}} {{ :bdd-infuma:assignment-23-03.pdf |}} {{ :bdd-infuma:sol-exsql.zip |}}|DB Essentials| | |4. | 23.03.2020 14:00-18:00 | Exercises on SQL + Advances SQL & Exercises | {{ :bdd-infuma:text-ex-sql.pdf |}} {{ :bdd-infuma:assignment-23-03.pdf |}} {{ :bdd-infuma:sol-exsql.zip |}}|DB Essentials| |
| |5. | 27.03.2020 09:00-13:00 | Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling | {{ :bdd-infuma:3-sol-market-queries.sql.zip |}} {{ :bdd-infuma:f.dwconcept.pdf |}} [[http://didawiki.cli.di.unipi.it/lib/exe/fetch.php/bdd-infuma/bookdw.pdf|Do Exercises in Appendix A of this book]] |BOOK: Decision Support Databases Essentials | | |5. | 27.03.2020 09:00-13:00 | Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling | {{ :bdd-infuma:3-sol-market-queries.sql.zip |}} {{ :bdd-infuma:f.dwconcept.pdf |}} [[http://didawiki.cli.di.unipi.it/lib/exe/fetch.php/bdd-infuma/bookdw.pdf|Do Exercises in Appendix A of this book]] |BOOK: Decision Support Databases Essentials | |
| |6. | 30.03.2020 14:00-18:00 | Data Warehouses Logical Modeling - Exercises on DW models | https://meet.google.com/dcy-dqvb-eub The lecture will start at 14:10| | |6. | 30.03.2020 14:00-18:00 | Data Warehouses Logical Modeling - Exercises on DW models | {{ :bdd-infuma:dwlogical.pdf |}} {{ :bdd-infuma:dw-modelling-a1.pdf | Ex-Hospital}} {{ :bdd-infuma:dw-modelling-a2.pdf | Ex-FlightSeats}}| |
| |7. | 02.04.2020 14:00-18:00 | Exercises on DW models + olap - sql reporting| | | |7. | 02.04.2020 14:00-16:00 | Exercises on DW models | | |
| |8. | 06.04.2020 14:00-18:00 | Querying DW | | | |8. | 06.04.2020 14:00-16:00 | olap - sql reporting | {{ :bdd-infuma:h.olap.pdf |}} {{ :bdd-infuma:ex-inventory-hotels.pdf |}} {{ :bdd-infuma:inventory-metrics.pdf |}}| |
| |9. | 07.04.2020 14:00-18:00 | Exercises on Querying DW | | | |9. | 07.04.2020 14:00-16:00 | Querying DW |{{ :bdd-infuma:sqlan.sql.zip |}} {{ :bdd-infuma:ex-aq.pdf | Text of Exercises}} | |
| | |10. | 16.04.2020 09:00-11:00 | Querying DW Exercises | {{ :bdd-infuma:l-analytics-sqlreporting.pdf |}} {{ :bdd-infuma:sol-assignment-aq.zip |}} {{ :bdd-infuma:assignment-aq-2.pdf |}}| |
| | |11. | 21.04.2020 14:00-16:00 | Final Exam Presentaion + Exercises | {{ :bdd-infuma:assignment-aq-3.pdf |}} {{ :bdd-infuma:sol-assignment2-aq.zip |}}| |
| | |12. | 27.04.2020 09:00-11:00 | Reporting + Exercises | **Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.** -- https://meet.google.com/dcy-dqvb-eub | |
| | |
| | |
| |
| |
