20463 – Implementing a Data Warehouse with Microsoft SQL Server

A Distancia

On demand

Objetivo:

 

Este curso provee a los estudiantes con los conocimientos y técnicas necesarias para implementar una plataforma de Data Warehouse para dar soporte a una solución de BI.

 

Requisitos:

 

Tener experiencia trabajando con bases de datos relacionales incluyendo: diseño de base de datos normalizada, creación de tablas y relaciones y consultas con Transact-SQL.

 

Duración:

 

40 horas

 

Temario:

 

  • Introduction to 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
  • Designing Dimension Tables
  • Designing Fact Tables
  • Physical design for a data warehouse
  • Introduction to ETL with SSIS
  • Creating an ETL Solution with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Introduction to Control Flow
  • Implementing Control Flow in an SSIS Package
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • 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
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match data
  • Enforcing Data Quality
  • 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
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Self-Service BI and Big Data

 

 

 

Técnicas: Al finalizar el curso los estudiantes serán capaces de

 

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.

 

 

Ver calendario

 

28 abril, 2017

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin