Monthly Archives: March 2017

String split using full text indexes

By | March 16, 2017

Recently I needed a way to extract keywords from email messages in order to create a list of noise words for a spam filter as well as implement an auto complete kind of option for the search box. The first option that came to mind was to use Term extraction in a SSIS package. The… Read More »

Charting controls: – Things to keep in mind – Part 2

By | March 14, 2017

In this second part of the series on charting controls we take a look at a few lesser known charting controls. You can view the first part of the series by clicking here. Don’t use Area charts to plot a single metric unless it has to do with Volume. If there is a single metric… Read More »

An interesting conversation with Google Assistant

By | March 13, 2017

If you have read my previous posts you know that I have an interest in AI and machine learning. Recently my phone was updated to include Google Assistant. For those using the iPhone Google Assistant is the Android version of Siri and supposedly smarter at doing things for you. While I have already been using… Read More »

Charting controls: – Things to keep in mind

By | March 10, 2017

I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to use the raw data and represent any information in the way they see it being used by the CEO of the company”. The participants have complete freedom… Read More »