Data Warehousing

Data Warehousing

Using the Wal-Mart Model

1st Edition - August 18, 2000

Write a review

  • Author: Paul Westerman
  • eBook ISBN: 9780080503721

Purchase options

Purchase options
DRM-free (PDF)
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order

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.

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

Product details

  • No. of pages: 297
  • Language: English
  • Copyright: © Morgan Kaufmann 2000
  • Published: August 18, 2000
  • Imprint: Morgan Kaufmann
  • eBook ISBN: 9780080503721

About the Author

Paul Westerman

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.

Ratings and Reviews

Write a review

There are currently no reviews for "Data Warehousing"