top of page
The Journal of My Work
#DataLounge video with #AltiusData talking about Storytelling and #PowerBI
A few weeks ago I got invited to the DataLounge YouTube series. I went on talking about my favorite topic Storytelling.…
Dynamic Period variance with DAX in #PowerBI
One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once…
Mass shooting data
For this month #LondonPUGDataViz, we are going to play with Gun violence archive data. This data is very interesting because it…
Split multiple columns into rows in #PowerQuery
Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always…
How I designed “Power BI Template to document the Power BI Service”
When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound…
SharePoint List Power BI Template
SharePoint is a killer; front end looks nice and beautiful. Once you start exploring behind the screens, that is when it…
Power BI Workaround – Drill Through Reporting in Power BI
So far I have seen many Power BI usage metrics demo’s or read blog posts about usage metrics, but not actually…
Modify Column Names Using Power Query M Functions
Update – There is already a dedicated function available to do this, Table.TransformColumnNames. Thanks Imke Feldmann for the shutout. You can…
Highlight a Specific Data Point using Power BI
For me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I…
Find level of Directories / Find String in Power BI
Directories at different levels are critical for some organisations. One of the requirements I received recently was to import Flat Files from directories (…
Validating Data using SSIS
I cannot believe it took me almost three months to recover from the house move. At last, I feel like I…
Data story – Property search with Power BI
Don’t wait for the opportunity CREATE it. I was just trying to create an opportunity to work with Power BI; that…
Dimensional Modelling Workbook
A few years ago when I was searching for a free dimensional modelling tool, through some forum; I saw this fantastic Dimensional…
I am a Microsoft Data Platform MVP :)
October 1st, 2016, 03:00 PM. I was in our car with my family on our way to Harveys and email notification…
How to add extra columns to an existing Power BI file which has CSV as data source
Quick Power BI Tip: Case: How to add extra / new columns to an existing Power BI file which has CSV as…
MY THOUGHTS ON SSIS 2016 – SSIS PACKAGE PARTS-2
This is the second part of SSIS Package Parts blog post, I would recommend you to read other part first! In the previous…
My Thoughts On SSIS 2016
SSIS has always been my favourite among all MSBI tools. I think it is ETL which interests me than specific SSIS.…
Download And Unzip files using Power BI Desktop and R Script
Most of the open data source providers supply data in a compressed format, especially when files are large. That is what…
Working With Teradata Volatile Tables And ADO.Net Connection
While I am in the flow of blogging, I want to write about an issue which troubled me recently. It definitely…
Twitter Analysis using SSIS 2016 and SQL Server R Services
After years of hesitation finally, I think I am ready to write my first blog post, or I should say I…
bottom of page