← Back to Training & Enablement

Data & AI Training

Foundations of Data Modelling

Understanding why we model data and how good models enable clarity, consistency and scalable analytics.

Code: DM1 Track: Data Modelling Length: 1 hour (other formats available) Level: Foundation
Delivered with

Overview

Data modelling is often seen as a purely technical activity, disconnected from business value. In reality, data models are one of the most important bridges between business understanding, analytics and system implementation.

This session provides a clear foundation in data modelling, explaining why models exist, the different types of models, and how they support decision-making, reporting and system interoperability. The focus is on conceptual clarity and practical application, not notation-heavy theory.

Who it is for

  • Business analysts and data analysts working with structured data.
  • Data engineers and architects designing data platforms.
  • Product and domain leads responsible for data-heavy products.
  • Anyone involved in defining or consuming data structures.

What you will learn

  • Why data modelling matters beyond database design.
  • The difference between conceptual, logical and physical models.
  • How models support shared understanding across teams.
  • How modelling choices affect analytics, quality and change.
  • Common modelling mistakes and how to avoid them.
  • How modelling underpins data quality and governance.

Agenda

  • Why modelling is often skipped and why that causes problems.
  • Conceptual models: defining the business view.
  • Logical models: structure, rules and relationships.
  • Physical models: implementation considerations.
  • How models evolve over time.
  • Examples of good and bad models.
  • Discussion and Q&A.

Delivery and format

Delivered as a 1 hour interactive session. Can be extended into a hands-on modelling workshop using real business domains.

  • Format: Live virtual or on site.
  • Group size: Up to 25 participants recommended.
  • Optional: Follow-up hands-on modelling workshop.

Next steps

This course is commonly paired with: DM2 · Relational Modelling (ERD), DM3 · Dimensional Modelling (Star Schema) and DQ1 · Foundations of Data Quality