Great article. Well written and well demonstrated.

I racked my brain on the best way to achieve snapshot tracking until I came across this. I still have some uncertainties in regards to performance, such as how far to look back and how best to model the data when tracking more than one figure (changing commission rates, product costs, etc) so that reporting queries run optimally. But I see this as a great start.

While it may be more transactional than traditional data warehouses, sometimes rules need to be bent to achieve the business need and this is a good example of just that.

Thanks!