Automated Testing for the Data Warehouse

Case: we've integrated two sources of customers. We want to add a third source. Q: How do we at the same time know that our current integration and solutions will continue to work while at the same time integrating the new sources? A: Test it. Q: How do we get faster deployments and more stability? A: Automate the tests, so
Continue reading...

Calculating commute distance using SSIS and the GoogleMaps API

Last week, I had an interesting question from one of my clients about estimates of planned commute distances. For example: What is the distance I travel when I, living at Kalverstraat 7 (Amsterdam) commute five days a week to my customer in Paris (1, rue Victor Cousin)? By the way: it should be calculated for all employees, for
Continue reading...

Security and the Enterprise Gateway

While upgrading from Analysis Services Connector to the Power BI Enterprise Gateway, you might notice a change in authorization structure. Here's a brief description of the differences you need to know when upgrading. I thought there was a change in authorization structure, but I had didn't fully understand the way Analysis Services Connector authorizes its users.
Continue reading...