Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

Resource Portals
Analytic Applications
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
More Portals...


Information Center
DM Review Home
Conference & Expo
Web Seminars & Archives
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Industry Events Calendar
Vendor Listings
White Paper Library
Software Demo Lab
Monthly Product Guides
Buyer's Guide

General Resources
About Us
Press Releases
Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Knowledge Integrity:
The Business Value of Information Flow Modeling

  Column published in DM Review Magazine
May 2003 Issue
  By David Loshin

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.

In my last column, we looked at the concept of an information flow model. This provided a framework for describing the "factory-like" propagation of information between different types of processing stages in transactional, operational and intelligence applications. This month, we will look at the value of using such a model.

There are some major benefits for building an information flow model. One is that understanding an information flow provides logical documentation for the business process. Another is that it exposes potential for adding value through the kinds of analytical processing we will discuss in later columns. A third benefit of this business modeling process is in communicating user requirements to the implementation team. When a formal framework is used to describe a process, it not only eases the translation of user needs into system requirements, but also provides the manager with a high-level view of how control migrates throughout the system and how information flows through the system - both of which, in turn, help guide the dissection of the problem into implementable components.

More generally, an information flow, as embodied as part of a business process model, provides these kinds of benefits:

Development Road Map: Identifying how information is used and diffused helps direct the development of interfacing between the discrete execution components, as well as tracking development against the original requirements.

Operational Road Map: When the application is in production, the model provides a description of how any analytical data sets are populated, as well as a launch point for isolating problems in operation. The model also allows for tracking and isolating data quality problems, mapping workflow and control back to information use, and exposing opportunities for optimization.

Management Control: This model provides a way to see how information propagates across the organization, identify gaps in information use (or reuse) and expose the processes involved in information integration.

Return on Investment Calculation: This allows the manager to track use of information, the amount of value-adding processing required and the amount of error prevention and correction required to add value. It also allows the manager to relate the eventual business value back to the costs associated with generating that business value.

It is not easy to adapt this kind of modeling framework, mostly due to management issues and the politics associated with data. Probably the most critical management issue associated with business process and information flow modeling is the disconnect between the representation of the model and the actual implementation. There are a number of proposed standards for business process modeling, although the unified modeling language (UML) and use-case analysis probably integrate the most popular methods.

The real issue lies in that despite the availability of CASE tools using UML or use cases, the output of these tools most likely will not be in a form that is easily integrated with legacy systems without a lot of external effort. In addition, even if these tools are used to generate code for actual use, there is little support for what could be referred to as the "round-trip," where generated code is modified or retooled for some reason, but that modification cannot be recaptured in the original modeling framework.

These issues imply that without a lot of investment in software infrastructure and management, the utility of a business process flow model is limited to management purposes, and positive input must be made by management to relate application development and operation back to the model. This means that there must be frequent synchronization between the documented model and the actual system itself.


For more information on related topics visit the following related portals...
Knowledge Mgmt..

David Loshin is the president of Knowledge Integrity, Inc., a consulting and development company focusing on customized information management solutions including information quality solutions consulting, information quality training and business rules solutions. Loshin is the author of Enterprise Knowledge Management ? The Data Quality Approach (Morgan Kaufmann, 2001) and Business Intelligence ? The Savvy Manager's Guide and is a frequent speaker on maximizing the value of information. Loshin may be reached at loshin@knowledge-integrity.com.

Solutions Marketplace
Provided by IndustryBrains

Enabling the Dynamic Enterprise with CommerceQuest
CommerceQuest offers a complete set of scalable enterprise business process management (BPM) software products and business solutions. Click here to learn more and download free white papers.

Bowne Global - The Language Services You Need!
We are the leading provider of translation, technical writing, interpretation services & more! We enable you to deliver locally relevant & culturally connected products, services & communications anywhere in the world! Request more information today!

Integration Simplified: More Value from IT Efforts
Free from BEA: Guide to Unified Application and Business Integration. Learn how to speed and simplify integration initiatives, reap business value more quickly, and make IT more responsive to real-world needs. Free white papers, case studies, more.

Online Courses in Statistics
3-4 week courses in data mining, market segmentation, survey stats, intro stats, regression, logistic regression, time series forecasting... Interact with instructors - leading experts. No set hours - go online at your convenience. 10 hrs/week.

Online CRM solutions from Salesforce.com
Online Customer Relationship Management solutions - sales force automation, customer service and support, and marketing automation. All this and no software! Designed for rapid deployment and adoption. Free 30-day Trial.

Click here to advertise in this space

View Full Issue View Full Magazine Issue
E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2005 DM Review and SourceMedia, Inc. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.