Using the Wal-Mart Model To order this title, and for more information, click here
By Paul Westerman
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.
Audience
Data warehouse managers, and data architects, consultants, and project Managers.
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
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
Using the Wal-Mart Model
