Monthly Archives: December 2016

RDP to AWS instance results in hang on “Configuring Remote Session”

By | December 10, 2016

Faced this issue a few minutes back and it has to do with the local system settings and firewalls in particular. Here are the steps I tried in the order I tried them First checked if I was typing in the password correctly. Checked if the security group for the instance has been modified to… Read More »

Loading multiple files into Power Query/ PowerBI

By | December 1, 2016

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

By | December 1, 2016

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 »