Untangling your unruly data

By Mary Brandel, Computerworld |  IT Management/Strategy, data management Add a new comment

Many of today's cost-conscious food shoppers buy store brands -- like Costco's Kirkland or Stop & Shop's Nature's Promise -- rather than national brands. Industry figures show that nearly 1 out of 4 products bought in U.S. supermarkets last year was a private-label brand.

For Daymon Worldwide Inc., which helps retailers market private brands, the industry boom required a major overhaul of IT and business processes to support 5,000-plus suppliers, over 120 retailers and 500,000 products. "We've had to quickly change to stay ahead of the market and keep up with growth," says Abhishak Beniwal, senior director of IT.

A key step was to get control of the company's sprawling collection of product and supplier data, by using a set of processes and technologies called master data management (MDM).

Case Study: Health Care Service Corp.

Implementers are quick to say that master data management initiatives are only as good as the processes and people surrounding them. To that end, Rick Biederstadt, divisional vice president of enterprise information strategy and management at Health Care Service Corp. (HCSC), took steps to ensure that momentum would continue on the organization's MDM initiative.

The health insurer turned to MDM primarily because it wanted to start viewing its 12.5 million members as individuals, rather than as a big collection of members, and to lower health care costs by supporting each individual's wellness. That goal required creating a unique identifier for each member and collecting profile data in one place, to enable a 360-degree view of each person's interactions with the health care system, Biederstadt says.

He chose MDM technology from IBM for the project, which began in early 2009. By July 2009, HCSC had completed its first data load and established governance processes. By late 2009, the MDM system had gone live and, according to Biederstadt, was generating business benefits.

For instance, obtaining a single view of a member led to better retention and improved customer satisfaction scores. The improvements in data management also reduced the organization's exposure to regulatory compliance penalties.

These successes would have been impossible, Biederstadt says, if the overall culture at HCSC hadn't also undergone a transformation: As part of the MDM effort, employees were encouraged to embrace accurate customer data as an important corporate goal.

The key was changing the mind-set of employees about who owns the data, a change that requires executive sponsorship, careful governance and continual communication. HCSC even had cards printed with a capital "E," for "Enterprise," and asked employees to affix them to the back of their ID badges. This was meant to remind them that data is an enterprise asset, Biederstadt says.

"When people started to think locally or divisionally about data, we asked them to turn their badge around," he explains. "Anyone could hold up their E card and start thinking of data belonging to the enterprise again."

--Mary Brandel

Before Daymon began its MDM initiative last year, its product and supplier information was maintained by numerous people in 200 offices around the world, and each change had to be made directly in every line-of-business application.

Today, one centralized group validates the data, which flows to an MDM system from Kalido Ltd. The data is stored in an enterprise data warehouse and is routed to the appropriate line-of-business applications. Invalid or incomplete data is routed to the right individual in the business who can correct it, to maintain data quality.

Now, when a new product is introduced or new packaging is requested, the change is "a simple business exercise" that can be accomplished without touching operational systems, Beniwal says. Furthermore, the cost of managing supplier information has decreased, and Daymon can move into the types of advanced analytics that will enable it to capitalize on future growth opportunities in the private brand business, he says.

So, What Is MDM?

As companies such as Daymon tackle today's business challenges, many are facing the hard truth that they need to go back to the mountains of poorly managed customer, product, supplier and employee data that has accumulated over the years and make some sense of it. That's where MDM comes in.

In a recent survey of 131 companies by analyst firm Information Difference Ltd., 42% of respondents said they had implemented or were in the process of implementing an MDM project. Nearly one-third reported having deployed two or more MDM programs. Just 22% said they had no plans to implement MDM.


Originally published on Computerworld |  Click here to read the original story.

ITworld LIVE

IT Management/StrategyWhite Papers & Webcasts

White Paper

The Cloud: Reinventing Enterprise Collaboration

Collaboration and content sharing are not, of course, new concepts. But cloud computing has changed the nature of collaboration, content sharing, document storage and project management to enable more efficient, faster-acting and cost-effective enterprises. According to a new study by IDG Research, the vast majority of knowledge workers (86%) placed a very high level of importance on collaborating with internal coworkers and external stakeholders, and having access to the most up-to-date corporate information. Read how organizations are realizing massive productivity gains by transitioning their content management solutions to cloud-based models.

White Paper

Empowering Your Mobile Worker

Today's most productive employees are mobile, and your company's IT strategy must be ready to support them with 24/7 access to the business information they need across a range of mobile devices.See how corporations are meeting the many needs of their mobile workers with the help of Box.

White Paper

Market Landscape Report: Online File Sharing and Collaboration in the Enterprise

The trend toward "consumerization" marches onward in IT; more and more end-users are choosing their own hardware plaforms and software applications in lieu of the IT-sanctioned business tools provided by their companies. These end-users are looking to tackle issues like data sharing, portability, and access from multiple intelligent endpoint devices, creating a conundrum for IT as it needs to balance business enablement, ease of access, and collaborative capacity with the need to maintain control and security of information assets. This need for balance is one of the drivers of the fast growing online file sharing and collaboration segment of the SaaS market. This paper examines the market drivers, inhibitors, and top vendors in this segment, including Box, Citrix Sharefile, Dropbox, Egnyte, Nomadesk, Sugarsync, Syncplicity and YouSendIt.

White Paper

Sharing Simplified - Consolidating File-sharing Technologies

Employees need to share content with colleagues within their organization and outside. Yet, ECMs make it hard to share content within a business and impossible between organizations. Read how one company consolidated multiple file sharing technologies to increase productivity and reduce complexity.

White Paper

Content Sharing 2.0: The Road Ahead

A growing number of companies are taking advantage of the natural synergies that exist between cloud-based IT services and content access and sharing. Legacy content management and collaboration systems simply weren't designed to meet the evolving requirements of today's IT and business managers, as well as the needs of content users. Box provides cloud-based content storage, access and collaboration services that require virtually no user training and supports file access and delivery on almost all popular PC and mobile devices. Read how Box let companies rapidly implement a cost-effective and secure content storage and sharing system that can easily expand to accommodate any size and number of files.

See more White Papers | Webcasts

Ask a question

Ask a Question