The Enterprise Data Modelling Playbook

The Enterprise Data Modelling Playbook is an architecture-focused guide to understanding, evaluating, and selecting enterprise data warehousing methodologies for modern organisations.

Data warehousing remains a foundational component of enterprise data architecture, yet choosing the right modelling and warehousing approach is rarely straightforward. Organisations must balance governance, flexibility, analytical performance, scalability, implementation complexity, auditability, and time-to-value. The three methodologies most frequently considered, Inmon, Kimball, and Data Vault, address these challenges in fundamentally different ways.

This ebook provides a structured examination of these approaches, beginning with the technical foundations required to understand enterprise data modelling. It introduces the concepts behind data warehouses, the distinction between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP), relational normalisation, and the principal approaches to data modelling, including Entity–Relationship and dimensional modelling.

The book then examines the three major enterprise data warehousing methodologies in detail:

The Inmon approach is explored through its design philosophy, architectural structure, strengths, limitations, and practical application. Particular attention is given to its emphasis on enterprise-wide integration, normalisation, and the establishment of a centralised and consistent source of organisational data.

The Kimball approach is examined from the perspective of dimensional modelling, business-oriented data marts, conformed dimensions, and analytical performance.

The Data Vault methodology is analysed through its distinctive separation of business keys, relationships, and descriptive context.

A central element of the book is the comparative benchmark analysis, which evaluates Inmon, Kimball, and Data Vault against a common set of architectural criteria. Rather than presenting one methodology as universally superior, the analysis identifies the circumstances in which each approach is most appropriate.

Together, these chapters provide a practical framework for data professionals and decision-makers who need to select, justify, evaluate, or challenge an enterprise data warehousing architecture whose consequences may extend well beyond the immediate project.

What You'll Learn

• The technical foundations of enterprise data modelling and data warehousing
• The differences between OLTP and OLAP environments and why they matter for data architecture
• The principles of relational normalisation and dimensional data modelling
• How Entity–Relationship and dimensional modelling approaches differ
• The architecture, design philosophy, advantages, and limitations of the Inmon methodology
• The architecture, design philosophy, advantages, and limitations of the Kimball methodology
• The core principles and architectural components of Data Vault
• How Inmon, Kimball, and Data Vault differ in governance, agility, flexibility, performance, and implementation complexity
• How to evaluate data warehousing methodologies against organisational constraints and priorities
• When each methodology is most appropriate for different enterprise scenarios
• Why hybrid data warehouse architectures can provide a practical balance between competing requirements
• How to use comparative criteria as a structured decision-making framework for enterprise data architecture

Target Audience

• Data Architects designing or evaluating enterprise data warehouse architectures
• Enterprise Architects responsible for organisation-wide data and technology strategy
• Data Engineering Leaders selecting methodologies for large-scale data platforms
• Analytics and BI Leaders evaluating architectures for reporting and analytical workloads
• Data Platform Managers responsible for the design and evolution of enterprise data infrastructure
• Technology and Data Executives sponsoring or challenging major data platform investments
• Solution Architects and Technical Leads making architectural decisions across data integration and analytics environments
• Data Professionals and Practitioners seeking a structured understanding of Inmon, Kimball, and Data Vault
• Students and Professionals who want to develop a stronger foundation in enterprise data warehousing and data architecture

Why This Ebook Is Different

Many resources explain individual data warehousing methodologies in isolation. This ebook takes a different approach by placing Inmon, Kimball, and Data Vault within a common comparative framework.

The key question is not:

"Which data warehousing methodology is the best?"

It is:

"Which methodology best fits the organisation's constraints, priorities, and long-term architectural objectives?"

By examining each methodology through the same architectural lens, the book makes the underlying trade-offs easier to understand and evaluate.