data-modeling
Posts tagged "data-modeling".
- Two Timestamps Beat a Status Column
A status column answers 'what state is this in now?' and destroys the answer to 'what state was it in last Tuesday?' every time you update it. Replace the one mutable cell with a couple of timestamps and the state becomes something you derive — reversibly, and as of any date you like.
- Your Date Dimension Is Not Static
A date dimension is supposed to be the one table you build once and never touch. Then someone adds an "IsCurrentMonth" column, and last quarter's report starts quietly changing overnight.