Database Answers  
You are not logged in: login | why register ?
Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us
Data Governance
BI+Performance Rpts
Data Marts
Data Integration
Data Sources


Architecture
 
    Introduction
    This Introduction to Data Governance is presented as a series of Questions and Answers.
    If you have a Question that are not addressed, please feel free to email me your Question.
    
    
    

    Question 1: What is Data Governance ? Data Governance can be defined simply as ‘Doing things right’ in Enterprise Data Management by complying with the appropriate rules, policies and procedures. These will all be designed to make sure that data used throughout the Enterprise is good-quality data, certainly when it appears in Performance reports. It's worth checking out Wikipedia on Data Governance Question 2: How do I get a top-down view of Data Management in my organisation ? Answers to this question are at different levels :-
    • Data Governance at the top-level
    • Master Data Management at the mid-level
    • Data Integration at the mid-level
    • Data Owners and Sources at the lowest level
    • Information Catalogue mandated as the central repository of all this information
    • Appropriate procedures in place to control all of these factors.
    Question 3: Why should my organisation have a Data Governance function ? The existence of a Data Governance function is a measure of the maturity of Data Management within an organization The first steps should be to establish a thin slice of Data Governance from top to bottom If you are active in this area, you should consider joining a professional organizational. This helps you to network with your peer group and will encourage you to keep up-to-date in knowledge and professional practice. Here are two organisations that are playing active roles in Data Governance :- i) The Data Governance Institute - Membership starts at $150 for individuals. ii) The Data Governance and Stewardship Community of Practice - $150/year. - It includes coverage of some very useful Case Studies. It also maintains a Data Governance Software Web Site, and a Sarbanes-Oxley Web Site.

    Question 4: What is Data Lineage ? Data Lineage can be defined as being able to the trace the derivation of all items of data that appear in any important Performance Reports and Management Information. That includes :-
    • Who owns the original source data
    • What validation and transformations are applied to the data in its life cycle
    Question 5: How do I verify the derivation of all data (the Data Lineage’) in my Reports ? This requires the use of an Information Catalogue that will record the source, processing steps and final delivery in a Report. The transformations in the processing Steps must be specified in both the processing language, for example SQL, and in plain, unambiguous English so that the Data Owner can sign-off on the Data Lineage.
 

© Database Answers Ltd. 2010

Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us