
Practitioner's Guide to Operationalizing Data Governance
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
In A Practitioner's Guide to Operationalizing Data Governance, veteran SAS and data management expert Mary Anne Hopper walks readers through the planning, design, operationalization, and maintenance of an effective data governance program. She explores the most common challenges organizations face during and after program development and offers sound, hands-on advice to meet tackle those problems head-on.
Ideal for companies trying to resolve a wide variety of issues around data governance, this book:
* Offers a straightforward starting point for companies just beginning to think about data governance
* Provides solutions when company employees and leaders don't--for whatever reason--trust the data the company has
* Suggests proven strategies for getting a data governance program that's gone off the rails back on track
Complete with visual examples based in real-world case studies, A Practitioner's Guide to Operationalizing Data Governance will earn a place in the libraries of information technology executives and managers, data professionals, and project managers seeking a one-stop resource to help them deliver practical data governance solutions.
More details
Other editions
Additional editions

Content
- Cover
- Title Page
- Copyright Page
- Contents
- Acknowledgments
- Chapter 1 Introduction
- Intended Audience
- Experience
- Common Challenge Themes
- Metadata
- Access to Data
- Trust in Data
- Data Integration
- Data Ownership
- Reporting/Analytics
- Data Architecture
- Reliance on Individual Knowledge
- Culture
- How Data Governance Can Help
- Metadata
- Access to Data
- Trust in Data
- Data Integration
- Data Ownership
- Reporting/Analytics
- Data Architecture
- Reliance on Individual Knowledge
- Culture
- Chapter 1 - Introduction Summary
- Chapter 2 - Rethinking Data Governance
- Chapter 3 - Data Governance and Data Management
- Chapter 4 - Priorities
- Chapter 5 - Common Starting Points
- Chapter 6 - Data Governance Planning
- Chapter 7 - Organizational Framework
- Chapter 8 - Roles and Responsibilities
- Chapter 9 - Operating Procedures
- Chapter 10 - Communication
- Chapter 11 - Measurement
- Chapter 12 - Roadmap
- Chapter 13 - Policies
- Chapter 14 - Data Governance Maturity
- Chapter 2 Rethinking Data Governance
- Results You Can Expect With Common Approaches to Data Governance
- Here Comes Panera
- Voluntelling
- Misaligning Titles and Roles
- Project Delivery
- Tool Deployment
- What Does Work
- Adopting Consistent Definitions
- Disciplined Approach to Program Planning, Design, and Execution
- Rethinking Data Governance Summary
- Chapter 3 Data Governance and Data Management
- Results You Can Expect Focusing Purely on Data Governance or Data Management
- SAS Data Management Framework
- Data Governance
- Data Management
- Data Stewardship
- Business Drivers
- Solutions
- Methods
- Aligning Data Governance and Data Management Outcomes
- Data Architecture
- Data Administration
- Data Quality
- Data Security
- Metadata
- Reference and Master Data
- Reporting and Analytics
- Data Life Cycle
- Misaligning Data Governance and Data Management
- Data Governance and Data Management Summary
- Chapter 4 Priorities
- Results You Can Expect Using the Most Common Approaches to Prioritization
- The List
- Level
- Volume
- Lunch
- Communication
- Emergency
- A Disciplined Approach to Priorities
- Business Value
- Achievability
- Utilizing the Model
- University - Formal Weighted Model
- Retailer - A Different Approach
- Priorities Summary
- Chapter 5 Common Starting Points
- Results You Can Expect With Too Many Entry Points
- Building a Data Portfolio
- Metadata
- Metadata Categories
- Business Metadata
- Technical Metadata
- Operational Metadata
- Data Quality
- Business Definition
- Data Element
- Data Record
- Data Movement
- Data Profiling
- Common Starting Points Summary
- Chapter 6 Data Governance Planning
- Results You Can Expect Without Planning
- Defining Objectives
- Our Objectives
- Defining Guiding Principles
- Data Governance Planning Summary
- Chapter 7 Organizational Framework
- Results You Can Expect When There Is No Defined Organizational Structure
- Organizational Framework Roles
- Support
- Oversight
- Operations
- Facilitation
- Defining a Framework
- Data Governance Steering Committee
- Program Management
- Data Owner
- Working Group
- Data Stewardship
- Data Management
- Aligning the Model to Existing Structures
- Leadership Team
- Data Manager Team
- Domain Definitions - Student
- Domain Definitions - Business Operations
- Domain Definitions - External
- Data Manager
- Data Steward
- Ad-Hoc Working Group
- Data Governance Management
- Technical Data Operations
- Aligning the Framework to the Culture
- Data Governance Steering Committee
- Data Governance Sub-Committee
- Data Governance Office
- Data Steward
- Simplifying the Model
- Defining the Right Data Stewardship Model
- Data Domain Model
- Application Model
- Project Model
- Organizational Framework Summary
- Chapter 8 Roles and Responsibilities
- Results You Can Expect When Roles and Responsibilities Are Not Clearly Defined
- Aligning Actions and Decisions to Program Objectives
- Strategy & Alignment
- Establish Data Governance Program
- Data Governance Operations
- Data Architecture
- Metadata
- Data Quality
- Reference & Master Data
- Using a RACI Model
- Strategy & Alignment
- Establish Data Governance Program
- Data Governance Program Operations
- Data Architecture
- Metadata
- Data Quality
- Reference & Master Data
- Defining Roles and Responsibilities
- Data Governance Steering Committee
- Program Management
- Data Governance Council
- Data Owner Team
- Working Group
- Data Stewardship
- Data Management
- Naming Names
- Roles and Responsibilities Summary
- Chapter 9 Operating Procedures
- Results You Can Expect Without Operating Procedures
- Operating Procedures
- Data Governance Steering Committee
- Data Governance Council
- Data Owner
- Data Steward Team
- Working Group
- Program Management Team
- Data Management Team
- A Simplified View of Operating Procedures
- Workflows
- Policy Development
- Data Issue Intake
- Compliance Monitoring
- Prioritization
- Operating Procedures Summary
- Chapter 10 Communication
- Results You Can Expect Without Communication
- Communication Plan Components
- Message
- Objective
- Author(s)
- Audience
- Frequency
- Medium
- Sample Communication Plan
- Communication Summary
- Chapter 11 Measurement
- Results You Can Expect Without Measurement
- What Measurements to Define
- Program Scorecard - A Starting Point
- Data Governance Participation
- Data Governance Program Milestones
- Policy Compliance
- Program Scorecard Sample
- Measurement Summary
- Chapter 12 Roadmap
- Results You Can Expect Without a Roadmap
- First Step in Defining a Roadmap: Implementing Your Framework
- Defining a Roadmap
- Workstreams
- Launch Data Governance
- Data Warehouse Program Management
- Data Architecture
- Metadata
- Data Quality
- Data Management
- Formality First or Save it For Later?
- Critical Success Factors
- Roadmap Summary
- Chapter 13 Policies
- Results You Can Expect Without Policies
- Breaking Down a Policy
- Policy
- Procedure
- Standard
- Best Practice
- Data Management
- Contents of a Policy
- Policy Example - Metadata
- Name
- Policy Purpose
- Policy Objectives
- Policy Statement
- Attendant Procedures and Standards
- Metadata Collection Standard Template
- Scope/Affected Area(s)
- Roles and Responsibilities
- Compliance
- Effective Date
- Maintenance and Review
- Policy Example - Data Quality
- Policy Purpose
- Policy Objectives
- Policy Statement
- Procedures
- Standards
- Scope/Affected Area(s)
- Roles and Responsibilities
- Policy Summary
- Chapter 14 Data Governance Maturity
- Results You Can Expect With Maturity
- Data Governance Maturity Cycle
- Stage 1 - Define Program
- Stage 2 - Identify Challenges
- Stage 3 - Develop Policy
- Stage 4 - Policy Execution
- Stage 5 - Monitor and Communicate
- Maturing Your Program
- Summary
- About the Author
- Glossary of Terms
- Index
- EULA
CHAPTER 1
Introduction
INTENDED AUDIENCE
As long as the practice of Data Governance has been around, the concept continues to lack sustainable adoption in many organizations. My main objective with this book is to share my experience and help you and your organization on your journey, no matter where in that journey you are.
My best guess is that you are looking at this book as a guide for one of the following reasons:
- Your organization is thinking about Data Governance.
- You have been tasked with Data Governance.
- You need to get your Data Governance program back on track.
- You have acquired a tool and want to get the most value from your investment.
- You continue to have the same data quality issues over and over.
- You attended a conference and learned about Data Governance and think it is something you need.
The content in this book is meant for a large audience because Data Governance impacts the entire organization. Whether a senior leader or an individual contributor, you may be asked to participate at some level in Data Governance, actively or passively.
This book guides you through practical steps in applying Data Governance concepts to solve business problems by adopting a disciplined approach to Data Management methods. The chapters cover prioritization, alignment of Data Governance and Data Management, organizational structures, defining roles and responsibilities, communications, measurements, operations, implementation, and policies. All of the examples presented are not conceptual; they are real-world customer examples that can be applied to your specific organization.
EXPERIENCE
You most likely have an interest in not just Data Governance, but in data itself. Do you remember your "Aha" moment that turned you into a data junkie? I remember mine clearly. In the early 1990s, I worked for a small naval architectural firm. The focus of the firm was primarily custom high-end racing sailboat designs, including the America's Cup. One day my boss brought in a floppy disk and asked me to take a look at what was on it. Apparently, we had a client who thought his brand-new boat was slow. The disk contained the data dump from the boat's instruments. There were fields like time of day, heading, wind velocity, and boat speed. I was able to parse the data and essentially recreate the races with the available data points. What I learned was that the boat tacked nine or ten times on the first leg of each race. I know not all of you are expert sailboat racers but take my word for it; tacking that many times on any leg of a race in a big boat is slow. What did that mean for my boss? He was able to have a different conversation with our client. We were no longer defending boat design or building materials but instead talking about racing tactics and offering suggestions for improvements there first.
That day changed my view of the power of data and from that point forward I chose classes and career roles that were focused on data. Initially, I focused on database development and support and then transitioned into data warehouse development. On the IT side, I managed the development of platforms to support finance and treasury processes as well as the re-platforming of a home-grown loan servicing system. That experience enlightened me to the need for data quality processes and the understanding of data lineage and documented business rules. There came a time when I transitioned into project management, product ownership, and finally consulting. The consulting role is what has helped me most in hearing customer challenges and helping them solve those problems by instilling discipline in Data Management processes.
Over the years, I have worked with hundreds of clients across all industry verticals to help them establish that discipline in Data Management practices. In other words, helping them to establish Data Governance programs that align with their individual organization's business objectives while also considering their maturity, culture, and appetite for Data Governance.
This book is not only a reflection of a tested and proven methodology but also my experiences in what works and what doesn't work, things to not get hung up on, and where best to focus efforts. Some of the chapters are shorter than others but I still believe the topics are important enough to cover. My hope is that this book helps you and your organization in your own Data Governance journey.
COMMON CHALLENGE THEMES
Most of what I've heard over the years can be broken down into a set of common themes. One of the best ways to talk about those themes is to share with you what I've heard my clients say. Every quote is directly from a customer. If any of these quotes resonate with you, then formalizing Data Governance can help. You will see these themes again in future chapters.
Metadata
Metadata is the practice of gathering, storing, and provisioning information about data assets. As important as it is to collect and maintain, it is a practice that does not formally exist in most organizations. Most of my customers might not necessarily use the term metadata, but the concept is top of mind for them. There is a desire to have common terms defined and have a single repository to maintain information about those terms. Because there is no formal metadata process or repository, users spend a lot of their time trying to understand data on their own or relying on others to interpret meaning for them. Another byproduct from the lack of metadata process is that users complain of not knowing what data is available to them. Always keep in mind that metadata is a precursor to data quality; I will write more about that topic in later chapters.
Here is what clients have said:
- "we need Rosetta Stone for our data"
- "metadata is so important and it doesn't exist"
- "the most time-consuming part is to find what you're looking for"
- "would be nice to follow the trail"
- "can't get to confident decisions without common definitions"
- "a little bit of detective work and a little bit of knowledge"
- "this is what I mean when I say 'this'"
- "we haven't the foggiest idea of what the denominator is"
- "you get the data and it's not what you meant"
- "some people just want to call it something different"
Access to Data
Oftentimes, there are very few people with the "know-how" and the tools to access data. Users who do have direct access feel they must navigate a labyrinth to get to the data they need. That labyrinth includes multiple reports, accessing tables, or calling people who have knowledge of data structures. Because of this, users find it easier to maintain their own datasets instead of accessing a common repository. In most organizations, users are anxious to have access to tools to make it easier to use data.
Here is what clients have said:
- "we got to know what the hell we got"
- "our issue isn't so much storage, it's access"
- "quit parking data on some machine"
- "a whole lot of horsepower to pull data out of that system"
- "you have to have your DNA tested before you get access to it"
- "not knowing something exists is a greater liability than not using what is available"
- "a lot of what we're doing seems so hard"
- "information does not seem readily available"
- "manual data exercise to put it together"
- "we have so much information out there in so many places"
- "Excel becomes the big workhorse"
- "we've created a process to deal with lack of access to information"
- "want to hire an analyst, not a SQL person"
- "high-priced analyst just getting data for people"
Trust in Data
Users want the ability to make solid decisions on trusted data that is deemed a definitive source of truth. However, users feel there is a lack of consistency across data sources. Some of the reasons for this could be related to data latency, poor data collection practices, a lack of data understanding (e.g., data acceptance, service level agreements, data remediation, and data profiling), or different groups creating and maintaining their own copies of data. This results in users feeling they spend a significant amount of time validating or defending the data they do use.
Here is what clients have said:
- "depending on which query you run you get a different answer"
- "can't create individual sources of truth"
- "the place we pull the data from doesn't balance to itself"
- "we don't know how reliable the data is"
- "you trust the data until you know it's not right"
- "if you can't fix the problem you work around it"
- "how do we know what an error looks like?"
Data Integration
Data integration consists of processes for moving and combining data that reside in multiple locations and providing a unified view of the data. In many...
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.