====== ICT: Business intelligence and CRM  ======


====== Teacher =====
**Anna Monreale  **
    * KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
    * [[http://www-kdd.isti.cnr.it]]
    * [[anna.monreale@unipi.it]]


====== EXAM =====
  * 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  =====
  * Slides
  * Databases essentials - Antonio Albano {{ :bdd-infuma:bookdb.pdf |PDF File}} 
  * A First Course in Database Systems, JefferyD. Ullman and Jennifer Widom 
  * Decision Support Databases Essentials - Antonio Albano {{ :bdd-infuma:bookdw.pdf | PDF File}}
 
====== Software =====
   * SQL Server 2016 Developer Edition: 
    - 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]]
  * **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 =====
  * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}}
  * {{ :bdd-infuma:master_big_data_db.sql.zip | MasterDB}}
 

====== Class Calendar 2020 ======

^ ^ Day ^ Topic ^ Learning material ^ Book ^
|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. |  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. |  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. |  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 |
|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 |}}|