Pregraph

Data

Data modelling for analytics

Fact and dimension tables, star schemas and slowly changing dimensions. How warehouses are organised.

About 15 hours of study.

Where to learn it

Read
Dimensional modeling techniques

Kimball Group

Fundamental concepts, then fact and dimension table techniques

Section not checked yet

Watch
Data Engineering Zoomcamp

DataTalks.Club

Module on data warehousing

Section not checked yet

Practise

No practice set picked yet.

Suggest one

Which roles ask for it

Before and after

Learn first

Helps to know: How databases work

Data modelling for analytics