Using the Wal-Mart ModelBy
- Paul Westerman
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.
Data warehouse managers, and data architects, consultants, and project Managers.
Paperback, 297 Pages
Published: August 2000
Imprint: Morgan Kaufmann
- FOREWORDACKNOWLEDGMENTSCHAPTER 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 ToolAPPLYING THE DATA WAREHOUSE CONCEPTBEYOND ENTERPRISE DATA WAREHOUSECHAPTER 2 - PROJECT PLANNINGBEFORE 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 PlanningPLANNING 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-ProductionCHAPTER 3 - BUSINESS EXPLORATIONTHE BUSINESS EXPLORATION PROCESS Defining the Goals Gathering the Business Questions Prioritizing the Business Questions Defining the Business QuestionsCHAPTER 4 - BUSINESS CASE STUDY AND ROI ANALYSISBUSINESS 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 PlanROI 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 PlanCHAPTER 5 - ORGANIZATIONAL INTEGRATIONCHAPTER 6 - TECHNOLOGYTHE FRONT-END TOOLTHE DATABASE TOOL Database Compatibility Database Maintenance Reliability Minimal Indexing Dynamic Reorganization Database Linear GrowthCHAPTER 7 - TECHNOLOGY - DATABASE MAINTENANCECAPTURING, EXTRACTING, AND TRANSFERRING THE SOURCE DATAUPDATE FREQUENCYLOADING THE DATA WAREHOUSE Initial Load Append Load Processes Update Processes Delete ProcessesBACKUP/RECOVERYMESSAGINGCHAPTER 8 - TECHNICAL CONSTRUCTION OF THE WAL-MART DATA WAREHOUSEPRE-CONSTRUCTIONTHE FIRST IMPLEMENTATION The Database Design The Update Process GUI ApplicationCHAPTER 9 - POST-IMPLEMENTATION OF THE WAL-MART DATA WAREHOUSETHE ROI SURROUNDED BY CHAOSINTEGRATING OPERATIONAL APPLICATIONS Replenishment Distribution via Traits Perpetual InventoryCHAPTER 10 - STORE OPERATIONS SAMPLE ANALYSESBASIC STORE OPERATIONS INFORMATION NEEDSSTORE SALES Store Sales Data Elements Store Sales Sample ReportCOMPARABLE STORE SALES Comparable Store Sales Data Elements Comparable Store Sample ReportFLASH STORE SALES Flash Store Sales Data Elements Flash Store Sales Sample ReportDEPARTMENTAL STORE SALES Departmental Store Sales Data Elements Departmental Store Sales Sample ReportPLANNED SALES Planned Sales Data Element Planned Sales Sample ReportCOMPETITIVE STORE SALES Competitive Store Sales Data Elements Competitive Store Sales Sample ReportCHAPTER 11 - MERCHANDISING SAMPLE ANALYSESBASIC MERCHANDISING INFORMATION NEEDSBASIC ARTICLE POS ANALYSIS Basic Article POS Data Elements Basic Article Sample ReportTOP 25, BOTTOM 25 ANALYSIS Top 25, Bottom 25 Data Elements Top 25, Bottom 25 Sample ReportARTICLE INVENTORY ANALYSIS Article Inventory Data Elements Article Inventory Sample ReportARTICLE SELLING VS. PLANNED SELLING Article Selling vs. Planned Data Elements Article Selling vs. Planned Sample ReportFAST SELLING ARTICLE ANALYSIS Fast Selling Data Elements Fast Selling Sample ReportSLOW SELLING ARTICLES Slow Selling Data Elements Slow Selling Sample ReportVENDOR PERFORMANCE ANALYSIS Vendor Performance Data Elements Vendor Performance Sample ReportCATEGORY PERFORMANCE ANALYSIS Category Performance Data Elements Category Performance Sample ReportARTICLE SELLING BY GEOGRAPHIC LOCATIONS Article Selling by Geographic Locations Data Elements Article Selling by Geographic Locations Sample ReportCOMPARATIVE ARTICLE SALES Comparative Article Sales Data Elements Comparative Article Sales Sample ReportSTORE AND ARTICLE GROUPING Store and Article Grouping Data Elements Store and Article Grouping Sample ReportBASIC AFFINITY SELLING Basic Affinity Selling Data Elements Basic Affinity Selling Sample ReportOUT-OF-STOCK ANALYSIS Out-of-Stock Data Elements Out of Stock Sample ReportCONCLUSIONAPPENDIX A - RETAIL FORMULAS INVENTORY FORMULAS KEY PERCENTAGE RELATIONSHIPS MARGIN & PROFIT FORMULASBIBLIOGRAPHY