PowerBI – Personalize Visual

This feature has been requested a number of times and it’s great to be able to see it being implemented in PowerBI finally. This feature is currently in preview. In order to enable preview features please review the link at the bottom of this post. Once the changes have been made you will need to…

Power BI – New Features – importing data and enabling preview features

PowerBI is one of the products where Microsoft aggressively releases features every month. The effort is paying off as it’s quickly become the industry standard for reporting. The most attractive aspect for most companies is the comparable visualizations at a very attractive price point. In this series of posts we cover the new features released…

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…

Better Triage: Getting hospital care delivered properly

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am…

Why I Train

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings from former participants who have taken the time to get back to me I have mentioned one such email below. Hi Jayanth,  This is Raja from Cognizant…

Whose money is it?

Recently I was faced with a challenge most people might face at least 1 or 2 in their life time. While in most cases the result is expected in this case it couldn’t follow the traditional approach for obvious reasons. So what am I talking about? I was on my way to the bank a…

SSRS Sorting data within a Report

Sometimes when we create reports we define the sort order of the data within the report itself. This allows the user to pick and choose data based on the sort order that make most sense when viewing the data. Notice how the second column ( which is the column order or position of the column…

SSRS Reports not rendering beyond 90 seconds

Today I came across an interesting problem with SSRS and ASP.Net. I usually have all my reports optimized to run quickly, this includes creating snapshots revisiting indexes etc. However for one of my clients the data is huge and we were using OLTP systems so query response times were still not great especially when it…

Drill through Reports

In the below report we are fetching the column that are present within a particular table by Entering the table name as an Input parameter. This works fine if all we are interested in is this report. What if we want to first start at a higher level such as the tables that belong to…