Formación

Implementing Data Warehouse with Microsoft SQL Server 2012

Dades del curs

Tipus de curs

Externo, organizan otras entidades

Objectiu

Incluye la creación de soluciones de BI desde la implementación de un almacen de datos, desarrollo
de paquetes para extracción de datos, transferencia y transformación, la limpieza de datos, forzado
de integridad a través de Master Data Services y limpieza a través de Data Quality Servic

Adreçat a

Profesionales con un perfil de desarrollo de soluciones de BI.

Programa

Module 1: Introduction to Data Warehousing
This module provides an introduction to the key components of a data warehousing solution and the
high-level considerations you must take into account when embarking on a data warehousing project.
Module 2: Data Warehouse Hardware Considerations
This module describes the considerations for selecting the appropriate hardware platform for your
data warehouse solution.
Module 3: Designing and Implementing a Data Warehouse
This module describes how to implement the logical and physical architecture of a data warehouse
based on industry proven design principles.
Module 4: Design and implement a schema for a data warehouse
This module discusses considerations for implementing an ETL process, and then focuses on SQL Server
Integration Services (SSIS) as a platform for building ETL solutions.
Module 5: Implementing Control Flow in an SSIS Package
This module describes how to implement control flow which allows users to design robust ETL
processes for a data warehousing solution that coordinate data flow operations with other automated
tasks.
Module 6: Debugging and Troubleshooting SSIS Packages
This module describes how you can debug packages to find the cause of errors that occur during
execution. It then discusses the logging functionality built into SSIS that you can use to log
events for troubleshooting purposes. Finally, the module describes common approaches for handling
errors in control flow and data flow.
Module 7: Implementing an Incremental ETL Process
This module describes the techniques you can use to implement an incremental data warehouse refresh
process.
Module 8: Incorporating Data from the Cloud in a Data Warehouse
This modules describes how integrate cloud data into a data warehouse ecosystem
Module 9: Enforcing Data Quality
This modules describes how to use Data Quality Services (DQS) for cleansing and deduplicating your
data.
Module 10: Using Master Data Services
This module introduces Master Data Services and explains the benefits of using it in a business
intelligence (BI) context. It also describes the key configuration options, explains how to import
and export data and apply rules that help to preserve data integrity, and introduces the new Master
Data Services Add-in for Excel.
Module 11: Extending SSIS
This module describes how to extend SSIS by using custom scripts and components.
Module 12: Deploying and Configuring SSIS Packages
This modules describes how to deploy and configure SSIS packages.
Module 13: Consuming Data in a Data Warehouse
This module describes how information workers can consume data from the data wareh

Metodologia

Este cursos de 5 dias basado en instructor describe como implementar una plataforma de BI para soportar análisis de información. Los estudiantes crearán almacenes de datos con SQL Server 2012, implementar extracción, transformación y carga con SQL Server Integration Services, y validación y limpieza de datos con SQL Server Data Quality Services and SQL Server Master Data Services

Observacions

893,75€ 10% de descuento por ser colegiado
Persona: Mabel Bullon Benvenuto
Teléfono: 963940512 -675342589
E-Mail: mabelb@idese.es

On

Entitat

Idese Formación sl

Professor

Trainer de Microsoft formacion oficial

Habitació

c/ baldovi numero 2 entresuelo B 46002 – Valencia

Quan

Data d'inici

07/01/2013

Data final

18/01/2013

Duració

25 horas

Programar

16-21 h

Inscripció

Inici de la inscripció

27/12/2012

Fi inscripció

07/01/2013

Nombre de xifres utilitzades

6 aproximandamente

Quota d’inscripció

Contactar con la empresa


No està disponible la inscripció

Utilizamos cookies propias y de terceros para ofrecerte una mejor experiencia y servicio, de acuerdo a tus hábitos de navegación. Si continúas navegando, consideramos que aceptas su uso.