4 building blocks of data integrity - Image by Gerd Altmann from PixabayDigital transformation is opening doors to new possibilities through data-driven innovation. At the heart of this revolution lies a proliferation of connected devices. These are supported by vastly improved capabilities for collecting, storing, manipulating, and analyzing data. For organizations that wish to unleash the potential of all their data and achieve their digital transformation objectives, data integrity is critically important. Data integrity – accurate, consistent, and contextual – provides data you can trust to make confident decisions.

The popular refrain “data is the new oil” has never been more true. But in turn, neither has “garbage in, garbage out.” Data is treated as a strategic asset. Therefore, it follows that lack of data integrity may result in bad decisions and a flawed strategy. Data integrity has become a business imperative for organizations that wish to remain competitive.

Enterprise-wide data integrity is built on four key elements: data integration, data quality, location intelligence, and data enrichment. Together these provide the accuracy, consistency, and context that’s crucial to data-driven decision-making. Let’s examine each of these in detail.

Data integration

Data Integration quote (Image Credit: Precisely)Most complex enterprises rely on multiple (often disjointed) applications to manage data on customers, prospects, vendors, inventory, employees, and more. Those applications often operate in a silo. It becomes impossible to create a clear, unified view of the business. It’s a bit like looking at a few pieces of a jigsaw puzzle and trying to imagine what the completed picture should look like.

To make matters worse, these various software systems often speak different languages. In the ERP system, a customer is a customer. We care about a customer’s warehouse locations, billing addresses, and so on. In CRM, we may see accounts, prospects, and leads. Therefore, we might prefer to focus on the individual people who make purchasing decisions.

So, how do we get a holistic view of our customers and potential customers? Tying multiple systems together requires some level of mapping and translation. Integration of data from across the enterprise, whether in mainframes, relational databases, or enterprise data warehouses, requires a carefully considered approach to bringing all of that data together under one roof, in a way that makes sense in terms of the organization’s strategic goals.

Data quality

Data Quality quote (Image Credit: Precisely)Once an organization has managed to break down data silos, a common problem remains, data quality. Despite integrating multiple systems, data may be missing, inaccurate, inconsistent, or may contain duplicates.

For example, it’s common in CRM systems to see the same customer listed under multiple names. It is especially true when the name is abbreviated (NEC, IBM, or 3M). It also happens when the company operates under a Doing Business As (DBA). This can reduce efficiency and increase costs in marketing due to duplicate contact records.

When data is integrated from multiple sources or examined from a single database, it is often inconsistent. Different formats may be used for street names, abbreviations, phone numbers, and more.

When poor data quality exists at scale, e.g. when you have many of these problems, there are serious implications for analytics. Imagine the aforementioned problem with duplicate prospects in the CRM system. Now multiply that by 100 or 1,000 or 1,000,000. The result could be a significant inability to understand a customer base and market to them in a targeted and cost-effective way. That, in turn, can lead to disastrous business decisions. Data quality is critical to the accuracy and consistency of data.

Location intelligence

In the era of digital transformation, companies cannot afford to ignore the potential value of location intelligence (LI). Adding location-based insights and analysis to data that has been integrated and made accurate and consistent, elevates its usefulness in decision making.

Addresses, just like company names, may be entered in different ways by two different employees. A road or street may be known by two different names, e.g. “Main Street” and “State Route 25”. It means systems should be capable of understanding that they are, in fact, the same location.

Postal codes, likewise, can be problematic if recorded incorrectly. As any company that regularly ships via UPS or FedEx knows, zip code errors cost money. If you are mapping your existing customers to zip codes to select a new store location, however, such errors may add up to a significantly bigger problem.

Location intelligence brings crucial context and location precision to enterprise data. Understanding the difference between a customer’s billing address and their shipping address is important. For example, if you operate a fleet of delivery vehicles, that’s a critical distinction. Location intelligence provides an even higher level of precision by distinguishing the exact location where deliveries should occur. Should it be the loading dock in the back of the building or the front door entrance?

Data enrichment

Data Enrichment quote (Image Credit: Precisely)To fully build a competitive advantage, many enterprises are looking to data enrichment. When accurate third-party data related to location, business, climate, or consumer demographics is combined with existing data assets, the whole adds up to more than the sum of its parts. That critical context helps add another dimension to the data on which to base decisions.

Imagine, for example, that you operate a chain of family restaurants, and you’re looking for new locations. If you know where your current customers live (because you run a loyalty-card program, for example), you can get a general sense of the radius that a single location can serve. Unfortunately, that offers a very limited amount of information.

By enriching your data with information from external sources, you can see a great deal more detail and nuance. You might add consumer demographic data. It will allow you to better profile potential customers in your target radius. Alternatively, you might add data on points of interest to gain insight into foot traffic attracted to various areas.

Recently, organizations have begun to leverage mobility data to understand which kind of people frequent a specific area, e.g. young families, college students, or retirees, and when. Understanding where your current customers work and where they spend their leisure time, you can better understand potential new locations. By matching your current clientele with external demographic information, you can better understand who your customers are.

Data enrichment, especially with location and mobility data, offers a vast untapped opportunity for organizations that aspire to leverage data as a strategic asset.

The data integrity journey

Now more than ever before, organizations have a unique opportunity to establish a competitive advantage through the effective use of data. For those that choose to do so, data integrity is a non-negotiable requirement. By building a meaningful strategy around data integration, data quality, location intelligence and data enrichment, business leaders can lay a solid foundation for all of their digital transformation initiatives.

The Precisely Data Integrity Suite is the first fully modular solution that dramatically improves a customer’s ability to deliver accurate, consistent and contextualized data. It spans the full spectrum of data integrity, with accuracy and consistency drawn from best-in-class data quality and data integration, and the critical element of context from market-leading location intelligence and data enrichment.

To learn how 300+ C-Level data executives in the Americas, EMEA and Asia Pacific are managing enterprise data assets to fuel reliable data-driven business transformations, read the research report from Corinium Intelligence, Data Integrity Trends: Chief Data Officer Perspectives in 2021.

PreciselyPrecisely is the global leader in data integrity, providing accuracy, consistency, and context in data for 12,000 customers in more than 100 countries, including 97 of the Fortune 100. Precisely’s data integration, data quality, data governance, location intelligence, and data enrichment products power better business decisions to create better outcomes. Learn more at at www.precisely.com.


Please enter your comment!
Please enter your name here