Concepts for Data Engineers: Data Modelling Topics

There is much more than star or snowflake schema when we talk about data modelling

Cássio Bolba
3 min readJun 8, 2023
image from https://www.lucidchart.com/pages/er-diagrams

Followed by the immense amount of reader on my post about dimensional data modelling, I realised that more people than I expected undervaluate this topic. And so, I decided to write a list of other important topics and concepts within data modelling that all data professionals should be aware of, and take advantage of this knowledge.

You might be interest in this series where I’m introducing several important concepts that new Data Engineers should be aware of. The other topics I talked so far:
Data Modelling
CDC
Idempotency
ETL x ELT x EL
Kappa x Lamda Data Architectures
Slowly Changing Dimensions — SCD
10 Concepts all Data Engineers should know

I also have 2 series about python:
🐍 Efficient Python
🐍 Software Engineering with Python

Entity-Relationship (ER) Modelling

In ER modeling, you learn to identify entities, their attributes, and relationships…

--

--