Table Of ContentData Warehousing
Edited by seN Education B.V.
HOlT Guide
Edited by seN Education B. V.
This series of books cover special topics which are useful for a business audience. People
who work or intend to work with Internet - at a management, marketing, sales, system
integrating, technical or executive level - will benefit from the information provided in the
series.
These books impart how new technologies and sales & marketing trends on Internet may
be profitable for business. The practical knowhow presented in this series comes from
authors (scientists, research firms and industry experts, a.o.) with countless years of
experience in the Internet area.
The Hon Guides will help you to:
~ Enlarge your knowledge of the (im)possibilities of Internet and keep it up-to-date
~ Use Internet as an effective Sales & Marketing tool by implementing new technologies
as well as future-oriented strategies to improve your business results
~ Facilitate decision making on a management level
~ Reduce research costs and training time
These books are practical 'expert-to-manager' guides. Readers will see a quick 'return on
investment' .
The Publishing department of seN Education B.v. was founded in 1998 and has built a
solid reputation with the production of the Hon Guide series. Being part of an
international IT-training corporation, the editors have easy access to the latest information
on IT-developments and are kept well-informed by their colleagues. In their research
HOTT Guide
activities for the Hon Guide series they have established a broad network of IT-specialists
(leading companies, researchers, etc) who have contributed to these books.
SCN Education BV, Newtonstraat 37C, 3902 HP Veenendaal, The Netherlands,
tel. +31 - 318 - 547000, fax +31 - 318 - 549000, www.scnedu.com,
www.hottguide.com .
Books already in print:
Webvertising
Mobile Networking with WAP
ASP - Application Service Providing
Customer Relationship Management
Electronic Banking
Data Warehousing
The Ultimate Guide to Building Corporate Business Intelligence
Edited by SCN Education B.V.
~
vleweg
Die Deutsche Bibliothek - CIP-Cataloguing-in-Publication-Data
A catalogue record for this publication is available from Die Deutsche Bibliothek
(http://www.ddb.de).
Trademarks
All products and service marks mentioned herein are trademarks of the respective owners
mentioned in the articles and or on the website. The publishers cannot attest to the
accuracy of the information provided. Use of a term in this book and/or website should
not be regarded as affecting the validity of any trademark or service mark.
1s t Edition April 2001
All rights reserved.
Copyright © 2001 Friedr. Vieweg & Sohn Verlagsgesellschaft mbH,
Braunschweig/wiesbaden
Soflcover reprint of the hardcover 1s t edition 2001
Vieweg is a company in the specialist publishing group BertelsmannSpringer.
No part of this publication may be reproduced, stored in a retrieval
system or transmitted, mechanical, photocopying or otherwise without
prior permission of the copyright holder.
Printed on acid-free paper
ISBN-13: 978-3-322-84966-3 e-ISBN-13: 978-3-322-84964-9
001: 10.1007/978-3-322-84964-9
Preface
Data: from acquisition to interpretation
Historically, the major challenge for organizations was capturing data. Years ago,
businesses were able to leverage the information they could get, but weren't very good
at getting detailed information across a range of business processes.
In the business environment of today, virtually every transaction and minute business data
is recorded in databases to enable better, more effective decision making throughout the
organization. Most of the technology emphasis has been on storing data, with less
attention paid to tools for transforming data into meaningful information which can be
easily accessed and shared by executives.
A data warehouse system can take meaningless data and, using intense analytical
processing, offer insight into changing market conditions before they occur. The
capability to optimize customer interactions and supply chain operations is becoming a
source of great competitive advantage.
This Hon Guide will give you access to all the essential information about the newest
was to store and interpret data: through articles by expert trendwachters on strategic
considerations, how-to reports defining the various ways to extract the data needed for
critical business decisions, technical papers clarifying technologies and tools, business
cases and key concepts that will provide the reader with a comprehensive overview of a
business solution that is already indispensable.
The Editors
Acknowledgements
Many people and professionals have contributed directly or indirectly to this book. To
name them all would be practically impossible, as there are many. Nevertheless the
editors would like to mention a few of those who have made the production of this book
possible.
Executive Editor for seN Education BV: Robert Pieter Schotema
Publishing Manager: drs. Marieke Kok
Product Manager: Martijn Robert Broersma
Editorial Support: Dennis Gaasbeek
Hon Guide Online: Rob Guijt, Richard van Winssen
Interior Design: Paulien van Hemmen, Bach.
Contents
13 Chapter 1: Introduction to Data Warehousing
15 The Sales & Marketing Imperative: The Impact of Technology on Business
Strategy
By IMT Strategies, Inc.
27 Data Warehousing - adopting an architectural view, and maximizing cost
benefits
By Ian Manning
33 What is Data Warehousing?
By David Heise, Andrews University
37 Data Warehousing Solutions
By 3Com
47 Getting started - Building the Scalable Data Warehouse the right way
By Michael Meltzer, NCR Corporation
57 Chapter 2: How to integrate Data Warehousing in your business
59 Data Marts: Key to Reviving the Enterprise Data Warehouse
By Joe Brown, Microsoft and Paul Hill, Cognos, senior vice president
BI Solutions Marketing
63 Enterprise IT value: beyond Data Warehousing and ROI
By Hummingbird
75 Building Corporate Business Intelligence: from Datamarts to the
Enterprise Data Warehouse
By Daphnesoft
83 The Four Challenges of Customer-Centric Data Warehousing
By Carleton Corporation
97 ERP and Data Warehousing in the Intelligent Enterprise
By Informatica
Contents
107 Tightening the Sales Cycle
By Jon-Paul Contreras, Neovation
113 SAP and Data Warehousing
By WHo Inmon, Kiva Productions
135 SAP Rl3 Data Warehousing and Application Integration
By Hummingbird
149 Storage Area Networks: Smart Storage, Fat Pipes and Industrial Grade
Data Warehousing
By Ken Orr, The Ken Orr Institute
165 Chapter 3: Strategical considerations
167 The 7 Steps to Calculating Data Warehousing ROI
By Informatica
181 Data Mining: Statistical Analysis
By Rob Mattison, SPSS Inc.
195 DataMines for DataWarehouses
By Information Discovery, Inc.
211 Data Warehouse Scorecard: Cost of Ownership and Successes in
Application of Data Warehouse Technology
By META Group
223 Driving Customer Retention, Development and Acquisition for Profit in
the Insurance Business
By Chris Saunders & Michael Meltzer
229 Metadata for Data Warehousing
By Satya Sachdeva, Principal Consultant Data Warehouse Practice
Sybase Professional Services
