Share E-Book

Practitioners Guide to Operationalizing Data Governance (Mary Anne Hopper)(Z-Library)

Author

Data
Language English

Discover what does—and doesn’t—work when designing and building a data governance program 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.

Format PDF
Size 5.5 MB
17
Views
0
Downloads
0.00
Total Donations
(First 20 pages)

Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

Page 1
(This page has no text content)
Page 2
Hopper851424_babout.indd 218 15-03-2023 16:25:20
Page 3
Practitioner’s Guide to Operationalizing Data Governance
Page 4
Wiley and SAS Business Series The Wiley and SAS Business Series presents books that help senior level managers with their critical management decisions. Titles in the Wiley and SAS Business Series include: The Analytic Hospitality Executive: Implementing Data Analytics in Hotels and Casinos by Kelly A. McGuire Analytics: The Agile Way by Phil Simon The Analytics Lifecycle Toolkit: A Practical Guide for an Effective Analytics Capability by Gregory S. Nelson Anti- Money Laundering Transaction Monitoring Systems Implementation: Finding Anomalies by Derek Chau and Maarten van Dijck Nemcsik Artificial Intelligence for Marketing: Practical Applications by Jim Sterne Business Analytics for Managers: Taking Business Intelligence Beyond Reporting (Second Edition) by Gert H. N. Laursen and Jesper Thorlund Business Forecasting: The Emerging Role of Artificial Intelligence and Machine Learning by Michael Gilliland, Len Tashman, and Udo Sglavo The Cloud- Based Demand- Driven Supply Chain by Vinit Sharma Consumption- Based Forecasting and Planning: Predicting Changing Demand Patterns in the New Digital Economy by Charles W. Chase Credit Risk Analytics: Measurement Techniques, Applications, and Examples in SAS by Bart Baesen, Daniel Roesch, and Harald Scheule Demand- Driven Inventory Optimization and Replenishment: Creating a More Efficient Supply Chain (Second Edition) by Robert A. Davis Economic Modeling in the Post Great Recession Era: Incomplete Data, Imperfect Markets by John Silvia, Azhar Iqbal, and Sarah Watt House Enhance Oil & Gas Exploration with Data- Driven Geophysical and Petrophysical Models by Keith Holdaway and Duncan Irving Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques: A Guide to Data Science for Fraud Detection by Bart Baesens, Veronique Van Vlasselaer, and Wouter Verbeke
Page 5
Intelligent Credit Scoring: Building and Implementing Better Credit Risk Scorecards (Second Edition) by Naeem Siddiqi JMP Connections: The Art of Utilizing Connections in Your Data by John Wubbel Leaders and Innovators: How Data- Driven Organizations Are Winning with Analytics by Tho H. Nguyen On- Camera Coach: Tools and Techniques for Business Professionals in a Video- Driven World by Karin Reed Next Generation Demand Management: People, Process, Analytics, and Technology by Charles W. Chase A Practical Guide to Analytics for Governments: Using Big Data for Good by Marie Lowman Profit from Your Forecasting Software: A Best Practice Guide for Sales Forecasters by Paul Goodwin Project Finance for Business Development by John E. Triantis Smart Cities, Smart Future: Showcasing Tomorrow by Mike Barlow and Cornelia Levy- Bencheton Statistical Thinking: Improving Business Performance (Third Edition) by Roger W. Hoerl and Ronald D. Snee Strategies in Biomedical Data Science: Driving Force for Innovation by Jay Etchings Style and Statistics: The Art of Retail Analytics by Brittany Bullard Text as Data: Computational Methods of Understanding Written Expression Using SAS by Barry deVille and Gurpreet Singh Bawa Transforming Healthcare Analytics: The Quest for Healthy Intelligence by Michael N. Lewis and Tho H. Nguyen Visual Six Sigma: Making Data Analysis Lean (Second Edition) by Ian Cox, Marie A. Gaudard, and Mia L. Stephens Warranty Fraud Management: Reducing Fraud and Other Excess Costs in Warranty and Service Operations by Matti Kurvinen, Ilkka Töyrylä, and D. N. Prabhakar Murthy For more information on any of the above titles, please visit www .wiley.com.
Page 6
(This page has no text content)
Page 7
Practitioner’s Guide to Operationalizing Data Governance Mary Anne Hopper
Page 8
Copyright © 2023 by SAS institute, Inc. All rights reserved. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per- copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750- 8400, fax (978) 750- 4470, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748- 6011, fax (201) 748- 6008, or online at http://www.wiley.com/go/permission. Trademarks: Wiley and the Wiley logo are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries and may not be used without written permission. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book. Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Further, readers should be aware that websites listed in this work may have changed or disappeared between when this work was written and when it is read. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages. For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762- 2974, outside the United States at (317) 572- 3993 or fax (317) 572- 4002. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic formats. For more information about Wiley products, visit our web site at www.wiley.com. Library of Congress Cataloging- in- Publication Data: Names: Hopper, Mary Anne, author. Title: Practitioner’s guide to operationalizing data governance / Mary Anne Hopper. Description: Hoboken, New Jersey : Wiley, [2023] | Series: Wiley and SAS business series | Includes index. Identifiers: LCCN 2023001522 (print) | LCCN 2023001523 (ebook) | ISBN 9781119851424 (cloth) | ISBN 9781119851455 (adobe pdf) | ISBN 9781119851431 (epub) Subjects: LCSH: Database management. | Management information systems—Management. | Data integrity. Classification: LCC QA76.9.D3 H6564 2023 (print) | LCC QA76.9.D3 (ebook) | DDC 005.75/65—dc23/eng/20230201 LC record available at https://lccn.loc.gov/2023001522 LC ebook record available at https://lccn.loc.gov/2023001523 Cover Design: Wiley Cover Image: © shulz/Getty Images
Page 9
For the MAC team (Faramarz, Matthias, Matt, Katie, Noah, and Liz) for all your support and For Bill for never letting me throw the term “best practice” out there without explaining “the why”.
Page 10
(This page has no text content)
Page 11
ix Contents Acknowledgments xiii Chapter 1 Introduction 1 Intended Audience 2 Experience 2 Common Challenge Themes 4 Chapter 2 Rethinking Data Governance 17 Results You Can Expect with Common Approaches to Data Governance 18 What Does Work 21 Rethinking Data Governance Summary 23 Chapter 3 Data Governance and Data Management 25 Results You Can Expect Focusing Purely  on Data Governance or Data Management 26 SAS Data Management Framework 26 Aligning Data Governance and Data Management Outcomes 38 Misaligning Data Governance and Data Management 43 Data Governance and Data Management Summary 45 Chapter 4 Priorities 47 Results You Can Expect Using the Most Common Approaches to Prioritization 48 A Disciplined Approach to Priorities 50 Utilizing the Model 55 Priorities Summary 64 Chapter 5 Common Starting Points 65 Results You Can Expect with Too Many Entry Points 66 Building a Data Portfolio 66 Metadata 67 Data Quality 70 Data Profiling 75 Common Starting Points Summary 76
Page 12
x ▸ C o n t e n t s Chapter 6 Data Governance Planning 77 Results You Can Expect Without Planning 78 Defining Objectives 78 Defining Guiding Principles 85 Data Governance Planning Summary 88 Chapter 7 Organizational Framework 91 Results You Can Expect When There Is No Defined Organizational Structure 92 Organizational Framework Roles 92 Defining a Framework 94 Aligning the Model to Existing Structures 97 Aligning the Framework to the Culture 100 Simplifying the Model 103 Defining the Right Data Stewardship Model 104 Organizational Framework Summary 109 Chapter 8 Roles and Responsibilities 111 Results You Can Expect When Roles and  Responsibilities Are Not Clearly Defined 112 Aligning Actions and Decisions to Program Objectives 112 Using a RACI Model 119 Defining Roles and Responsibilities 126 Data Governance Steering Committee 126 Data Management 131 Naming Names 131 Roles and Responsibilities Summary 135 Chapter 9 Operating Procedures 137 Results You Can Expect Without Operating Procedures 138 Operating Procedures 138 Workflows 146 Operating Procedures Summary 152 Chapter 10 Communication 153 Results You Can Expect Without Communication 154 Communication Plan Components 154 Sample Communication Plan 156 Communication Summary 160 Chapter 11 Measurement 161 Results You Can Expect Without Measurement 162 What Measurements to Define 162 Program Scorecard – A Starting Point 166 Program Scorecard Sample 172 Measurement Summary 173
Page 13
C o n t e n t s  ◂ xi Chapter 12 Roadmap 175 Results You Can Expect Without a Roadmap 176 First Step in Defining a Roadmap: Implementing Your Framework 176 Defining a Roadmap 178 Formality First or Save It for Later? 184 Critical Success Factors 185 Roadmap Summary 188 Chapter 13 Policies 189 Results You Can Expect Without Policies 190 Breaking Down a Policy 190 Contents of a Policy 192 Policy Example – Metadata 193 Policy Example – Data Quality 200 Policy Summary 204 Chapter 14 Data Governance Maturity 207 Results You Can Expect With Maturity 208 Data Governance Maturity Cycle 209 Maturing Your Program 215 Summary 216 About the Author 217 Glossary of Terms 219 Index 221
Page 14
(This page has no text content)
Page 15
xiii Acknowledgments A methodology does not create itself overnight. It takes time, encour- agement, and dedication from a lot of people. The methodology I have laid out for you is from the work and guidance of my colleagues at the SAS Institute: Faramarz Abedini, Matthias Gruber, Robert Stone, Matt Benson, Katie Lorenze, Noah Pearce, and Liz Baker. Some of you I have worked with for many years, some not quite as long. Either way, your fingerprints are embedded in the content of these pages. For that, I thank you!
Page 16
(This page has no text content)
Page 17
C H A P T E R 1 1 Introduction
Page 18
2 ▸ P R A C T I T I O N E R ’ S G U I D E T O O P E R A T I O N A L I Z I N G D A T A INTENDED AUDIENCE As long as the practice of Data Governance has been around, the con- cept 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: j Your organization is thinking about Data Governance. j You have been tasked with Data Governance. j You need to get your Data Governance program back on track. j You have acquired a tool and want to get the most value from your investment. j You continue to have the same data quality issues over and over. j 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 dis- ciplined approach to Data Management methods. The chapters cover prioritization, alignment of Data Governance and Data Management, organizational structures, defining roles and responsibilities, commu- nications, 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
Page 19
I N T R O D U C T I O N ◂ 3 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 differ- ent 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 busi- ness rules. There came a time when I transitioned into project manage- ment, 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 Man- agement 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 methodol- ogy 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
Page 20
4 ▸ P R A C T I T I O N E R ’ S G U I D E T O O P E R A T I O N A L I Z I N G D A T A 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 custom- ers 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 rely- ing 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 precur- sor to data quality; I will write more about that topic in later chapters. Here is what clients have said: j “we need Rosetta Stone for our data” j “metadata is so important and it doesn’t exist” j “the most time- consuming part is to find what you’re looking for” j “would be nice to follow the trail” j “can’t get to confident decisions without common definitions”
The above is a preview of the first 20 pages. Register to read the complete e-book.

Recommended for You

Loading recommended books...
Failed to load, please try again later

Tip the Site

Scan the WeChat Pay or Alipay code to tip. No login required.

WeChat Pay
Alipay
Back to List