Glossary · Analytics engineering and analytics

Data modelling

Designing how data is structured, related and defined so that it accurately represents the business and supports the questions people need to answer. Models range from conceptual diagrams of entities to the physical tables in a database.

Why it matters

The data model determines what can be asked easily, what is hard and what is ambiguous. A weak model forces every analyst to reinvent joins and definitions, and that inconsistency eventually reaches decisions.

Good modelling starts from business processes and decisions, involves the people who own them, and documents definitions alongside the structures.

In practice

For example, a UK further education college might model learners, enrolments, courses and outcomes explicitly, including how a learner can hold several enrolments in a year, so retention and achievement rates are calculated consistently.

Where Rodan fits

Rodan designs data models around real decisions in Analytics and Intelligence work.

Related terms