Working in knowledge science and analytics for seven years, I’ve created and queried many tables. There are quite a few occasions I ponder, “What does this column imply?” “Why are there two columns with the identical identify in desk A and desk B? Which one ought to I take advantage of?” “What’s the granularity of this desk?” and so on.
If you happen to’ve confronted the identical frustration, this text is for you!
On this article, I’ll share 5 ideas that may make it easier to create tables that your colleagues will admire. Please word that that is written from the angle of an information scientist. Subsequently, it won’t cowl the normal database design greatest practices however give attention to the methods to make user-friendly tables.
Sustaining a single supply of reality 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, typically 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…