He Found Article On Data Warehousing Misleading
To The Editor:
I was surprised by the content of Patrick Kassebaums article, “Do Insurers Really Need A Data Warehouse?” in the May 14 issue.
As an experienced data professional participating in the success of the business employing me, I have never read a data-related article that I felt was so misleading.
Kassebaums article is passionate, but I can’t decide whether it represents a true concern for an insurance business’s competitive advantage or whether it is misdirected anger at IT management. There should be anger for whoever explained data warehousing (DW) in preparation for the article! Seriously, the articles condemnations of the sound practice of DW do not reflect any knowledge of how data and databases can be successfully managed.
Go to a DW training class right away! There, one will learn that in DW the whole data conversion process is not repeated for every new business need. Because the integrated data in DW is based on the whole enterprises business data requirements, independent of application systems, its available and easy to access for any new or improved business process.
Take a closer look at how medium-to-large businesses use information technology. Business functions like underwriting, marketing and customer services create much of the same data but process them in different ways.
Data redundancy can be tolerated for data stores of these different “operational” uses, but for DW “decision support” use the data has to be brought together to understand how the whole enterprise is doing.
You know, the IT language can be difficult to understand, but the meaning of some words should be clearly obvious. However, in its criticism of DW providing “scrubbed” data, the article is way off. One only needs to do the dishes to understand that to be scrubbed is to be cleaned. DW data scrubbing adds value to data. Rather than data losing “its richness and particularity,” it just loses the garbage.
Ironically, many of the articles stated DW flaws are actually quite the opposite. For instance, DW hindering “a modern firms need to respond rapidly and effectively to changing business needs” is a blatant reversal of what is commonly stated as DW justification–flexibility for meeting changing business needs is a documented advantage of data warehousing!