CalOptima Deploys Data Warehouse with Melissa’s Help

Author | Case Studies, Case Study, Data Quality, Data Quality Components for SSIS, Data Warehouse, Global Data Quality | , , , , , , ,

Find out how CalOptima successfully deployed a data warehouse with the help of Melissa’s easy-to-integrate Data Quality Components for SQL Server to turn such a tremendous undertaking into a simple task.

CalOptima, a county organized health system, serves more than 400,000 members, making it the second largest health insurer in Orange County, CA. CalOptima embarked on a mission to migrate its membership data into a single data warehouse in hopes of improving communications, better serving members and growing its business.… Read More

Managing Unique Customer Identities with Master Entity Indexes

Blog Administrator | Address Quality, Analyzing Data, Analyzing Data Quality, Customer Identities, Data Integration, Data Management, Data Matching, Data Quality, MDM | , , , , , ,

By David Loshin

In the past few entries in this series we have basically been looking at an approach to understanding customer behavior at particular contextual interactions that are informed by information pulled from customer profiles.

But if the focal point is the knowledge from the profile that influences behavior, you must be able to recognize the individual, rapidly access that individual’s profile, and then feed the data from the profile into the right analytical models that can help increase value.… Read More

Justifying Data Quality Management

Blog Administrator | Address Quality, Analyzing Data, Analyzing Data Quality, Data Quality, Data Warehouse | , , , , , ,

By David Loshin

Last week I shared some thoughts about a current client and the mission to justify the development of a data quality program in an organization that over time has evolved into one with distributed oversight and consequently very loose enterprise-wide controls.

The trick to justifying this effort, it seems, is to address some of the key issues impacting the usability of data warehouse data, as many of the downstream business users often complain about data usability, long times to be able to get the data for their applications, and difficulty in getting the answers to the questions they ask.… Read More

On the Road with SQL Server Saturdays

Blog Administrator | Uncategorized | , , ,

By Ira Whiteside

Melissa Data’s BI Architect

 

We are planning on sponsoring and/or presenting at several SQL Saturday events this year as well at the NEW SQL Rally in Orlando in May. Our themes will implement Metadata Marts and Advanced Fuzzy Matching. Our presentations will be 90 percent live demos, and sample code will be available.

 

I’ve listed the currently planned schedule below.… Read More