A common thing I keep forgetting when I try to import an excel file into PowerBI is the fact that the data in the excel sheet needs to […]
Word Cloud on Second Presidential Debate :- SSIS and PowerBI
With the recent debates on the US presidential election we felt it presented a good opportunity to do some text analytics on the second presidential debates. We used […]
Very Large datasets GB to TB – Where to get them for free?
Every once in a while I need a very large dataset to work with, most often this required creating dummy data using one of my favorite data generators […]
Have Databases become a glorified versions of EXCEL?
Recently I was having a discussion about how coding and design patterns have changed in RDMBS and if we can still call it RDBMS anymore. Very early in […]
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 […]
Combining Results from multiple datasets in SSRS – performance comparison
Recently at a training I was asked how to combine the results from two different datasets, while I have used this function before I couldn’t recollect how much […]
Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy
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 […]