 |
|
This course is currently being updated and will be available the second half of 2023.
Integrated data is at the heart of many business and technical disciplines today. Data warehousing, operational data integration, and master data management focus on integration as a key part of managing data as an asset. Business intelligence, performance management, and business analytics depend on integrated data to meet business requirements for management and decision-making information. Legacy system replacement, ERP implementation, and application integration all have integrated data dependencies. Integration is important, but it is challenging to understand data sources, select and apply integration techniques, and design and deliver integrated databases.
|
|
This online training course discusses architectures, requirements, methods, roles and activities of data integration that can be applied to achieve successful data integration projects for a variety of applications and circumstances.
You will learn:
- Fundamental concepts, principles, and terminology of data integration
- Common methods of data integration with attention to techniques, timing, and integration process automation
- How to perform the essential steps of data integration including requirements definition, data capture, data transformation, and data delivery
- Data integration techniques and technologies including ETL, ELT, virtualization, and federation
- Techniques for source-to-target mapping and data transformation
- Roles, purpose, and variations of data integration architecture including architectural constructs for data warehousing, master data management, and operational data integration
- Business and technical roles, responsibilities, knowledge, and skills that are central to data integration projects and processes
This course is geared towards:
- Data integration architects, designers, and developers
- Business intelligence practitioners, project managers, and architects
- Data warehousing practitioners, project managers, and architects
- MDM practitioners, project managers, and architects
- ERP implementers and system integrators
- Business subject experts and data subject experts with roles in data integration projects and processes
DI-01 Data Integration Fundamentals and Best Practices
| |
DI-01-00 About the Course (5 min)
DI-01-01 Data Integration Concepts (44 min)
- Overview
- Data Integration Defined
- Data Integration Dependent Programs
- Data Integration Projects
DI-01-02 Data Integration Methods (49 min)
- Overview
- Data Integration Techniques
- Data Integration Frequency
- Data Integration Systems
- Data Integration Challenges
- Data Integration Activities
DI-01-03 Understanding Data (61 min)
- Overview
- Identifying Data Sources
- Profiling Data
- Qualifying Data Sources
- Documenting Data Sources
DI-01-04 Integrating Data (78 min)
- Overview
- Integration Requirements
- Data Capture
- Data Transformation
- Data Delivery
DI-01-05 Data Integration Architecture (37 min)
- Overview
- Architecture Concepts
- Data Warehousing Architecture
- MDM Architecture
- Operational Data Integration Architecture
DI-01-06 Data Integration Roles and Responsibilities (28 min)
- Overview
- Knowledge and Skills
- Understanding the Data
- Getting the Data
- Transforming the Data
- Delivering the Data
- Using the Data
|
Click –here- to download a more detailed outline of this course.
|
This exam tests knowledge and understanding of basic concepts, principles, and terminology in data integration.
|
You will be tested in these areas:
- Basic concepts and principles of data integration
- Data integration techniques and technologies including ETL, ELT, data virtualization, and data federation
- Data integration steps, including requirements definition, data capture, source-to-target data mapping, data transformation, and data delivery
- Data integration architectures, including architectural constructs for data warehousing, master data management, and operational data integration
- Business and technical roles, responsibilities, knowledge, and skills that are central to data integration projects and processes
|
Additional Information
Number of Questions: 25
Time Limit: 50 Minutes
Passing Score: 70%
|
|
Once you pass the exam, you will receive a Certificate of Education
documenting that you have demonstrated mastery of the topic. Course
exams count towards eLC certification programs. Visit our Certification page for more information about our various programs.
We recommend that you take detailed notes and review the course material multiple times before taking this exam. Click here to learn more about CIMP exams.
|
|
|
|
Course Review 
Course Review