diff options
| -rw-r--r-- | doc/unit-8.md | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/doc/unit-8.md b/doc/unit-8.md index 3a27e48..f11d381 100644 --- a/doc/unit-8.md +++ b/doc/unit-8.md @@ -10,6 +10,46 @@ Read all section in Chapter 10. * discuss, in detail, the ETL process for data integration used in the reconciled data layer of data warehousing; * discuss the data transformation functions. +Data quality: + +* identity uniqueness +* accuracy +* consistency +* completeness +* timeliness +* currency +* conformance +* referential integrity + + +Extract-transform-load (ETL) + +1. map source to target and metadata management +2. extract +3. load +4. tranformation + + +> Data governance: high level organizational groups and processes that oversee data stewardship across the organization. +> It usually guides data quality initiatives, data architecture, data integration and master data management, data warehousing +> and business intelligence, and other data-related matters. + + +> Data steward: A person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals for data quality. + + +Data governance program needs: + +* sponsorship from both senior management and business units +* a data steward manager to support, train and coordinate the data stewards +* data stewards for different business units, data subjects, source systems or combinations of these elements. +* a governance committee, headed by one person, + but composed of data steward managers, + executives and senior vice presidents, + IT leadership, and other business leaders, + to set strategic goals, coordinate activities, + and provide guidelines and standards for all data management activities. + ## Section 2: Data Administration and Database Administration Read all sections of Chapter 11: "Data and Database Administration." |