You may have experienced it: your report was working just fine, untill you published a database change and oops! a report doesn't work anymore. Especially when you have about 70+ reports running their own queries, this can be a pain. Why would a report contain a query? Well, because it is easy, quick to develop,
Continue reading...
Uncategorized
I have been trying out Azure Data Factory. You can wonder if ADF is more like SSIS in the cloud or SQL Server Agent in the cloud. It does not quite feel like a pure ETL tool. Coming from SSIS on premise this is a completely different experience. My first impression is that the UI is
Continue reading...
If you are using Power BI, you may want to consider how you are going to share your reports and dashboards. Should you share your dashboards? Should you use groups or content packs? There are several ways to do this. Share your Dashboards: open your dashboard and click on the "Share" Icon. Your recipients
Continue reading...
There are still a lot of people who do not believe BI and cloud go together. "My data is too valuable to store anywhere else but on premise!". Most of the times we are talking about gut feeling here. It is not a strange thought either. But the funny thing is: maybe your data is
Continue reading...
As you might remember, I ran a few posts covering Azure IoT Hub early this year: Azure IoT is out! Here's how you connect with Power BI Building the Poor Man's IoT Last Saturday, I did a talk on SQL Saturday in the Netherlands covering my experiences. If you're interested in my presentation, the slidedeck is on the
Continue reading...
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
Continue reading...
Happy first birthday, Power BI! Exactly one year ago, Power BI was released in public. But this wasn't the only release: one month after the public release of Power BI my daughter Sanne was born.
Continue reading...
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...
Sometimes innovations take you by suprise. I just started using a Windows Phone and I was at my parents, checking out the maps app. I was always a big fan of the Google Maps app on Android and how well it predicts traffic jams, so I was curious to see how Bing would handle this.
Continue reading...
I once heard someone say: if you use SSIS to do ETL, you are just not a good enough programmer in SQL. Needless to say I had some thoughts about that! We had a discussion about ETL and what tool is the most suited for that task. In the end it came down to the fact that
Continue reading...