Yes, you’re reading that right. A book not about the Microsoft BI stack. At a project, Pentaho Data Integration (PDI) was used as an ETL tool. To get to know this tool a little better, I bought the book Learning Pentaho Data Integration 8 CE (Third Edition) by the author Maria Carina Roldán. For those of […]
Tag: business intelligence
Techorama 2018 Session Materials
Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely organized. Big thanks to the organizers, sponsors and attendees of course. My session on data modeling in self-service BI went really well (but I had some time left at the end). I promised to share […]
T-SQL Tuesday #100!
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the Creator himself: Adam Machanic (blog | twitter). The topic is the future: what will the world be like when it’s T-SQL Tuesday #200? The very first T-SQL Tuesday was over eight years ago, which was […]
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post SQL Server Data Tools 2017 and TFS Integration. UPDATE 2018-06-20: I was finally able to install the stand-alone version of SSDT for VS 2017 with working TFS integration. Read more about it here. Finally, months […]
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016. The title is SQL Server BI Best Practices and its abstract goes like this: Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS. Our presenter, Koen Verbeeck has several years of experience working with the SQL Server Business […]
Reblog: Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll give a short review for each one of them. Information Dashboard Design This book, written by Stephen Few, was the first one I read. And it was a fascinating read! I went through the […]
Overview of Published Articles – 2015Q3
Here is an overview of the articles I published in the third quarter of 2015. Retrieve file sizes from the file system using Power Query Create a Treemap Graph in SQL Server Reporting Services 2016 How to create a heat map graph in SQL Server Reporting Services 2016 How to create a Sunburst Graph in SQL […]
What’s new for BI in SQL 2016 – Session materials
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I gave a session on the new […]
The SSDT Evolution
When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects. If you have a full blown Visual Studio installation, you needed the BI templates; if you didn’t have Visual Studio (or the right version), you would install a shell that could […]
Reblog: How I prepared myself for the MCSE certification
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today. Last week (this is a repost, so not actually last week but over 2 years ago) I […]