Designing intuitive and dependable tables that your information group will love
Working in information 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 so on.
When you’ve confronted the identical frustration, this text is for you!
On this article, I’ll share 5 ideas that can make it easier to create tables that your colleagues will recognize. Please observe that that is written from the attitude of an information scientist. Due to this fact, it is not going to cowl the normal database design greatest practices however concentrate on the methods to make user-friendly tables.
Sustaining a single supply of reality for every key information 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…
