Data Governance: When Excel Doesn’t Cut it Anymore

View all posts on Tools & Technology

Data Governance when Excel Doesn't Cut it Anymore

To anyone in the trenches associated with Data Governance and Enterprise Data Management, one thing is certain: it is a daunting task. Data should be put high on a pedestal – after all, it’s the core foundation that all business processes, applications and reporting tools execute against! How is it possible that it often falls low on the priorities list across the enterprise… until something goes wrong? Usually at the point of failure in a business process or the inability to secure analytical insight, only then is data governance thrust into the spotlight. Often the prescribed “cure” is a one-time data quality quick fix; which we all know is a temporary and futile patch. We all have heard it before, “just review these 5,000 records in this Excel spreadsheet and send me any changes.” No thanks.

At this juncture, the real opportunity is to establish a true Operating Model for Data Governance that facilitates a data dialogue with the business. And at this breakthrough moment – this golden opportunity to equate and articulate the inextricable link between data & decisions and data & process optimization, we reach into our arsenal of technology and pull out…. an Excel spreadsheet. As the air leaves the room, and the enthusiasm deflates, the business owners start to roll their eyes. The business needs to appreciate “ How and Why” data governance impacts them, as well as, understand how they can partner with you to do things easier related to data management. A data dialogue is needed, and Excel doesn’t cut it.

For example, the Chief Customer Officer wants customer insight, cross selling and up selling, the desirous 360 degree view of the customer, customer profitability analysis, etc… they do not, I repeat, do not respond well to an excel spreadsheet where rules and standards are kept. Without the data dialogue to explain the importance, executives may struggle to see the link between these rules and standards and the business insight they want. However, executives do look for the enforcement of data-business policy. This is where we must evolve beyond the storage and organizational capabilities of Excel. An alternative and evolved approach is to capture, define, manage and maintain data policy with an interactive, workflow-based, and process-centric platform. Information Value Management or IVM is one such platform. IVM by DATUM provides a path to engage the business intelligently: focusing on Rules, Standards, Processes and yes, Measures and Metrics which maps Data to the Business. Rules which historically were “trapped” in Excel are now front and center for the business to embrace and participate in the process of getting the data right – every time. The IVM platform helps facilitate and guide a data dialogue where data- business ‘policy’ can be a collaborative effort between the Data Management Organization and the Business. IVM allows for your Data Governance Operating Model to come through in a logical way without baggage of Excel.

If Excel is not cutting it anymore, we’d like to show you what IVM can do for you. Contact us for a live demo!

Request a demo