Advance Data Architecture /Data Modeling Course

Advance Data Modeling Course

Part 1  :  ETL(Extract Transform and Load) Concepts

What is ETL

Data Sources and Data Types

Data Mapping

ETL Process

Incremental and Initial load

Data Extraction

Sample ETL Tools

Example of Dirty Data

What is Data Cleansing?

Steps in Data cleansing: Parsing, Correcting, Standardizing, Matching, Consolidating

Data Staging

Data Transformation

Data Loading

Metadata

Quiz

Part 2  :  Enterprise Information Modeling

Definition

What is Enterprise Information Modeling

Why Enterprise information Modeling required ?

When EIM should be started ?

EIM Framework

Distinguish PDM,LDM and EDM

Enterprise Information Models approach

EIM Intangible benefits

EIM tangible benefits

EIM patterns

Part 3  :  Universal Patterns : Generic Patterns

Audit Capability Pattern

International Language Capability Pattern

Part 4  :  Universal Patterns : People and Organization

People and Organization - Party

People and Organization - Party Role

People and Organization – Party Relationship

People and Organization – Party Address

People and Organization – Party Contact Mechanism

People and Organization – Facility and Contact Mechanism

People and Organization – Party Communication Event

People and Organization – Party Communication Event Follow Up

In Progress..........................