AIA Insight · Data Management

Know Where Your Data Is.

A metadata repository can move an organization from “data mystery” to “data mastery".

Originally published in Best's Review, May 2014 · Bill Jenkins
01 · The Insight

From data mystery to data mastery.

The value of enterprise data depends on knowing what it means, where it came from, how it is used, and how it changes.

Insurance organizations depend on data for pricing, underwriting, profitability, claims, reporting and business intelligence. Yet different systems and business definitions can make it difficult to understand and consistently use that data.

Metadata is data about data. It adds context and meaning by describing who produced the data, when it was produced, its format and business meaning, and which systems use it.

A centralized metadata repository provides a common place to document definitions, usage, sources, lineage and changes across the enterprise. It becomes a reference point for understanding data assets and supporting data management and governance.

“Know where your data is” is not simply a technology question. It is a management question involving meaning, ownership, lineage, accountability and use.
02 · What the Repository Provides

A central reference for enterprise data.

The article describes a repository as a mechanism for capturing, organizing, maintaining, modeling, integrating, sharing, visualizing and analyzing information about an enterprise's key data elements.

01 · Definition

Business Glossary

A common listing of important business terms, their definitions, usage and relationships to organizational data.

02 · Movement

Data Traceability

The ability to follow data from its source through its flow and ultimately to its target or use.

03 · History

Data Lineage

A history of how data was received or originated, where it was used and, when applicable, when and by whom changes occurred.

04 · Accountability

Data Governance

Links data to associated owners to establish accountability, stewardship and an approval process for changes.

03 · Seven Benefits

Why metadata becomes a business capability.

The article identifies seven practical benefits from establishing a centralized metadata repository.

/ 01

Simplify Data Discovery

Create a central catalog that makes data assets easier to search, understand and use.

/ 02

Reinforce Consistency

Increase reuse, reduce redundant data and applications, and support productivity and cost savings.

/ 03

Reduce Knowledge Drain

Preserve knowledge about where data is stored, what it means and how it is used.

/ 04

Increase Confidence

Track data flow, lineage, derivation and processing to provide important context to business users.

/ 05

Improve IT Responsiveness

Make data locations, meanings and relationships more visible to support development and integration.

/ 06

Provide Transparency

Support compliance, auditability and the ability to retrace data changes and transformations.

/ 07

Support Mergers & Acquisitions

Help organizations inventory and understand data assets during consolidation and integration.

04 · Insurance Example

When business rules change, lineage matters.

The article illustrates the issue through claims processing and changes to the allocation of certain claim expenses.

The situation

Research found shifts in an expense category after business rules changed the method used to allocate certain expenses in the claims reporting process. The changes were documented in procedure manuals and Word documents, but that information was not readily visible to everyone involved.

The repository role

A centralized repository provides a place to identify where data exists, how it flows, where it ends up in reports, and who needs access to it. It provides a reference for data definitions, business rules and changes.

05 · Making It Work

Four capabilities form the foundation.

Business Glossary Data Traceability Data Lineage Data Governance Central Metadata Repository

The repository is intended to function as a reference manual for enterprise data — a central mechanism for maintaining information about data assets across multiple sources.

The article's framing is straightforward: data management becomes more effective when the organization can discover its data, understand its meaning, trace its movement, establish ownership and understand change.

Why this still matters

The technology environment may change, but the management challenge remains: organizations need a reliable way to understand the data supporting their business processes, reports and decisions.

Original AIA Insight

Know Where Your Data Is

Read the complete two-page article originally published in Best's Review.

Read article →
Data Management · Governance · Analytics

Do you know where your critical data is?

AIA helps insurance organizations establish the data foundations needed to make information understandable, traceable, governed and usable.