Data Warehouse Process - The Ultimate Methodology.

With a meticulous and structured approach, this book covers all the essential concepts and techniques to master data warehousing. Whether you're a seasoned professional or new to the field, this book provides valuable insights that will enhance your understanding and expertise.

You'll gain a deep understanding of requirements modeling for both functional and non-functional aspects. The book goes beyond theoretical discussions by offering practical advice on methodological issues, such as Twin Peaks and requirements management.

The approach is centered around a milestone model that guides the development process of data marts, while proposing a set of artifacts for collecting, recording, and documenting the functional, non-functional, and multidimensional aspects that make up the solution.

Resulting from my experiences in data mart development and information system modeling, the methodology incorporates best practices from the Brazilian Software Process Improvement Model MPS.BR, the Rational Unified Process (RUP), the Unified Modeling Language (UML), project management according to the PMI, dimensional modeling, and classic Entity-Relationship (ER) data modeling.

Book Contents:
- Guiding, supporting, and structural concepts
- Data warehouse Dimensional modeling
- OLAP (On-Line Analytical Processing)
- Time dimension - Historical data is not a thing of the past
- Key concepts of temporal representation
- Temporal data modeling
- OLTP vs OLAP: everyday and strategic perspectives
- Comparison of methodologies for data warehouse development
- Entity-Relationship modeling
- UML
- PDW and PMI
- Requirements Engineering for Data Warehousing
- Requirements Analysis and Negotiation
- Requirements Documentation
- Requirements Modeling
- Requirements Compliance
- Requirements Validation
- Review and comparison of major methodologies
- Deriving the dimensional model
- PDW methodology structure
- Application of RUP
- Utilization of artifacts/templates in the methodology
- Development planning for the data mart
- Roles and responsibilities of project team members
- Quick guide to PDW
- Guidance for using templates
- Planning artifacts Artifacts for business analysis and user needs
- Artifacts for the acquisition process
- Templates

Who is this book for:
Information technology professionals and business intelligence professionals involved in data mart or data warehouse development projects will benefit from this book as it provides a practical and comprehensive guide on how to plan and execute these developments.

About the author: Marcus Pinto - known as Prof. Marcão by everyone - holds a master's degree in Information Technology and has been working in the field of information architecture and attribute engineering since the mid-1980s.
He has proposed several methodologies, including data modeling and data warehouse standards, data model validation and management methodology, and data mart development methodology.
One of his current areas of focus is the government open data scenario. This Data Warehousing series aims to help technology professionals have development projects with fewer problems and unforeseen risks.