This textbook introduces a groundbreaking methodology for data warehouse development, bridging the gap between technical design and real-world business needs. It offers a comprehensive, life cycle-oriented perspective that is both conceptually rigorous and practically relevant. Unlike traditional approaches that treat data warehouses as passive repositories, this book positions them as active enablers of business decision-making. It emphasizes aligning data warehouse design with organizational goals, ensuring that the system supports not just the identification of problems but also the selection of optimal decisions. The book covers the entire data warehouse development process—from requirements engineering to conceptual and logical design. It moves beyond the conventional focus on logical modeling to include upstream activities that are critical for building effective and usable systems. A unique, platform-agnostic conceptual model is introduced to represent analytical capabilities. This model facilitates seamless transitions between requirements, conceptual design, and logical implementation, making it adaptable to various technological environments. Recognizing the growing importance of unstructured data in decision-making, the book integrates support for both structured and unstructured data. It explores the use of both relational and NoSQL technologies to handle diverse data types effectively. The book advocates for an agile, iterative approach to data warehouse development. It introduces agility from the very beginning, starting with requirements engineering—and promotes continuous stakeholder involvement and incremental delivery of functional components. This book fills that gap by integrating business context, unstructured data analysis, and agile development principles into the core of data warehouse design. It is an essential resource for students, educators, and professionals seeking to build data warehouses that are not only technically sound but also strategically impactful.

Deepika Prakash received her Ph.D. from Delhi Technological University in 2016, specializing in Data Warehouse Requirements Engineering. She is currently an Associate Professor in the Department of Computer Science and Engineering at JK Lakshmipat University, India. She has authored around 20 research papers, contributed two book chapters, co-authored a book, and co-edited another. Dr. Prakash has served on the program committees of several international conferences and is a reviewer for the Requirements Engineering journal published by Springer. In addition to her academic contributions, she has extensive industry experience in the design and development of data marts for domains such as purchasing, sales, and inventory management, as well as in data mart integration.

Naveen Prakash earned his doctoral degree from the Indian Institute of Technology (IIT) Delhi in 1980 and has nearly five decades of experience in data engineering and information systems. He has served on the program committees of more than 100 international conferences and has chaired the program committees of several major conferences. He is currently an Associate Editor of the Requirements Engineering journal (Springer) and serves on the review board of the International Journal of Information Systems Modeling and Design (IJISMD). Prof. Prakash has published approximately 75 research papers and authored two books. He is currently an Adjunct Professor and remains actively involved in research. His interests include data warehousing, decision support systems, the Internet of Things (IoT), and NoSQL databases.