Strumenti Utente

Strumenti Sito


bdd-infuma:start

Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

Link a questa pagina di confronto

Entrambe le parti precedenti la revisione Revisione precedente
Prossima revisione
Revisione precedente
Ultima revisione Entrambe le parti successive la revisione
bdd-infuma:start [31/03/2020 alle 14:04 (20 mesi fa)]
Anna Monreale [Class Calendar 2020]
bdd-infuma:start [03/05/2020 alle 14:10 (19 mesi fa)]
Anna Monreale [EXAM]
Linea 1: Linea 1:
-====== Business Intelligent Technologies ======+====== ICT: Business intelligence and CRM  ======
  
  
Linea 10: Linea 10:
  
 ====== 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  =====
Linea 23: Linea 25:
     - 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}}
Linea 36: Linea 39:
 |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 |  +|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}}
-{{ :bdd-infuma:dwlogical.pdf |}} https://meet.google.com/dcy-dqvb-eub  The lecture will start at 14:10+|7. |  02.04.2020  14:00-16:00 | Exercises on DW models |  | 
-|7. |  02.04.2020  14:00-18:00 | Exercises on DW models + olap - sql reporting|  | +|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 |}}
-|8. |  06.04.2020  14:00-18:00 | 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}}   | 
-|9. |  07.04.2020  14:00-18:00 | Exercises on Querying DW     |  |+|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/start.txt · Ultima modifica: 03/05/2020 alle 14:25 (19 mesi fa) da Anna Monreale