It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Frederik Vandeputte

Frederik Vandeputte is a senior consultant and partner at Kohera, the largest Belgian Company fully focused on SQL Server and Microsoft Business Intelligence. Frederik is one of the co-founders and the President of the Belgian SQL Server User Group (SQLUG.BE). In January 2008 Frederik, became the first Belgian MVP on SQL Server

Blog posts

Over the last few years I have created many PowerPivot models and almost every single one of them had a calendar dimension. One of the top items on my "personal PowerPivot feature wish list" is a Calendar Dimension Wizard. It would be great to have a Calendar Dimension wizard ...

Earlier this week Microsoft released the Office 2013 Customer Preview. PowerPivot and Power View are now first class citizens in Excel, how cool is that. I will blog about the BI features of Excel 2013 in the future.But today I want to share a nice long awaited feature for PowerPivot: ...

SWITCH() is a new function introduced in PowerPivot v2. SWITCH() is a great alternative for nested IF() functions in DAX. Let's have look at a very simple example.Let's say I want to categorise scores, 1 to 5 would become a C, 5 to 8 becomes a B and everything above 8 is an A.In ...

KPIs are a nice new feature in PowerPivot 2012. I blogged about KPIs before. In PowerPivot KPIs have a value, a target and a status. Compared to KPIs in full blown Analysis Services OLAP cubes we are missing the possibility to visualize the trend of the KPI.In this ...

In Belgium there is a lot of buzz going around the higher taxes on company cars. In Dutch it's called "Voordeel Alle Aard". The goverment changed the way this tax is calculated. Everybody with a company car in Belgium is now trying to find out wether he will pay more or less ...