The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including:
- Retail sales and e-commerce
- Inventory management
- Procurement
- Order management
- Customer relationship management (CRM)
- Human resources management
- Accounting
- Financial services
- Telecommunications and utilities
- Education
- Transportation
- Health care and insurance
By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.