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. Each chapter presents one or more case studies to thoroughly explain the concepts and has different levels of difficulty hence learning is incremental. In addition every chapter has also a section on further readings which give pointers and references to research papers related to the chapter. All these features make the book ideally suited for either introductory courses on data warehousing and data analytics or even for selfstudies by professionals. The book is accompanied by a web page that includes all the used datasets and codes as well as slides and solutions to exercises.