Have you encountered a situating where your main customers are mainly college going students and they are your main customers and you have seen substantial revenue drops when these students pass out and move to new place for jobs or higher studies. Well even a blind can say , as the company do not have office in new place. However can you say which are popular cities/places where your customer students are moving or what’s the revenue drop when they move and what’s the operation cost to set up a new office in new place where customers are moving.
Yes, you can track this data easily by having slowly changing dimension in Datawarehouse and can build effective report showing all place where customers are moving and can easily calculate the revenue drop and one time setup cost of new office in new place.
Technical Definition of Slowly Changing Dimensions:
Slowly Changing Dimensions (SCD) are dimensions that have data that slowly changes.
There three types of Slowly Changing Dimensions
Slowly Changing Dimension Type 1 ( SCD Type 1 )
Slowly Changing Dimension Type 2 ( SCD Type 2 )
Slowly Changing Dimension Type 3 ( SCD Type 3 )
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts: