Here is an overview of the articles I published in the second quarter of 2015. INTENSE SCHOOL Book Review: Query Tuning & Optimization by Benjamin Nevarez MSSQLTIPS I’ve been busy writing tips! Purging Entity Members in SQL Server Master Data Services Using the Transaction History in SQL Server Master Data Services Introduction to Power Query for […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Browsing "power bi"
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use Power Query to do a […]
ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the other speakers! My session went pretty well, at least from my point of view, although I had to rush my demos a bit since there was only a 50 minute time slot. I prepared for […]
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying Power BI. Basically it introduces the full Power […]
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this: For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the United States. In Belgium (and other […]
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update: Downloading and installing service pack 1, aka the old-school method. Simply having the Click-To-Run […]