Strumenti Utente

Strumenti Sito


bdd-infuma:bi-mains

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
bdd-infuma:bi-mains [06/03/2018 alle 13:28 (6 anni fa)]
Anna Monreale [Class Calendar 2018]
bdd-infuma:bi-mains [02/04/2020 alle 14:43 (4 anni fa)] (versione attuale)
Anna Monreale [EXAM]
Linea 7: Linea 7:
  
 ====== EXAM ===== ====== EXAM =====
-  * Project: 2 deliveries  +
-  *   - First part within March 14, 2018: {{ :bdd-infuma:exam1.pdf | First Part of the Project}}+
 ====== Learning Material  ===== ====== Learning Material  =====
   * Slides   * Slides
Linea 33: Linea 32:
 |3. |  26.02.2018  09:00-13:00 |SQL Language                                  | {{ :bdd-infuma:d.sql-concettibase.pdf | SQL}}|DB Essentials| |3. |  26.02.2018  09:00-13:00 |SQL Language                                  | {{ :bdd-infuma:d.sql-concettibase.pdf | SQL}}|DB Essentials|
 |4. |  26.02.2018  14:00-18:00 |Exercises on SQL. Decision Support Systems.| |DB Essentials| |4. |  26.02.2018  14:00-18:00 |Exercises on SQL. Decision Support Systems.| |DB Essentials|
-|5. |  27.02.2018  09:00-13:00 |Exercises SQL.                    | |DSD Essentials|+|5. |  27.02.2018  09:00-13:00 |Exercises SQL.                    | {{ :bdd-infuma:ex-sql.zip |}}|DSD Essentials|
 |6. |  28.02.2018  09:00-13:00 |DW Conceptual Modelling.          | {{ :bdd-infuma:dwconcept.pdf |}} |DSD Essentials| |6. |  28.02.2018  09:00-13:00 |DW Conceptual Modelling.          | {{ :bdd-infuma:dwconcept.pdf |}} |DSD Essentials|
-|7. |  05.03.2018  09:00-18:00 |Logical Modeling for DW – case studies for DW, SQL analitico -The Cube, Reporting           | {{ :bdd-infuma:g.dwlogical.pdf |Logical Model -DW}} {{ :bdd-infuma:h.olap.pdf | The cube}} {{ :bdd-infuma:i-analytics-sqlreporting.pdf |SQL analitico}}  |DSD Essentials| +|7. |  05.03.2018  09:00-18:00 |Logical Modeling for DW – case studies for DW, SQL analitico -The Cube, Reporting           | {{ :bdd-infuma:g.dwlogical.pdf |Logical Model -DW}} {{ :bdd-infuma:h.olap.pdf | The cube}} {{ :bdd-infuma:i-analytics-sqlreporting.pdf |SQL analitico}} {{ :bdd-infuma:sql-dw.txt.zip |Ex. AnalyticSQL}}  {{ :bdd-infuma:dwessentialssolutions.pdf |}}|DSD Essentials| 
-|8. |  06.03.2018  09:00-18:00 |ETL Process - Microsoft SQL Server Data Tools  | |DSD Essentials|+|8. |  06.03.2018  09:00-18:00 |Analytic Sql - ETL Process - Microsoft SQL Server Data Tools  |  {{ :bdd-infuma:i.etl.pdf | ETL}} {{:bdd-infuma:sqlan.sql.zip |}} |DSD Essentials|
 |9. |  14.03.2018  14:00-18:00 |ETL - Exercises | |DSD Essentials| |9. |  14.03.2018  14:00-18:00 |ETL - Exercises | |DSD Essentials|
-|10.|  15.03.2018  09:00-18:00 |Reporting| |DSD Essentials|+|10.|  15.03.2018  09:00-18:00 |ETL - Exercises{{ :mds:lbi:2016ssis.zip |}} (When you import the solution you will have some error due to the connection to DB and files. Please, modify them with login and pass and correct path of file) |DSD Essentials|
 |11.|  19.03.2018  14:00-18:00 |                                         | |DSD Essentials| |11.|  19.03.2018  14:00-18:00 |                                         | |DSD Essentials|
bdd-infuma/bi-mains.1520342914.txt.gz · Ultima modifica: 06/03/2018 alle 13:28 (6 anni fa) da Anna Monreale