Home - Archive by category: Uncategorized

3 Important Lessons about Test Automation in Business Intelligence

As you might know, I’m keeping an eye on how I can automate my Data Warehousing testing. In “Automated Testing for the Data Warehouse” my observation was In essence, testing a Data Warehouse isn’t that complex It turns out I’m not the only one thinking about this (really? ūüėČ ). Some time ago¬†I listened to[...]
Read More

Azure ML Thursday 6: xgboost in R

Last Azure ML Thursdays¬†we explored how to do our Machine Learning in Python. Python in¬†Azure ML doesn’t include one particularly succesful algorithm though –¬†xgboost. Python packages are available, but just not yet for Windows – which means also not inside Azure ML Studio. But they are available inside R! Today, we take the same approach[...]
Read More

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[...]
Read More

Communicating with Azure IoT using Python

During last Christmas’ project (the Poor Man’s IoT – read more about it¬†here¬†and here) I wanted¬†to build a small Proof of Concept communicating my home freezer sensor to Azure IoT. However, if you’re not a C# dev, the steps to set up this ‘small’ Proof of Concept can be quite daunting – especially if you’re[...]
Read More

Gathering knowledge and keeping up

When training and coaching Microsoft Business Intelligence developers and analysts, people sometimes ask how to keep up with all the new stuff developing. Or, how to start building your knowledge inside your profession. Here are some thoughts about that.
Read More

Latest Posts