More than a technical guide, this book is a call to action: a carefully structured journey that combines up-to-date theory, practical experiences, and applied examples to help professionals and students understand, plan, execute, and evolve Data Warehouse projects with security, clarity, and results.
the.
With accessible language, but without giving up depth, the author - Prof. Marcão, a reference in the teaching of Data Warehousing - leads the reader through a complete, applicable, and replicable script, which can be used both in the classroom and on the corporate battlefield.
Themes covered in the book:
- Fundamentals of a Data Warehouse project and its strategic role
- Differences between operational data and analytical data
- Essential concepts: BI, ETL, OLAP, Data Lake, Data Mesh, Artificial Intelligence and more
- DW Project Life Cycle: From Conception to Sustainment
- Effective requirements gathering techniques for analytical projects
- Dimensional modeling: star, snowflake, granularity, and special dimensions
- Modern architectures: Inmon, Kimball, Hub-and-Spoke, Lakehouse, Serverless, and hybrid
- Data integration, ETL tools, automation, and error handling
- Data visualization: dashboards, KPIs, tools, and effective design
- Real case studies in public and private companies
- Professional profiles that make up high-performing DW teams
- Practical roadmap divided into phases with clear activities, deliverables and objectives
- Questionnaire with commented questions and answers for review and fixation
By the end of the reading, you will be able to:
- Clearly understand the pillars of a successful DW project
- Avoid the most common mistakes and adopt established best practices
- Plan and execute data projects with strategic vision and technical control
- Make decisions based on reliable, well-structured and up-to-date data
- Conduct requirements meetings, accurately model data, and create actionable dashboards
- Confidently position yourself in technical and business discussions about data
This book is ideal for:
-Undergraduate and graduate students and faculty in technology, data science, engineering, and management
- IT professionals, data analysts, data engineers, and data scientists
- Managers, consultants, and decision-makers who need to align technology and strategy
- Professionals in career transition who want to work in the growing data market
- BI, analytics, and data architecture modernization project teams
This book can transform the way you look at data, projects, and decisions. It can give you the tools you need to evolve your career, take on new challenges, or improve your team's results. It can, above all, ignite in you the certainty that, with method, knowledge and practice, it is possible to build solid, useful and lasting data solutions.
Start your journey to excellence in data warehousing design now-and find out why this collection is a must-read for anyone who is serious about data. Available on Amazon.
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.