Skip to main content

Dimensional Modelling - SCD

· 6 min read
Vibhavari Bellutagi
Data Engineer

Im sharing my learning from the Data Engineering Bootcamp, where we are learning about Data Engeering. Today we are learning about Dimensional modelling - Idempotency and SCDs.

I would like to extend my gratitude to Zach Wilson, the founder of DataExpert.io, for his invaluable guidance and the comprehensive Data Engineering Bootcamp. Connect with Zach Wilson on LinkedIn.

Thank you, Zach, for this amazing intense bootcamp on Data engineering!


Day-2: Dimensional Modelling - Slowly Changing Dimensions (Theory)

Dimensional Modelling - Cumulative Table

· 9 min read
Vibhavari Bellutagi
Data Engineer

Im sharing my learning from the Data Engineering Bootcamp, where we are learning about Data Engeering. Today we are learning about Dimensional modelling - Cumulative Table.

I would like to extend my gratitude to Zach Wilson, the founder of DataExpert.io, for his invaluable guidance and the comprehensive Data Engineering Bootcamp. Connect with Zach Wilson on LinkedIn.

Thank you, Zach, for this amazing intense bootcamp on Data engineering!


Day-1: Dimensional Modelling (Theory)

What is a Dimension?

Dimension are attributes of an entity ( example: user's name, age etc)

  • Dimensions may be IDENTIFY an entity, which would be a unique identifier for the entity (example: user_id, device_id etc)
  • Dimensions may be DESCRIPTIVE which would be the attributes of the entity (example: user's name,age etc) but wont be unique.

Welcome

· One min read
Vibhavari Bellutagi
Data Engineer

Welcome dear readers...

Im Vibhavari Bellutagi, from India, currently staying in France. I'm a Data Engineer and I got sometime to channelise my thoughts and experiences in the form of blog. I'm a big fan of Learn by Doing, so you will see most of the posts are practical oriented.