Part 7: Plan and Analyze | Data Integration & Interoperability

Before you choose any integration solution, what do you need to find out first? In this video (DAMA-CDMP series, Part 7) we cover the Plan and Analyze activity from the DMBOK2 chapter on Data Integration and Interoperability, in five steps: define data integration and lifecycle requirements, perform data discovery, document data lineage, profile the data, and collect business rules. Each step has a problem, a step-by-step explanation, a full worked example, and a comparison with the previous step, and we link everything back to Parts 1 to 6. The video ends with 5 practice questions. Explanations are in Egyptian Arabic, and slides and key definitions are in English. 0:00 Introduction 0:42 The big picture 1:22 The lifecycle and the planning phase 1:55 Five steps, one thread 2:33 The running example 3:05 Requirements: the problem 3:39 Requirements: what they cover 4:17 Requirements: how it works 4:52 Requirements: laws and regulations 5:24 Requirements: retention and lifecycle 6:03 Requirements: who defines them 6:37 Requirements: from need to technology 7:15 Requirements: Metadata is born 7:48 Requirements: a full example 8:22 Requirements: links to the earlier parts 9:01 Data Discovery: the problem 9:27 Data Discovery: the goal 10:03 Data Discovery: two techniques 10:37 Data Discovery: high-level quality 11:14 Data Discovery: the inventory 11:47 Data Discovery: external data 12:25 Data Discovery: a full example 13:00 Discovery versus Requirements 13:39 Data Lineage: the problem 14:04 Data Lineage: high-level 14:45 Data Lineage: detailed 15:16 Data Lineage: documenting code 15:52 Data Lineage: finding improvements 16:26 Data Lineage: a full example 17:02 Lineage versus Discovery 17:37 Data Profiling: the problem 18:05 Data Profiling: why it matters 18:43 Data Profiling: five basic checks 19:15 Data Profiling: format and population 19:49 Data Profiling: values, patterns, relationships 20:31 Data Profiling: sources and targets 21:06 Data Profiling: fitness and accuracy 21:47 Data Profiling: capture and protect 22:20 Data Profiling: a full example 23:05 Profiling versus Discovery 23:44 Business Rules: the problem 24:14 Business Rules: what they are 24:50 Business Rules: four categories 25:32 Business Rules: four uses 26:11 Business Rules: master data and retention 26:53 Business Rules: harvesting 27:32 Business Rules: a full example 28:05 Rules versus Requirements 28:44 Putting it all together 29:17 How to recognize the answer 30:00 Summary 30:36 Practice questions 30:56 Question 1 31:42 Question 2 32:34 Question 3 33:24 Question 4 33:52 Question 5 DAMA-CDMP, CDMP, DMBOK2, data management, data integration, data interoperability, plan and analyze, data requirements, data discovery, data lineage, data profiling, business rules, metadata, data governance, data quality, CDMP exam, CDMP practice questions, شرح DAMA, CDMP بالعربي