Consider that you have been tasked with building a data mart for the purpose of analyzing a customer value portfolio based on all customer interactions including telephone inquiries, purchases, returns, customer service calls, payment history, etc. You must determine what organizations are going to be supplying data, how and when the data sets are to be supplied, and how the data is to be organized and modified for integration into the data mart. In addition, you must be able to manage the quick integration of new data sets when they are determined to be included in the data mart. Alternatively, you must be able to manage the provisioning of information services to the business analysts, each of which may be logically or physically located in a different location. To get a handle on how to manage this data mart, it would be useful to have a high-level model for the process of populating and using this data mart.

In this case, the model most likely will take on two aspects – the flow of information into the data mart from its suppliers and the flow of information from the data mart to its users. The first flow is likely to be more of an operational flow, where data sets may be extracted and moved in large chunks to a staging area where those data sets move through different processing stages. Despite the business intelligence aspect of the users' interactions, the information flow between the data mart clients may likely resemble a transactional information flow, with multiple analysts executing sequences of queries.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access