Data integration is becoming increasingly complex as new expectations and technologies change the face of data warehousing and business intelligence. Design of data integration systems was comparatively straightforward when extract, transform, and load (ETL) was the only option. In today's world, the demand for real-time and right-time data increases expectations, while scorecards and dashboards increase visibility. Simultaneously, enterprise information integration (EII), enterprise application integration (EAI), master data management (MDM), and customer data integration (CDI) technologies expand the range of possibilities.
This course teaches techniques and skills to build data integration systems that can meet today’s needs and evolve to meet demands of the future. Starting with the right requirements, using the right technologies, and designing for adaptability are central themes throughout the course.
Analysis techniques to capture data integration requirements, including those for source data, data consolidation, data quality, data granularity, data currency, and historical data
How the alphabet soup of integration technologies—ETL, EII, EAI, MDM, and CDI—fits into overall data integration architecture
Module One
Data Integration Concepts
The Need for Data Integration
The Challenges of Data Integration
Data Integration Architectures
Data Integration Projects
Data Integration Technologies
Module Two
Integration Requirements Concepts
Source Data Requirements
Data Unification Requirements
Data Aggregation and Summary Requirements
Data Quality Requirements
Data Capture Requirements
Audit, Balance and Control Requirements
Metadata Capture Requirements
Service Level Requirements
Module Three
Source/Target Mapping
Data Capture Design and Specification
Data Transformation Design and Specification
Data Cleansing Design and Specification
Identity and Key Management
Design for Integrated Data Delivery
Data Integration Process Design
Module Four
Technical Design Concepts
Data Flow Design
Work Flow Design
Service Level Design
Process Management Design
Module Five
Overview
Building Data Integration Systems
Implementing Data Integration Systems
Operating Data Integration Systems
Module Six
Best Practices in Data Integration
References and Resources
Appendix A
E-Max Systems
PlayNation Systems
E-Max Database
E-Max Flat Files
PlayNation Database Tables
PlayNation Flat Files
Appendix B
Exercises
Exercise 1: Integration Options
Exercise 2: Data Unification
Exercise 3: Identify and Key Management
Exercise 4: Data Flow Design
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.