Data Warehousing by paul westerman

DATA WAREHOUSING
	Using the Wal-Mart Model To order this title, and for more information, click here By Paul Westerman

http://www.elsevier.com/wps/find/
bookdescription.cws_home/677907/
description#description

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


p/s : i want to buy la this book.