AI engineering glossary · Data engineering

What is data modelling?

Data modelling (also called Dimensional modelling): Designing how data is structured and related in a system, at conceptual, logical and physical levels. In analytics it includes choosing tables, keys and relationships so that data is consistent and easy to query.

Level: intermediateTopic: Data engineering

Data modelling: an example

A team decides that customers, orders and products become separate tables linked by keys, with a date dimension for reports.

Related terms

More Data engineering terms

Where you learn it

Data modelling is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.