| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| bdd-infuma:bi-mains [23/02/2018 alle 20:31 (7 anni fa)] – [Software] Anna Monreale | bdd-infuma:bi-mains [02/04/2020 alle 14:43 (5 anni fa)] (versione attuale) – [EXAM] Anna Monreale |
|---|
| |
| ====== EXAM ===== | ====== EXAM ===== |
| * Project | |
| ====== Learning Material ===== | ====== Learning Material ===== |
| * Slides | * Slides |
| ====== Software ===== | ====== Software ===== |
| * SQL Server 2016 Developer Edition: | * 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 (17.4)]] and [[https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt | SQL Server 2017 Data Tools 15.5.1]] (no need to install Microsoft Visual Studio 2015! choose option 4 "Download SSDT as an ISO image") | - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio (17.4)]] and [[https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt | SQL Server 2017 Data Tools 15.5.2]] (no need to install Microsoft Visual Studio 2015! choose option 4 "Download SSDT as an ISO image") |
| * Microsoft Excel | * Microsoft Excel |
| * [[https://powerbi.microsoft.com/it-it/desktop/| Power BI Desktop]] | * [[https://powerbi.microsoft.com/it-it/desktop/| Power BI Desktop]] |
| |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. | |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 | |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 |SQL analitico -The Cube, 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 09:00-13:00 | | |DSD Essentials| | |11.| 19.03.2018 14:00-18:00 | | |DSD Essentials| |
