Category Archives: Databases

Everything related to databases. We love data and yes we love our databases too. Anything we do that relates to databases can be found here.

String split using full text indexes

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

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 »

Set based vs row by row (procedural code)

I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide a more complete reference. To provide some context I am explaining the business case here. A hospital wants to identify people whose heights have changed over time… Read More »

Calculating Pi in MS SQL Server

PI is a very commonly used mathematical constant, in fact it is probably more famous than the equation E=MC2. We might not find a lot of use for it within the database community but it is a fascinating value to calculate and so we set out to do just that. First we tried using the… Read More »

Loading multiple files into Power Query/ PowerBI

In this post we cover how to work with multiple files of type CSV when loading into Power Query. Very often we have a set of data provided in a specific format on a daily / weekly basis on which we want to perform the analysis using PowerBI. Combing the different files into a single… Read More »

DAX and Date Time or Time Intelligence Analytics

One the best parts of using analytics engines are their ability to understand dates and other types of hierarchies. As human being we use time as a core aspect in our measurement of change. Things like sales week on week or week over week. Year till date, month till date are all important calculations we… Read More »

Brand new video on PowerBI

  A brand new video on PowerBI, with a quick introduction on the tools. After which we create a report and use the basic features. https://youtu.be/tPrHkbgSj10

Loading an Excel file into PowerBI Cloud Service

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 be formatted as a table before you can import it. It seems a bit silly and doesn’t really compute since PowerBI seems so smart when it comes… Read More »