If you are interested in learning more about how you can manage data categorization in Excel while preserving historical values, a concept known as a “slowly changing dimensions” (SCD). Managing and ...

In a previous blog entry I discussed the concept of the Slowly Changing Dimension or SCD. A good example is how to handle the analysis of Sales by Customer Region when a customer moves from one Region ...