You are previewing The Data Governance Imperative.
O'Reilly logo
The Data Governance Imperative

Book Description

Take control of your data for a more intelligent, responsive business

Proactive management of your corporate information has never been more important. Data governance isn't a challenge solely for the IT team - it's every inch a business issue.

Seamless processes and a personal commitment to clean data give you the ability to generate accurate business intelligence and financial reports, and gain an instant snap shot of the health of your business. Most importantly, they also help you run a more intelligent, agile, fast-moving business than your competitors.

The Data Governance Imperative is written from a business person's view of data governance. This practical book covers both strategies and tactics around managing a data governance initiative.

Benefits to business include:
  • Retain your competitive edge when data governance becomes a matter-of-fact component of corporate stewardship
  • Comply with worldwide corporate laws
  • Generate accurate business intelligence and financial reports
  • Understand your business at a deeper level
  • Delight your customers by gaining a better understanding of their needs
  • Handle support issues more smoothly
  • Deliver better 'green' programs
  • Learn how to become a 'change agent' and break through corporate barriers
  • "

    Table of Contents

    1. FOREWORD
    2. PREFACE
    3. ABOUT THE AUTHOR
    4. ACKNOWLEDGEMENTS
    5. CONTENTS
    6. CHAPTER 1: THE NEED FOR DATA GOVERNANCE
      1. Sins of the past
      2. Where are the metrics?
      3. Unnecessary complexity
      4. ETL and data warehouse
      5. Building more efficiency
      6. The value of an acquisition
      7. Decisions based on gut
      8. Data governance and being green
      9. Improving compliance with BASEL II and SOX
      10. Designated terrorist organizations
      11. Why data governance?
      12. Who needs data governance?
    7. CHAPTER 2: WHAT IS DATA GOVERNANCE?
      1. How do different groups see data governance?
        1. Broken data model example
      2. Defining data governance by its benefits
        1. Fewer adverse events
        2. Building the IT–business bridge
    8. CHAPTER 3: DEFINING DATA GOVERNANCE SUCCESS
      1. Generic data governance success factors
        1. Fix data anomalies
        2. Develop a repeatable process
        3. Handle change
        4. Coordinate efforts with business
        5. Data ownership
      2. Specific data governance success
    9. CHAPTER 4: GETTING FUNDED FOR IQ PROJECTS
      1. The data champion
        1. Knowledge
        2. Develop cross-functional relationships
        3. Selling the vision
        4. Being positive
        5. Leadership
      2. Return on investment
      3. Picking the right projects
      4. Building credibility
      5. Leveraging a crisis
      6. Leveraging new initiatives
      7. Conversation starters
        1. The four whys
        2. Return on investment
      8. The “do nothing” option
      9. Overcoming objections to data governance
        1. Corporate revenue
        2. Cheap wins
        3. Case studies
        4. Analysts
        5. Data governance expert sessions
        6. Guerilla marketing
    10. CHAPTER 5: PEOPLE – WHAT DOES A DATA GOVERNANCE TEAM LOOK LIKE?
      1. Data governance roles and responsibilities
      2. Data governance council
        1. Third-party advisory
      3. Team performance goals
      4. Methodologies
    11. CHAPTER 6: PAINTING THE PICTURE
      1. Mission statement
      2. Communication strategies
      3. Having productive meetings
      4. Tools to communicate
        1. Workflow
        2. Wikis
        3. Blogs
        4. RSS feeds
      5. Getting the data
      6. Data governance workshops
      7. Building a useful data quality scorecard
      8. Views of data quality scorecard
      9. Which key metrics do I track?
        1. Level 1 – Raw data quality metrics
        2. Level 2 – Business importance
        3. Level 3 – Project importance
          1. Example 1 – Customer relationship management system
          2. Example 2 – Supply chain
        4. Levels 4 – Business importance
        5. Level 5 – Executive performance
        6. Drill-downs
        7. Scorecards, aggregations and compliance
    12. CHAPTER 7: FIXING YOUR DATA
      1. Causes and actions
        1. Cause 1: Receiving merger and acquisition data
          1. Actions
        2. Cause 2: Data ownership and control
          1. Actions
        3. Cause 3: Deliberately poor or apathetic data entry
          1. Actions
        4. Cause 4: Metadata standards
          1. Actions
        5. Cause 5: Incomplete or missing information
          1. Actions
      2. Information quality and data-intensive projects
      3. Six phases of a data-intensive project
      4. Phase 1:Project preparation
        1. Define project team and roles
        2. Identify business objectives
          1. Scope
        3. Analyze current technology
        4. Assess data risks
      5. Phase 2:Making the blueprint
        1. Define success metrics
        2. Communication strategy
        3. Define standards
        4. Access data
        5. Analyze source data
        6. Capture a baseline
        7. Data architecture and schema/data model
        8. Data architecture and platforms
        9. Develop test case scenarios
        10. Define exceptions process
      6. Phase 3:Implement
        1. Create user acceptance test plan
        2. Create data-quality processes
        3. QA initial results
        4. Validate rules
        5. Tune business rules and standards
      7. Phase 4:Rollout preparation
        1. Execute user acceptance test plan
        2. User training and help desk training
        3. Production system cutover plan
        4. Successfully complete initial cleanse/load
      8. Phase 5:Go live
        1. Problem resolution
        2. Post mortem
        3. Define monitoring processes
      9. Phase 6:Maintain
        1. Announce successes
        2. Collect new requirements for next phase
    13. CHAPTER 8: TECHNOLOGIES THAT SUPPORT DATA GOVERNANCE
      1. Types of data governance technologies
      2. Preventative
        1. Type-ahead technology
        2. Workforce management
        3. Data quality dashboard
      3. Diagnostic and health
        1. Data profiling
        2. Batch data quality
      4. Infrastructure
        1. Metadata
        2. ETL
        3. Master data management
        4. Enterprise-class data quality
        5. Data monitoring
      5. Enrichment
        1. Services and data sources
    14. CHAPTER 9: THE AUDACITY OF DATA GOVERNANCE
    15. CHAPTER 10: CASE STUDY – BT
      1. Meager beginnings
      2. Lessons learned
    16. ITG RESOURCES
      1. Pocket Guides
      2. Toolkits
      3. Best Practice Reports
      4. Training and Consultancy
      5. Newsletter