Data modeling is an essential part of data engineering. I would say it is a must if you want to become a successful data professional. Creating SQL transformation pipelines with multiple layers is a challenging task. During the process, it is important to keep things organized. In this story, I tried to summarize some techniques for convenient data structuring and describe the modeling techniques that I use on a daily basis. They often help me design and develop a big data platform or data warehouse that is accurate, easy to navigate, and user-friendly.
Naming Convention
Using a well-designed naming convention provides a very clear and unambiguous sense and meaning regarding the content of a given database object. It is always good to have established naming policies for tables and columns. It just shows how mature your data warehouse is and helps a lot during development.
Database entity names must be human-readable, at a minimum.
Keeping the database or a DWH with this in mind improves the user experience and simply makes it look better. Easy to use.
