We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Blog: Claudia Imhoff Subscribe to this blog's RSS feed!

Claudia Imhoff

Welcome to my blog.

This is another means for me to communicate, educate and participate within the Business Intelligence industry. It is a perfect forum for airing opinions, thoughts, vendor and client updates, problems and questions. To maximize the blog's value, it must be a participative venue. This means I will look forward to hearing from you often, since your input is vital to the blog's success. All I ask is that you treat me, the blog, and everyone who uses it with respect.

So...check it out every week to see what is new and exciting in our ever changing BI world.

About the author >

A thought leader, visionary, and practitioner, Claudia Imhoff, Ph.D., is an internationally recognized expert on analytics, business intelligence, and the architectures to support these initiatives. Dr. Imhoff has co-authored five books on these subjects and writes articles (totaling more than 150) for technical and business magazines.

She is also the Founder of the Boulder BI Brain Trust, a consortium of independent analysts and consultants (www.BBBT.us). You can follow them on Twitter at #BBBT

Editor's Note:
More articles and resources are available in Claudia's BeyeNETWORK Expert Channel. Be sure to visit today!

One of the questions that I get quite often is "Do I need to create an enterprise data model?" In the case of a recent phone call, the caller stated that his company never built applications; they only bought off the shelf software so why would he need such a data model. Here are my reasons for creating the model despite the buy versus build philosophy.

The caller's company had bought a set of a large ERP vendor's modules. Now they were looking at another ERP vendor for a new module. They also purchases CRM applications and even BI ones. Why should his group worry about an enterprise data model (EDM)? I told him that basically there were two main reasons (there are other smaller ones but let's stick with the biggies):

1. The purpose of the EDM is to capture or document the "ideal state" of the corporation's data needs. In other words, what data is needed (the attributes and entities of interest to the company), how it is associated with other data (the important relationships between entities), the business rules behind the associations (is it a mandatory or optional relationship?), and so forth. When buying a COTS piece of software, you would use your data model to determine how closely the application will match to your ideal state. The analysis should determine where there is a perfect match and the software will support your needs exactly -- where the application is close but not perfect and some modification or tweaks to the software may be needed - and where there is no match at all and either the corporation must change the way it currently does business or look for another application that is closer to their ideal. Without the EDM, I don't know how you can make such an assessment of fit.

2. Since no company seems to have a fully integrated set of operational systems (even these folks had different ERP and CRM vendors involved), some sort of "ideal" or master set of translation tables will be indeed. The EDM can serve that purpose as well. With the EDM in hand, you have a means of mapping one application to the other using the EDM as "translation tables" to ensure smooth integration. The definitions of the data, documented relationships between the data, and so on, will ensure that a proper integration can occur.

Hopefully these thoughts will help you justify the need for an EDM in your own organization. As always, I welcome your input and experiences along these lines.

Your in BI success,


Posted April 26, 2005 10:29 AM
Permalink | 5 Comments |


pls give me an example of enteprise data model

I am currently doing a project for my A levels, and one task is to create a data model for a new blog hosting website.

Any information, or insight into how you would go about doing this would be much appreciated. I can be e mailed on champagnemania@hotmail.com

I assume I will need entities such as Member, Blog, Blog entry, and Comments, but I'm really not sure.

Thank you


If you can't provide a sample, do you know where I can track one down? I too am working on an ERD and would love to "borrow" ideas.

This is a great idea in theory, but I've never seen it amount to much in practice.

Very good article, short and to the point. I am proposing creating Enterprise Process Model and Enterprise Data Model as priliminary work for ERP implementation, this article is a great help!

Thank you Claudia!


Leave a comment


Search this blog
Categories ›
Archives ›
Recent Entries ›