Data Warehousing - 1st Edition - ISBN: 9781558606845, 9780080503721

Data Warehousing

1st Edition

Using the Wal-Mart Model

Authors: Paul Westerman
eBook ISBN: 9780080503721
Paperback ISBN: 9781558606845
Imprint: Morgan Kaufmann
Published Date: 18th August 2000
Page Count: 297
Tax/VAT will be calculated at check-out
15% off
15% off
15% off
15% off
60.95
51.81
48.99
41.64
7100.00
6035.00
79.95
67.96
Unavailable
File Compatibility per Device

PDF, EPUB, VSB (Vital Source):
PC, Apple Mac, iPhone, iPad, Android mobile devices.

Mobi:
Amazon Kindle eReader.

Institutional Access


Table of Contents

FOREWORD

ACKNOWLEDGMENTS

CHAPTER 1 - WHAT IS DATA WAREHOUSING?

EVOLUTION LEADING UP TO THE DATA WAREHOUSE

Executive Information Systems

Direct SQL Access

Data Warehouse

Data Mart

Enterprise Data Warehouse

Operational Data Store

Data Warehouse is a Tool

APPLYING THE DATA WAREHOUSE CONCEPT

BEYOND ENTERPRISE DATA WAREHOUSE

CHAPTER 2 - PROJECT PLANNING

BEFORE YOU START

Clear Focus on the Business

Business Sponsorship

Long-Term Vision

Short-Term Plan

Assigning a Responsible Leader

Effective Communications

Providing Something New

Partnership Planning

PLANNING FOR THE PROJECT LIFE CYCLE

Analytical Phase

Gathering and documenting the business requirements Logical Design of the Database and Processes Determine the Source of the Data Determine Technical Readiness Select Tools Create an Implementation Timeline and Resources Required

Construction Phase

Post-Production

CHAPTER 3 - BUSINESS EXPLORATION

THE BUSINESS EXPLORATION PROCESS

Defining the Goals

Gathering the Business Questions

Prioritizing the Business Questions

Defining the Business Questions

CHAPTER 4 - BUSINESS CASE STUDY AND ROI ANALYSIS

BUSINESS CASE STUDY

Business User Visions

One-to-one Discussions

Business Users Profiles

Potential Pay-back

Accumulated Potential Pay-back Summary

Projected Investment Costs with ROI Forecast

Resource Plan

ROI ANALYSIS

Data Warehouse Background

One-to-one Discussions

Business Users Profiles

Actual Pay-back

Actual Accumulated and Projected Pay-back Summary

Investment Costs with ROI Conclusion

Next Step Implementation Plan

CHAPTER 5 - ORGANIZATIONAL INTEGRATION

CHAPTER 6 - TECHNOLOGY

THE FRONT-END TOOL

THE DATABASE TOOL

Database Compatibility

Database Maintenance

Reliability Minimal Indexing Dynamic Reorganization Database Linear Growth

CHAPTER 7 - TECHNOLOGY - DATABASE MAINTENANCE

CAPTURING, EXTRACTING, AND TRANSFERRING THE SOURCE DATA

UPDATE FREQUENCY

LOADING THE DATA WAREHOUSE

Initial Load

Append Load Processes

Update Processes

Delete Processes

BACKUP/RECOVERY

MESSAGING

CHAPTER 8 - TECHNICAL CONSTRUCTION OF THE WAL-MART DATA WAREHOUSE

PRE-CONSTRUCTION

THE FIRST IMPLEMENTATION

The Database Design

The Update Process

GUI Application

CHAPTER 9 - POST-IMPLEMENTATION OF THE WAL-MART DATA WAREHOUSE

THE ROI SURROUNDED BY CHAOS

INTEGRATING OPERATIONAL APPLICATIONS

Replenishment

Distribution via Traits

Perpetual Inventory

CHAPTER 10 - STORE OPERATIONS SAMPLE ANALYSES

BASIC STORE OPERATIONS INFORMATION NEEDS

STORE SALES

Store Sales Data Elements

Store Sales Sample Report

COMPARABLE STORE SALES

Comparable Store Sales Data Elements

Comparable Store Sample Report

FLASH STORE SALES

Flash Store Sales Data Elements

Flash Store Sales Sample Report

DEPARTMENTAL STORE SALES

Departmental Store Sales Data Elements

Departmental Store Sales Sample Report

PLANNED SALES

Planned Sales Data Element

Planned Sales Sample Report

COMPETITIVE STORE SALES

Competitive Store Sales Data Elements

Competitive Store Sales Sample Report

CHAPTER 11 - MERCHANDISING SAMPLE ANALYSES

BASIC MERCHANDISING INFORMATION NEEDS

BASIC ARTICLE POS ANALYSIS

Basic Article POS Data Elements

Basic Article Sample Report

TOP 25, BOTTOM 25 ANALYSIS

Top 25, Bottom 25 Data Elements

Top 25, Bottom 25 Sample Report

ARTICLE INVENTORY ANALYSIS

Article Inventory Data Elements

Article Inventory Sample Report

ARTICLE SELLING VS. PLANNED SELLING

Article Selling vs. Planned Data Elements

Article Selling vs. Planned Sample Report

FAST SELLING ARTICLE ANALYSIS

Fast Selling Data Elements

Fast Selling Sample Report

SLOW SELLING ARTICLES

Slow Selling Data Elements

Slow Selling Sample Report

VENDOR PERFORMANCE ANALYSIS

Vendor Performance Data Elements

Vendor Performance Sample Report

CATEGORY PERFORMANCE ANALYSIS

Category Performance Data Elements

Category Performance Sample Report

ARTICLE SELLING BY GEOGRAPHIC LOCATIONS

Article Selling by Geographic Locations Data Elements

Article Selling by Geographic Locations Sample Report

COMPARATIVE ARTICLE SALES

Comparative Article Sales Data Elements

Comparative Article Sales Sample Report

STORE AND ARTICLE GROUPING

Store and Article Grouping Data Elements

Store and Article Grouping Sample Report

BASIC AFFINITY SELLING

Basic Affinity Selling Data Elements

Basic Affinity Selling Sample Report

OUT-OF-STOCK ANALYSIS

Out-of-Stock Data Elements

Out of Stock Sample Report

CONCLUSION

APPENDIX A - RETAIL FORMULAS

INVENTORY FORMULAS

KEY PERCENTAGE RELATIONSHIPS

MARGIN & PROFIT FORMULAS

BIBLIOGRAPHY


Description

At 70 terabytes and growing, Wal-Mart's data warehouse is still the world's largest, most ambitious, and arguably most successful commercial database. Written by one of the key figures in its design and construction, Data Warehousing: Using the Wal-Mart Model gives you an insider's view of this enormous project. Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization's own data warehouse project, however large or small. You'll emerge with a practical understanding of both the business and technical aspects of building a data warehouse for storing and accessing data in a strategically useful way.

What further sets this book apart is its focus on the informational needs of retail companies-including both market and organizational issues that affect the data's collection and use. If retail is your field, this book will prove especially valuable as you develop and implement your company's ideal data warehouse solution.

Key Features

  • Written by a member of the team of four engineers who designed and built the Wal-Mart Data Warehouse database, a team whose database design was recognized internally in 1991 by Wal-Mart with the company's Team Innovational Technical award.
  • Provides essential information for project managers, consultants, data warehouse managers, and data architects.
  • Takes an in-depth look at a wide range of technical issues, including architecture, construction approaches, tool selection, database system selection, and maintenance.
  • Addresses issues specific to retail business: vendors, inventory, sales analysis, geography, article categories, and more.
  • Explains how to determine business requirements at the outset of the project-and how to develop return on investment analyses after the warehouse has been brought online.

Readership

Data warehouse managers, and data architects, consultants, and project Managers.


Details

No. of pages:
297
Language:
English
Copyright:
© Morgan Kaufmann 2001
Published:
Imprint:
Morgan Kaufmann
eBook ISBN:
9780080503721
Paperback ISBN:
9781558606845

About the Authors

Paul Westerman Author

Paul Westerman is a Global Marketing Manager for Compaq Computers, Inc. He began his retail career with Wal-Mart, where he was one of the four people responsible for designing and building the Wal-Mart data warehouse-still the world's largest. Since then, Paul has played a key role in many very large data warehouses projects around the world-in the retail industry, telephone industry, and other areas-and has spoken to audiences around the world about the benefits of applying the data warehouse technology to business. He holds a BS in Computing and Information Sciences from Oklahoma State University.