A clean, non-redundant, and consistent source of enterprise master data is key to improved decision making, increased agility against competition, and better relationships with stakeholders. High-quality master data truly is the backbone of execution in any business organization.
Although this has been widely accepted, enterprises often find themselves with data that is fragmented and scattered throughout various corners of the organization. This inevitably creates the problem of decentralized ownership, which leads to data being inaccessible or inaccurate in various ways, producing insights that are unusable.
These issues underscore the importance of perfecting data quality by building a centralized, accessible repository of enterprise master data that will cultivate common definitions and create a single source of truth (SSOT). This is precisely why organizations we call digital champions have implemented master data management (MDM) systems.
What is Master Data?
Master data is the non-transactional data that uniquely defines your business; core business entities (customer, product), transaction descriptors, and reference data are all examples of master data.
Organizations embarking on a master data management system implementation have a lot to think about besides the nuts and bolts of standing up the platform. The following are additional thoughts that can be helpful for these types of projects:
There are two data groundwork activities that can be done early in the project – even before it starts – to help ensure project success. The first involves data access. This activity can range from setting appropriate permissions for the MDM project team ahead of time to tracking down obscure sources of master data (locally stored Excel spreadsheets, anyone?).
The other data groundwork activity is to eliminate any sources or subsets of master data that do not need to be considered for the new system. To this end, data profiling, identifying usage patterns, and consultation with the business subject matter experts will be time well spent. The goal is to cut down the noise and simplify the data migration.
Understandably, the focus during MDM implementations will be on the tactical aspects of standing up a new platform, populating it with data, and getting other systems and people to use that data. MDM platforms are truly at the intersection of people, process, and technology; neglecting any one can jeopardize success. But an underrepresented aspect in all of this is change management. As people are being asked to interact with company data in new ways, it is critically important to show them the value and importance of why things are changing.
Ideally, the project would have begun with a clear business case (e.g., increase customer retention, reduce product categorization errors). Sometimes, however, that message gets trapped at the executive suite. It is important that all departments and levels are aligned on this, and that benefits are demonstrated down to a very granular level. In addition, make sure that the new owners of master data feel comfortable with the system; give them plenty of transition time to gain experience, ask questions, and identify any gaps. The more confident they are with the project and the tool, the better.
Copyright © 2021 Trianz
As mentioned above, the people and process aspects of MDM system implementations are critical success factors. Within the realm of master data, the pillars of people and process are known by the collective term “data governance.” Data governance exists to provide a framework for effective decision making around master data. It establishes who can make the rules for company master data, which processes can ensure those rules are being enforced, and what steps are taken if the rules are violated.
If your organization already has an established data governance process, then great – you are ahead of the game. The MDM system implementation project just needs fit into or enhance the existing data governance framework. If your organization does not have a formal data governance process, or it needs improvement, now is the time. The best MDM system in the world will be ineffective if governance aspects are neglected.
It is almost inevitable that one or more significant data issues will be uncovered during the MDM implementation project. Project managers and project sponsors should not only expect this, but should have a plan in place for how to handle it. The recommended approach is one of triage – understanding and classifying which data issues must be handled immediately, and which ones can be pushed off until the platform is live. For instance, getting duplicative data removed through an enhanced data matching strategy is a wonderful goal for a system implementation.
However, if achieving that necessarily involves a large, manual clean-up effort, project stakeholders may wish to delay that activity until post-launch. The guiding principle here is to not let “perfect” be the enemy of “good.” Your focus should be on getting the system up and running while tackling easily achievable data goals. As the system matures, more complex or thorny data issues can be handled with time. This is where a project steering committee can play a vital role; making these types of decisions should be done transparently and with cross-functional agreement.
Keeping these MDM system considerations in mind will maximize the value your enterprise can realize when implementing a robust master data management solution. Critical to its success is having a holistic view of data management that comes from envisioning MDM as a fundamental element of organizational structure rather than “just another initiative.”
Sustained involvement from senior leadership, a constant focus on business value throughout the process, and a thorough governance framework will ensure that your MDM strategy will bear fruit for the organization.
What Is an SQL Query Engine? SQL query engine architecture was designed to allow users to query a variety of data sources within a single query. While early SQL-based query engines such as Apache Hive allowed analysts to cut through the clutter of analytical data, they found running SQL analytics on multi-petabyte data warehouses to be a time-intensive process that was difficult to visualize and hard to scale.Explore
A Winning Base for Successful Digital Transformations When it comes to developing a successful digital strategy, it is not just corporations planning to maximize the benefits of data assets and technology-focused initiatives. The Government of Western Australia recently unveiled four key priorities for digital reform in its new Digital Strategy for 2021-2025.Explore
Engage Your Workforce with a Modern Employee Intranet Solution The employee intranet has changed significantly since it was first introduced in the early 1990s. What started as HTML-based static portals have now evolved into intuitive communication tools complete with search engines, user profiles, blogs, event planners, and more. Today, many organizations are taking a second look at employee intranets to bridge gaps between teams, build company culture, centralize information, increase productivity, and improve workflow.Explore
Adopting emerging cloud technologies, consolidating resources, and improving processes is the key. “IT no longer just supports corporate operations as it traditionally has but is fully participating in business value delivery. Not only does this shift IT from a back-office role to the front of business, but it also changes the source of funding from an overhead expense that is maintained, monitored, and sometimes cut, to the thing that drives revenue,” said John-David Lovelock, research vice president at Gartner.Explore
Deliver Powerful Insights Instantaneously with Federated Queries - No Matter Where Your Data Resides The concept of federated queries isn’t new. Facebook PrestoDB popularized the idea of distributed structured query language (SQL) query engines in 2013. Over the years, AWS, Google, Microsoft, and many others in the industry have accelerated the adoption of a distributed query engine model within their products. For example, AWS developed Amazon Athena on top of the Presto code base, while Google’s BigQuery is based on Cloud SQL.Explore
What is Unstructured Data? Almost 80% of the data that enterprises and organizations collect is unstructured - data without a set record format or structure. Unstructured data includes data such as emails, web pages, PDFs, documents, customer feedback, in-app reviews, social media, video files, audio files, and images.Explore