Data Warehousing: Using the Wal-Mart Model gives you. Written by a member of the team of four engineers who designed and built the Wal-Mart Data. Free Data Warehousing: Using the Wal-Mart Model (The Morgan Kaufmann Series in Data Management Systems) e-book download book continue reading 1 / 5.
Secure Checkout
Personal information is secured with SSL technology.Free Shipping
Free global shippingNo minimum order.
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 RequiredConstruction 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 GrowthCHAPTER 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
Data Warehousing Using The Walmart Model Pdf
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
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.
Data warehouse managers, and data architects, consultants, and project Managers.
Details
- No. of pages:
- 297
- Language:
- English
- Copyright:
- © Morgan Kaufmann 2001
- Published:
- 18th August 2000
- Imprint:
- Morgan Kaufmann
- Paperback ISBN:
- 9781558606845
- eBook ISBN:
- 9780080503721
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.'>
Data Warehousing: Using The Wal-mart Model
About the Authors
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.