Data models best practices
Last updated
When building models, it's always good to follow the commonly accepted best practices in the industry. However, follow them with caution, and do not let them get in the way of getting stuff done. Here a some best practices that we have identified :
By creating small models, you will ensure that your future self or other users will quickly understand your model structure and output. By creating reusable models, you will ensure that there is also only one source of truth for every data in your company, which will be valuable in the long run
A lot of efforts can be spared when everything is consistent, and that's also the case in data. Try to use the same naming convention every time it's possible. A naming convention can be applied to you model names, your column names and even in the values that your models output.
It's always easier to work with data when you don't question yourself about the meaning or the content of a column. For exemple, if your model output a cost in a specific currency and in cents, you should probably name your column cost_cents_usd.
Last but not least, try to document your models by using the description feature in Whaly.
Last updated