ENABLING, DIRECTING, AND STRUCTURAL PILLARS (Data Warehousing Process)

In an increasingly data-driven world, understanding the fundamentals that underpin analytics in organizations has become essential for professionals and institutions that want to stay relevant, efficient, and strategically positioned. DW – Sustaining, Directing, and Structuring Concepts is more than a technical book — it is a solid, accessible, and intellectually thought-provoking immersion in the frameworks that transform dispersed data into strategic knowledge.

Written by Prof. Marcão, an academic and professional reference in the field of information systems, this volume inaugurates the Data Warehousing Process Collection, available on Amazon. With a clear and at the same time sophisticated language, the work rescues the historical foundations of Data Warehousing, traces its evolution to the era of intelligent ecosystems and offers the reader a deep and applied understanding of the conceptual and architectural bases that shape today's most demanding data environments.

This is a book for those who want more than operating systems: it is made for those who want to understand, design, and lead data-driven digital transformation — with technical and strategic awareness.

Main topics covered:
- The historical origins and theoretical foundations of Data Warehousing.
- Contributions from Bill Inmon, Ralph Kimball, and Dan Linstedt.
- Data Warehouse architectures: centralized, virtual, and Data Mart-oriented.
- The complete ETL process: from extraction to loading and validation.
- Dimensional modeling and structuring in star scheme.
- OLAP and multidimensional analysis.

The importance of the time dimension and temporal modeling.
- Comparison between OLTP and OLAP environments.
- Quality, consistency, and semantic integration of data.
- Organizational culture, governance and data-driven change.

Results you will get:
- Clear understanding of the conceptual bases of Data Warehousing.
- Ability to differentiate architectural approaches and apply them according to context.
- Critical view of the historical and current challenges of data management.
- Solid fundamentals to work in BI, analytics and digital transformation projects.
- Technical language mastered with depth, clarity and applicability.
- Ability to dialogue with IT professionals, managers and decision makers.
- Basis for understanding and using decision support tools strategically.

This book is ideal for:
- Information technology professionals.
- Data engineers and architects.
- Data scientists and BI analysts.
- Innovation and digital transformation managers.
- Data governance consultants and auditors.
- Undergraduate and graduate students in IT, engineering, administration and related areas.
- Professors and researchers interested in information architecture and decision support systems.

By the end of the reading, the reader will not only master the fundamentals of Data Warehousing — he will see the data with different eyes. He will have acquired a new lens to interpret structures, identify patterns, and design solutions in a world where information is the most valuable resource.

This work is an invitation to depth, strategic thinking and technical mastery, with the clarity of someone who teaches with experience. It is the first of a collection designed to turn experts into references.

Get ready: Your journey to data mastery starts here.

About the author.
Prof. Marcão is a prolific writer with more than 300 publications in several languages. His writing, marked by clarity and depth, translates complex concepts into accessible and impactful narratives. A university professor by vocation and a mentor by essence, he imprints in each book a philosophy that values what is meaningful, guiding the reader not only to understand, but to transform.