Data Warehousing: The Ultimate Guide to Building Corporate Business Intelligence PDF
Preview Data Warehousing: The Ultimate Guide to Building Corporate Business Intelligence
Data 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
The list of books you might like
