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

Business Intelligence: 360 Insight:
Integrated View of Customer: Enabling Customer Insight

  Column published in DM Review Magazine
March 2003 Issue
  By Shari Rogalski and Dan Fisher

Shari would like to thank Dan Fisher for his contribution to this month's column.

The customer is king. The customer is always right. Remember, the customer pays the bills around here. When you think about it, there is a lot of truth in all of these clichs about customers. Regardless of the size of your organization or the industry that you are in, without the customers, there are no sales, there are no revenues and there are no profits.

This is the reason companies invest enormous amounts of time and resources in customer relationship management (CRM). The equation is simple: When you implement capabilities that help you learn more about your customers, you retain existing customers, attract new customers, can offer new products/services, can advertise more effectively and can ultimately garner additional profits. The key is to capitalize on the full potential that CRM and customer insight capabilities offer; that is, use and not just gather customer data.

In our last column, we discussed how 360-degree insight enables C-level executives and organization leaders to integrate and analyze information from their organizations' siloed competencies. In the next two columns, we focus on the customer silo and an integrated view of the customer. Key customer metrics, trends and forecasts, when merged with metrics from other functional silos, affect decision making and exemplify 360-degree insight. The challenge with each siloed process is closing the loop - that is, applying what you have learned to make strategic decisions that impact your organization's competitive advantage.

Integrated View of Customer

Accenture often uses the term "integrated view of customer" to describe business intelligence processes related to enabling customer insight such as data integration, data standardization, enterprise reporting and business analytics.

To integrate customer information, relevant data must be captured and merged from several different types of systems:

  • Customer touchpoint systems such as point of sale, call centers, the Web and direct mail,
  • Back-office systems such as general ledger and accounts receivable,
  • Internal assessment systems such as segmentation scores, propensity scores and risk scores, and
  • External data provider systems such as credit histories and demographics.

Customer information is typically integrated and standardized using extract/transform/load (ETL) tools, enterprise application integration (EAI) tools or enterprise resource planning (ERP) packaged software.

Before the data from these various systems can be integrated and merged, however, the customer must be defined and assigned a unique customer identifier. At first, this might sound simple, but when organizations actually begin to define their customers, things can get tricky. For example, while defining a customer at a recent client organization, six individuals provided the following very different definitions: accounts, individuals who can have multiple accounts, households that can be made up of multiple accounts and individuals (not all individuals may be on all accounts), companies, departments within companies, and individuals within departments and within companies.

After you define the customer, you can define rules for matching customers with varying definitions across data sources. There are several vendors with software packages that provide solutions for such customer identification services. These services range from packaged routines to tools for building custom services to outsourced solutions. Many factors should be considered when choosing a customer identification solution, including cost, customer definition, rule complexities and the number of disparate data sources.

Unless your organization has one store, one system and/or one client, you must integrate and standardize your customer data before you can create reports and conduct customer analysis. A complete view of the customer allows an organization at all levels to better understand its customers and empowers individuals to act in the organization's best interest. Store managers might receive a report identifying their 200 most profitable customers and can educate employees as to who should receive special treatment. Risk managers might mine data to identify the customers who are most likely to default on a loan and implement screening procedures to improve credit approval. Marketing managers might mine data to create customer segmentations and propensity models for customizing and targeting sales campaigns. C-level executives might receive customer trending reports and initiate ROI analysis reports to drive strategic change initiatives.

Most organizations capture and integrate some customer information to learn about their current and potential customers and to make astute business decisions. Far fewer organizations, however, actually close the loop by tracking and feeding the results of their decisions back into their customer relationship management application. You must close the loop to acquire an integrated view of customer and gain true customer insight.

There are several challenges inherent in closing the customer loop. In our next column, we will discuss the following issues, including how they impact an integrated view of the customer and what techniques can be used to address them:

  1. Individualization/householding/customer matching.
  2. Consumer privacy and regulatory restrictions.
  3. Managing internal source systems and external data vendors.

Customers are the lifeblood of every organization and an integrated view of the customer is critical to 360-degree insight.


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

Shari Rogalski is a partner with Accenture and currently leads Accenture's North American Business Intelligence practice. Accenture's Business Intelligence practice specializes in data warehousing, enterprise reporting, performance management and analytical applications. Rogalski leads client implementations and serves as a subject-matter expert on business intelligence applications and capabilities, both packaged/ERP and custom. Please contact Rogalski at shari.a.rogalski@accenture.com.

Dan Fisher is a senior manager with Accenture and is a member of Accenture's North American Business Intelligence practice. He joined Accenture in 1995 and is based in Dallas, Texas. Fisher leads and serves as subject-matter expert on cross-industry client implementations that include data warehousing, performance management, customer insight and analytical applications. Please contact Fisher at daniel.fisher@accenture.com.

Solutions Marketplace
Provided by IndustryBrains

Intuit Track-It! Help Desk & CRM Software
Intuit IT Solutions provides Track-It! - the leading help desk software solution for employee & customer self-help, call tracking, problem resolution, remote control, asset management, LAN/PC auditing, and electronic software distribution. Free demo

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.

Create an Ideal Foundation for Customer-Focused IT
Free guide for IT execs from BEA: Optimizing Customer Service. Learn how to boost service quality, meet fast-changing customer service needs, keep costs in check -with no need to rip and replace existing apps. Free white papers, case studies, more.

Turning Customer Loyalty into Profitability
From Bob Thompson of CRMGuru, learn how customer loyalty impacts profitability, what the latest research indicates about the gap between potential and actual CRM benefits and the ?unvarnished? truth about CRM success and failure. Download free today.

Knowledge Base Software from Novo Solutions
Knowledge Base Software by Novo Solutions - web-based, affordable, scalable, web support and documentation solutions. Robust and easy to use. Free download and trial versions available.

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.