This textbook covers all central activities of data warehousing and analytics including transformation preparation aggregation integration and analysis. It discusses the full spectrum of the journey of data from operationaltransactional databases to data warehouses and data analytics as well as the role that data warehousing plays in the data processing lifecycle. It also explains in detail how data warehouses may be used by data engines such as BI tools and analytics algorithms to produce reports dashboards patterns and other useful information and knowledge.The book is divided into six parts ranging from the basics of data warehouse design Part I Star Schema Part II Snowflake and Bridge Tables Part III Advanced Dimensions and Part IV MultiFact and MultiInput to more advanced data warehousing concepts Part V Data Warehousing and Evolution and data analytics Part VI OLAP BI and Analytics.This textbook approaches data warehousing from the case study angle.