The History of War Analyzed

War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count…

Business Intelligence on a Phone Bill

I often tell my trainees that BI can be done on pretty much anything. A common example of this is the Phone Bill or the Bank statement. Your phone bill or statement can give an idea of not just your spending habits or preferences but even your routine and much more. I recently decided to…

SSAS: – Dimension Hierarchies

Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension in the previous post. In particular this kind of relationship was a parent child relationship or a hierarchy between Years to Month to Week to Day. Such…