"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 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 includesAll sample data warehouse designs with accompanying preformatted reports in HTML for specific business uses such as marketing, sales, and financial analysis.