Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
bdd-infuma:start [20/02/2019 alle 07:53 (6 anni fa)] – [Class Calendar 2019] Anna Monreale | bdd-infuma:start [03/05/2020 alle 14:25 (4 anni fa)] (versione attuale) – [Class Calendar 2020] Anna Monreale |
---|
====== Business Intelligent Technologies ====== | ====== ICT: Business intelligence and CRM ====== |
| |
| |
====== Teachers ===== | ====== Teacher ===== |
**Anna Monreale ** | **Anna Monreale ** |
* KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa | * KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa |
| |
====== EXAM ===== | ====== EXAM ===== |
* Project to be delivered by email within May 8, 2019 | * 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. |
| |
| |
====== 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}} |
| |
| |
====== Class Calendar 2019 ====== | ====== Class Calendar 2020 ====== |
| |
^ ^ Day ^ Topic ^ Learning material ^ Book ^ | ^ ^ Day ^ Topic ^ Learning material ^ Book ^ |
|1. | 20.02.2019 09:00-18:00 |Introduction – Conceptual modeling – Exercise | {{ :bdd-infuma:a1.relationalmodel.pdf | Relational Model}}{{ :bdd-infuma:b.conceptualmodel.pdf |Conceptual Modeling}} {{ :bdd-infuma:01_ex-conceptual-design.pdf | Exercises on Conceptual Modeling}}|DB Essentials| | |1. | 17.02.2020 14:00-18:00 |Introduction – Relational Model Conceptual modeling | {{ :bdd-infuma:a.introduction.pdf |}} {{ :bdd-infuma:b.modellorelazionale.pdf |}} {{ :bdd-infuma:c.conceptualmodel.pdf |}} {{ :bdd-infuma:20200217-uni-model.pdf |Model of University DB}}{{ :bdd-infuma:01_ex-conceptual-design.pdf |Exercises Conceptual Modelling}}| DB Essentials| |
|2. | 21.02.2019 09:00-13:00 |Logical design - Exercises - SQL | | DB Essentials| | |2. | 24.02.2020 14:00-18:00 | Logical Modeling - Exercises on Conceptual & Logical Modeling | {{ :bdd-infuma:c.logicalmodel.pdf |}} {{:bdd-infuma:conceptual_logicalmodel-companies.jpeg?linkonly|}} {{ :bdd-infuma:logicalmodel-university.jpeg?linkonly |}}|DB Essentials | |
|3. | 25.02.2019 09:00-13:00 |Exercises SQL - Decision Support Systems. | |DB Essentials| | |3. | 10.03.2020 14:00-18:00 | Exercises on Conceptual & Logical Modeling. SQL | {{ :bdd-infuma:exmodelling-10march.pdf |}}{{ :bdd-infuma:e.sql-concettibase.pdf |}} | DB Essentials| |
|4. | 26.02.2019 09:00-18:00 |Data Warehouses Modeling - Exercises on DW models | |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.02.2019 09:00-13:00 |Querying DW | |DSD 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 | {{ :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-16:00 | Exercises on DW models | | |
| |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-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 {{ :bdd-infuma:sol-assignment3-aq.sql.zip |}}| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |