Data modelling is a vital a part of Data engineering. I’d say this can be a must if you would like to turn into a successful data practitioner. Constructing SQL transformation pipelines with multiple layers is a difficult task. Through the process, it can be crucial to maintain things organised. On this story, I attempted to summarise some techniques for convenient data structuring and describe the modelling techniques I take advantage of day by day. It often helps me to design and develop an amazing data platform or a knowledge warehouse which is accurate, easy to navigate and user-friendly.
Naming convention
Using a well-designed naming convention provides a really clear and unambiguous sense and meaning regarding the content of a given database object. It’s all the time good to have naming policies for tables and columns in place. It simply demonstrates how mature your data warehouse is and helps so much throughout the development.
Database entity names have to be human-readable — at a minimum.
Maintaining the database or a DWH with this in mind improves user experience and easily makes it look more user-friendly.
