Enterprise Data Warehouse Is The Next Step In Data Warehousing

Enterprise Data Warehouse Is The Next Step In Data Warehousing

By

The insurance industry is well known for acronyms such as CRM and ERM (customer relationship management and enterprise relationship management, respectively).

Now we welcome the newest member of the club: EDW, better known as the enterprise data warehouse. The EDW is the next logical step in the data warehouse evolution chain. And its a concept that is just beginning to catch on in many industries, including insurance and health care.

No other industry has more information on its customers than insurance companies. For years, data has been collected, stored and analyzed in separate databases that have been built around business units and functions. Over time, these separate data stores have grown both in number and size. And while the more recent idea of pushing data integration sounds good, the lesser of two evils has been to use a Band-Aid approach to a growing data problem. Hence, the proliferation of data marts across an organizations IT infrastructure.

But in todays world of understanding and catering to the customer, managing these disparate sources of data is kind of like herding cats. Its an expensive proposition that increases the complexities of maintenance, flexibility and performance. And while it originally made sense to create data marts around a particular business unit or line of business, the flaw lies in the fact that the information is rarely shared outside their own boundaries. Its like being in a dark room with a small flashlight that only illuminates a fraction of the room at any one time.

There is a new movement afoot for consolidating the myriad of data marts as companies seek the “single version of the truth” afforded by the centralized data warehouse. Sound too good to be true? The benefits of switching to a centralized data warehouse are being demonstrated in industry reports and analyst studies.

Todays business managers can no longer rely on the old “gut feel” or “best guess” approach to making critical business decisions. With razor-thin margins and increased scrutiny on costs and expenses, business executives are calling for timely and accurate business intelligence. The old adage “knowledge is power” still holds true today, but data is adding a new twist to the equation–value and ROI.

Enter the enterprise data warehouse. The idea of the EDW is to provide business data directly to the business users who are best able to use it for business intelligence, business knowledge and business success. The EDW offers a single data resource for all enterprise information and is designed to provide that information in a format that is accessible to everyone, using applications that are in real business terms, in near-real time.