You are previewing Data Warehouse Design Solutions.
O'Reilly logo
Data Warehouse Design Solutions

Book Description

"Each chapter is... a practice run for the way we all ought to design our data marts and hence our data warehouses."-Ralph Kimball, from the Foreword.

Let the experts show you how to customize data warehouse designs for real business needs in Data Warehouse Design Solutions.

To effectively design a data warehouse, you have to understand its many business uses. This guidebook shows you how business managers in different corporate functions actually use data warehouses to make decisions. You'll get a rich set of data warehouse designs that flow from realistic business cases. Two top experts show you how to customize your data warehouse designs for real-life business needs including:

  • Sales and marketing

  • Production and inventory management

  • Budgeting and financial reporting

  • Quality control

  • Product delivery and fulfillment

  • Strategic business analysis such as determining market share, rates of return on investment, and other key analytic ratios.

CD-ROM includes

All sample data warehouse designs with accompanying preformatted reports in HTML for specific business uses such as marketing, sales, and financial analysis.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Contents
  5. Foreword
  6. ACKNOWLEDGMENTS
    1. Mike Venerable
    2. Chris Adamson
  7. INTRODUCTION
    1. The Successful Data Warehouse
    2. Designing Business Solutions
    3. Getting Started
  8. 1: THE BUSINESS-DRIVEN DATA WAREHOUSE
    1. The Data Warehouse
    2. The Star Schema
    3. More than One Fact Table
    4. The Enterprise Data Warehouse
    5. Summing Up Dimensional Modeling Principles
  9. 2: SALES
    1. Direct versus Indirect Sales?
    2. Indirect Sales
    3. Understanding Direct Sales
    4. The Merchant's Data Warehouse
    5. Summing Up Sales
  10. 3: MARKETING
    1. What Is Known about the Customer?
    2. The Grocery Store
    3. The Telephone Company
    4. Retail Banking
    5. Summing Up Marketing
  11. 4: FULFILLMENT
    1. Fulfillment and the Value Proposition
    2. Flowers and Time
    3. Returns: A Second Fact Table
    4. Open-Ended Fulfillment
    5. Fulfilling Warranty Commitments
    6. Summing Up Fulfillment
  12. 5: PRODUCTION
    1. Manufacturing
    2. Production in Discrete Manufacturing
    3. Production in Continuous Process Manufacturing
    4. Production in Hybrid Manufacturing
    5. Summing Up Production
  13. 6: INVENTORY AND CAPACITY
    1. What Kind of Inventory?
    2. Supplier Inventory
    3. Hotel Occupancy
    4. Summing Up Inventory
  14. 7: QUALITY
    1. A Quick Quality Primer
    2. Washers, Dryers, and Warranties
    3. Service Quality—Experience Is Everything
    4. Summing Up Quality
  15. 8: BUDGETS AND SPENDING
    1. Budgeting Demystified
    2. The Status Model
    3. The Federal Government
    4. Summing Up Budgeting and Spending
  16. 9: FINANCIAL REPORTING
    1. Tracing Financial Transactions
    2. Why It's Called Accounting
    3. The Balance Sheet
    4. The Income Statement
    5. Cash Flow Statement
    6. Summing Up Financial Reporting
  17. 10: PROFITABILITY
    1. Product Profitability
    2. Customer Profitability
    3. Summing Up Profitability
  18. 11: KNOWLEDGE AND INTELLECTUAL CAPITAL
    1. Knowledge and the Value Chain
    2. Corporate Intellectual Measurement
    3. Summing Up Intellectual Capital
  19. 12: KEY MEASURES AND RATIOS
    1. Building a Portfolio of Measures
    2. Measures for Manufacturers
    3. Measures for Merchants
    4. Measures for Service Product Companies
    5. Summing Up Key Measures
  20. 13: PRESENTING INFORMATION
    1. Three Ways to Present Information
    2. Reporting Basics
    3. Summary Rows
    4. Comparison between Rows
    5. Comparisons between Columns
    6. Drilling Across
    7. Dealing with Averages
    8. Constraining Queries
    9. Tool Requirements
    10. Summing Up Effective Reporting
  21. 14: BUILDING AN ENTERPRISE DATA WAREHOUSE
    1. The Golden Age of Data Modeling
    2. What about a Data Warehouse?
    3. Changes in the Operational Environment
    4. Dealing with Change in the Business
    5. Building the Dimensional EDW
    6. Summing Up The EDW
  22. 15: INTERVIEWING
    1. You Don't Know Anything
    2. Planning Interviews
    3. How to Interview
    4. Summing Up Interviewing
  23. KEY BUSINESS TERMS
  24. USING THE CD-ROM
    1. System Requirements
    2. Using the CD-ROM
    3. User Assistance and Information
  25. INDEX
  26. CUSTOMER NOTE: IF THIS BOOK IS ACCOMPANIED BY SOFTWARE, PLEASE READ THE FOLLOWING BEFORE OPENING THE PACKAGE.