I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only […]
Training MSBI professionals in Wells Fargo (MAR)
Always looking forward to training BI professionals since I am fascinated by how data is getting used in the decision making process. And doing this training for Wells […]
Sometimes common sense takes a back seat to BI
This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime […]
Conditional Flow using SSIS Expression task
One common usage for the expression task in SSIS is to implement conditional flow of the constraints. In the below screenshot you can see that we implement an […]
Datawarehouse and Plastic Bags ….
I was recently having a discussion about the role of default values in the fact table. The example being discussed had to do with a retail business who […]
Bangalore – Bengaluru Slowly Changing Dimensions
I would like to introduce Type 6 EBS Modified SCD and get your feedback. I couldn’t find any documentation explaining this approach so I guess this is a […]
User based security in SSAS
Recently a trainee from one of my MSBI trainings contacted me about how to implement user based security in SSAS. This is a common requirement where companies want […]
Game Theory and Databases
CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with […]
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 […]