Working in knowledge science and analytics for seven years, I’ve created and queried many tables. There are quite a few occasions I’m wondering, “What does this column imply?” “Why are there two columns with the identical title in desk A and desk B? Which one ought to I exploit?” “What’s the granularity of this desk?” and many others.
Should you’ve confronted the identical frustration, this text is for you!
On this article, I’ll share 5 rules that may enable you to create tables that your colleagues will admire. Please observe that that is written from the attitude of an information scientist. Due to this fact, it won’t cowl the standard database design greatest practices however concentrate on the methods to make user-friendly tables.
Sustaining a single supply of fact for every key knowledge level or metric is essential for reporting and evaluation. There shouldn’t be any repeated logic in a number of tables.
For comfort, generally we compute the identical metric in a number of tables. for instance, the Gross Merchandise Worth (GMV) calculation may exist within the buyer desk, month-to-month monetary report desk, service provider desk…
| Aug, 2024
