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

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

We are involved with a DW strategy and planning a CRM strategy.

    Ask The Experts published in DMReview.com
February 3, 2003
  By Sid Adelman and Chuck Kelley and Clay Rehm and Nancy Williams


We are involved with a DW strategy and planning a CRM strategy. The company needs information now, and we can't wait for the CRM implementation. What can we do to integrate the two strategies? Finally, we have to consider the actual information requirements that we must satisfy with the actual operational systems and the CRM strategy to be implemented in 2004.


Sid Adelman's Answer: The DW strategy should include the CRM. You will be creating customer information in your data warehouse that will feed the CRM, but it's clear that you need an overall architecture that includes your operational systems as part of the source for the data warehouse and for the CRM system. Be sure that the infrastructure you build for the data warehouse is robust enough to handle the volume required by the CRM system. The infrastructure should include the hardware, the data warehouse specific software, the network, the organization (people, skills, responsibilities, etc.), and the meta data repository that will serve the data warehouse and the CRM system. Build the data warehouse infrastructure, deliver the information the organization needs now with the data warehouse but have a path to include the CRM. Be sure to let management know your plans and the timeframes for delivering each of the phases.

Chuck Kelley's Answer: It is my belief that you can not have a CRM system (or at least an integrated one) without an enterprise data warehouse. Therefore you should build the complete the data warehouse strategy and start the implementation and then when the CRM is ready, grow the data warehouse (if needed) to include CRM information.

Clay Rehm's Answer: Unless you spend the time with each strategy identifying the benefits, risks and requirements for each, integrating them on a later date will be very difficult if not impossible. They may not even have any common threads between them. Why not dedicate at least one person's time to bridge the strategies?

Nancy Williams' Answer: There are many differing and conflicting points of view on the definition of CRM and the roles that data warehousing and CRM play in an organization. I believe that the best way to ensure that your CRM and DW strategies are integrated is to review your organization's business strategy and to discuss the role that CRM and the data warehouse are envisioned to play in supporting that strategy. The integration of your CRM and DW strategies will naturally occur through this process and will ensure that your technical strategies align with your organization's business strategy.

I also believe that it is important to formulate your CRM strategy independent of vendor software. For example, your CRM strategy should identify the way in which business processes will be changed to better support customer-centric management of the organization. Unfortunately, some organizations never articulate a clear CRM strategy, but rather purchase a CRM software application that determines their CRM strategy, by default. Some CRM vendors go so far as to argue against the need for a data warehouse, since their CRM applications come bundled with customer analytics. Needless to say, the vendor has never considered other information needs that may not be fully supported by the CRM application.

It is also important to tie your DW strategy directly back to how it will support your organization's business goals. Because of timing differences, your DW strategy may also consider how the data warehouse can play a role in supporting your CRM strategy. The DW strategy could include short-term objectives for delivering customer information while the CRM strategy is under development and should also outline if and how the DW role may change once the CRM strategy is fully implemented. Finally, an analysis of how operational systems will play a role in providing information needed to support your organization's business strategy will also need to be considered.


For more information on related topics visit the following related portals...
CRM, DW Basics and Strategic Intelligence.

Sid Adelman is a principal in Sid Adelman & Associates, an organization specializing in planning and implementing data warehouses, in data warehouse and BI assessments, and in establishing effective data architectures and strategies. He is a regular speaker at DW conferences. Adelman chairs the "Ask the Experts" column on www.dmreview.com. He is a frequent contributor to journals that focus on data warehousing. He co-authored Data Warehouse Project Management and is the principal author on Impossible Data Warehouse Situations with Solutions from the Experts. His new book, Data Strategy, is scheduled for publication this year. He can be reached at 818-783-9634 or sidadelman@aol.com.  Visit his Web site at www.sidadelman.com.

Chuck Kelley is a senior architect in the business intelligence practice for Hitachi Consulting (www.HitachiConsulting.com), a globally recognized leader in delivering value-based business and IT Solutions. Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored three books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@hitachiconsulting.com.

Clay Rehm, CCP, PMP, is president of Rehm Technology (www.rehmtech.com), a consulting firm specializing in data integration solutions. Rehm provides hands-on expertise in project management, assessments, methodologies, data modeling, database design, meta data and systems analysis, design and development. He has worked in multiple platforms and his experience spans operational and data warehouse environments. Rehm is a technical book editor and is a coauthor of the book Impossible Data Warehouse Situations with Solutions from the Experts. In addition, he is a Certified Computing Professional (CCP), a certified Project Management Professional (PMP), holds a Bachelors of Science degree in Computer Science from Carroll College and is currently working on his Masters degree in Software Engineering. He can be reached at clay.rehm@rehmtech.com.

Nancy Williams is a vice president and principal consultant with DecisionPath Consulting, where she serves as BI and data warehousing practice leader. She is a regular instructor at TDWI World Conferences and Regional Seminars and is a panelist for DM Review's Ask the Experts. Williams holds an MBA from the University of Virginia and has published articles on BI maturity, the business value of BI and organizational change to capture BI ROI. Her areas of expertise include BI/DW strategy, architecture, technology strategy and tool selection, data modeling, ETL strategy, business case development and BI-driven change management

Solutions Marketplace
Provided by IndustryBrains

Download trial Sales Anywhere for Salesforce.com
Anywhere, anytime access to salesforce.com on your device?with or without wireless connection. Download 30-day trial and in minutes have Sales Anywhere for salesforce.com on your device. This download is for U.S. salesforce.com customers/trial users.

Manage Data Center from Virtually Anywhere!
Learn how SecureLinx remote IT management products can quickly and easily give you the ability to securely manage data center equipment (servers, switches, routers, telecom equipment) from anywhere, at any time... even if the network is down.

Find CRM Consultants
Post You Project for Free. Get Bids from Thousands of Pre-Screened Consultants.

Customer Relationship Management for IT
Web-based CRM and more with Autotask: Great business management software optimizes resources and track billable project and service work. Get a demo, then try it free with sample data. Click here for your free trial!

Strategic CRM Analytics White Paper
This white paper explores how companies can extend their CRM applications by using BI tools to turn CRM data into actionable information to drive strategic decision-making and improve ROI.

Click here to advertise in this space

E-mail This Ask The Experts E-Mail This Ask The Experts
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.