Monday 2 October 2017

6 data modeling best practices for better business intelligence by Kayla Matthews via @infomgmt

Although specific circumstances vary with each attempt, here are six tips to follow that should improve outcomes and save time.

I definitely agree with some of these observations.  Time, Status and history of values are all very useful at times. However be guided by the requirement - just be sensible in your design so you could extend it easily - you need to keep the future in your mind so check the roadmap of projects coming up in case they impact even slightly.

You will find this link useful - slowly changing dimensions


No comments:

Post a Comment

Note: only a member of this blog may post a comment.