Differenze

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

--- bdd-infuma:start [06/04/2020 alle 18:39 (6 anni fa)] – [Class Calendar 2020] Anna Monreale
+++ bdd-infuma:start [03/05/2020 alle 14:25 (6 anni fa)] (versione attuale) – [Class Calendar 2020] Anna Monreale
@@ Linea 1: / Linea 1: @@
-====== Business Intelligent Technologies ======
+====== ICT: Business intelligence and CRM  ======
@@ Linea 10: / Linea 10: @@
 ====== 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.
 ====== 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 ]]
   * 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}}
@@ Linea 39: / Linea 42: @@
 |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. |  06.04.2020  14:00-16:00 | Querying DW            | https://meet.google.com/dcy-dqvb-eub  |
+|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 |}}|