Implementing a Data Warehouse with Microsoft SQL Server (MS 20463)

IL CENTRO PRESENTA IL PROGRAMMA PENSATO PER MIGLIORARE LE TUE COMPETENZE E PERMETTERTI DI REALIZZARE GLI OBIETTIVI STABILITI. NEL CORSO DELLA FORMAZIONE SI ALTERNERANNO DIFFERENTI MODULI CHE TI PERMETTERANNO DI ACQUISIRE LE CONOSCENZE SULLE DIFFERENTI TEMATICHE PROPOSTE.

Introduction to Data Warehousing

• Overview of Data Warehousing
• Considerations for a Data Warehouse Solution

Planning Data Warehouse Infrastructure

• Considerations for Data Warehouse Infrastructure
• Planning Data Warehouse Hardware

Designing and Implementing a Data Warehouse

• Data Warehouse Design Overview
• Designing Dimension Tables
• Designing Fact Tables
• Physical Design for a Data Warehouse

Creating an ETL Solution with SSIS

• Introduction to ETL with SSIS
• Exploring Data Sources
• Implementing Data Flow

Implementing Control Flow in an SSIS Package

• Introduction to Control Flow
• Creating Dynamic Packages
• Using Containers
• Managing Consistency

Debugging and Troubleshooting SSIS Packages

• Debugging an SSIS Package
• Logging SSIS Package Events
• Handling Errors in an SSIS Package

Implementing a Data Extraction Solution

• Planning Data Extraction
• Extracting Modified Data

Loading Data into a Data Warehouse

• Planning Data Loads
• Using SSIS for Incremental Loads
• Using Transact-SQL Loading Techniques

Enforcing Data Quality

• Introduction to Data Quality
• Using Data Quality Services to Cleanse Data
• Using Data Quality Services to Cleanse Data

Master Data Services

• Introduction to Master Data Services
• Implementing a Master Data Services Model
• Managing Master Data
• Creating a Master Data Hub

Extending SQL Server Integration Services

• Using Scripts in SSIS
• Using Custom Components in SSIS

Deploying and Configuring SSIS Packages

• Overview of SSIS Deployment
• Deploying SSIS Projects
• Planning SSIS Package Execution

Consuming Data in a Data Warehouse

• Introduction to Business Intelligence
• Enterprise Business Intelligence
• Self-Service BI and Big Data