SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve now finished the remainder of the courses. Now I only need to finish the capstone project. This project only occurs at the start of each quarter and runs for a… Read more

0 comments, 1,922 reads

Posted in Koen Verbeeck on 19 June 2017

Where’s the Trend Line in Power BI Desktop?

A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it is in the analytics pane for certain types of visualization. However, it doesn’t always show up:

(I really resisted the urge to post another “Dude, where is my car” image) Read more

0 comments, 1,220 reads

Posted in Koen Verbeeck on 13 June 2017

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the… Read more

3 comments, 749 reads

Posted in Koen Verbeeck on 26 May 2017

Power BI Announcements Summary

It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well.


Again an amazing release (May 2017). Noticeable features are:

  • Measures on top of live…

Read more

0 comments, 862 reads

Posted in Koen Verbeeck on 5 May 2017

Book Review – The Truthful Art

I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about data visualization and we post our thoughts online. A blog post with more detail: Introducing our Data Viz Book Club. The first selected book is The Truthful Art by… Read more

1 comments, 1,003 reads

Posted in Koen Verbeeck on 21 April 2017

PASS BA Marathon – Spring Edition Q&A

The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar went great (lots of great feedback!) and there were a lot of interesting questions. You can find the recording here. Since I didn’t have the time to answer all… Read more

0 comments, 422 reads

Posted in Koen Verbeeck on 19 April 2017

T-SQL Tuesday 89 – Roundup

I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how it impacts their daily job. The response was overwhelming: we had 30 participants in this months blog party!

Here’s an overview of everyone who participated. Take your time to read… Read more

2 comments, 223 reads

Posted in Koen Verbeeck on 18 April 2017

T-SQL Tuesday #89 – The times they are a-changing

This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the fast changing world of data management? Does this impact your job? Or do you feel there’s no impact at all for your position? Do you fear the cloud? And… Read more

2 comments, 1,503 reads

Posted in Koen Verbeeck on 11 April 2017

T-SQL Tuesday #89 Invitation – The times they are a-changing

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic (blog | twitter) and I’m honored to host this month’s… Read more

19 comments, 185 reads

Posted in Koen Verbeeck on 4 April 2017

T-SQL Tuesday #88 – The daily (database-related) WTF

It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as… Read more

0 comments, 273 reads

Posted in Koen Verbeeck on 14 March 2017

Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon

I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon is Data Driven Storytelling and Data Discovery. My session will focus on working with Power BI Desktop: getting data in, cleaning it, creating a model and visualizing the data.… Read more

3 comments, 197 reads

Posted in Koen Verbeeck on 6 March 2017

Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages

I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS,  a scheduler that “runs, monitors and audits critical processes across a diverse array of servers and business applications”. Anyway, the title is Executing, Configuring and… Read more

4 comments, 1,202 reads

Posted in Koen Verbeeck on 1 March 2017

Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the… Read more

1 comments, 1,173 reads

Posted in Koen Verbeeck on 28 February 2017

Updates to the Power BI course

Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback that IMDB actually doesn’t like people scraping their website for data. Furthermore, the OMDB API appears to have fallen almost out of funds and is… Read more

0 comments, 227 reads

Posted in Koen Verbeeck on 16 February 2017

Open Source Power BI Desktop Workshop

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you… Read more

10 comments, 760 reads

Posted in Koen Verbeeck on 13 February 2017

Missing Checkbox for Security Filter in Power BI Desktop

Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox.
I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship.… Read more

0 comments, 936 reads

Posted in Koen Verbeeck on 9 February 2017

Dynamically Changing Shapes in Power BI – Alternatives

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well… Read more

10 comments, 984 reads

Posted in Koen Verbeeck on 8 February 2017

Dynamically Changing Shapes in Power BI

UPDATE: I also published a blog post using a DAX only approach. Check it out here.

Recently someone had a question if it was possible to change the color of a shape depending on the value of a measure. Imagine for example a dashboard with the picture of a… Read more

9 comments, 1,903 reads

Posted in Koen Verbeeck on 7 February 2017

Microsoft Data Platform MVP Award

I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is a great honor and I’m grateful for all the support I’ve received of Microsoft, my peers and the SQL Server community over the past years. I’d like to… Read more

3 comments, 319 reads

Posted in Koen Verbeeck on 2 February 2017

Speaking at Techorama 2017

I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but not limited to) Microsoft technologies. This year, the event is even bigger as they have merged with the IT Pro event ITPROceed (where I have spoken 3 times in… Read more

0 comments, 241 reads

Posted in Koen Verbeeck on 31 January 2017

Older posts