Upcoming event - PowerBI Days

Just got my session confirmed for Power BI Days 2018 - Belgium on the 23rd of September.


Should be an epic event.


More info at http://www.powerbidays.com/

Building a Power BI Dashboard based Using SSAS and Azure Data Gateway

So today I decided to show how to build a Power BI Dashboard end to end.

Below is the video showing how I do it.

Oh my Gawd I can't believe that I missed that!!

Iv'e been working on this customer data take-on procedure this whole weekend (last 36h with 3h sleep)
and there is this one part that was just taking forever.. 

The efficient delete... that now had become ULTRA inefficient...


Below is a Video on how I solved it and what the actual problem was, so if you are interested in solving SQL problems take a look:

How to create Delta Load Patterns in SSIS

Below is a video tutorial on how to create a Delta incremental pattern in SSIS

Source code for the demo is in the video description.

How to avoid Pagelocks in large deletes

Here is a video I made about Deleting data from large tables, code samples in the video description.

Using PowerBI Desktop as an IDE

Its been a while since i posted anything here, but here goes nothing, below is a Video that I made as a DevOps / IDE tutorial for PowerBI, Enjoy.