IoT is often associated with developer boards such as the Raspberry PI or Arduino. However, IoT has not only played an important role under the slogan „Industry 4.0“, many industry companies are using IoT in their production lines since years.

To show the potential of the Azure IoT in connection with industry components, we have took a conveyor belt, a sorting unit and sensor technologies built-in in a small flightcase. All these industry components are communicating directly to an Azure IoT Hub.

See how we can analyze the generated data with Stream Analytics and building Power BI dashbaords with streaming data. We will also show how we can interact with the components via cloud 2 device messages if the analysis shows errors or disfunctionalities and how Cortana Analytics can help minimize errors.

If you look into the Gardner Quadrant you will see two major players in Self-Service BI: Tableau and Power BI. Of course there is a lot in the press, but hey, here are two guys one Microsoft MVP and a Tableau Expert and these to will hold a final of these massive competitors battling on a real world exercise. If you are interested to see the differences in playing skills, tackling, pressing and how the goal keepers handle penalties. have a look. After that session you are prepared and know whether a Tableau or Power BI come in and says: I can do this in my tool better… and we can tell you: It will be fun as well to see the battle.

Have you ever considered a situation where Columnstore Index can be quite the opposite of what one would expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources …

Setting the wrong expectations (it won’t run 100 times faster on EVERY query), selecting the wrong architecture (partition by 100s of rows instead of millions), using and aggregating by the large Strings in the fact tables – this list is actually quite large.

What about some of the less known limitations for building Columnstore Indexes? The ones that will bite you suddenly in the middle of the project – when you do not expect it at all?

Let me show you how to achieve those painful mistakes and you will surely know how to avoid them 🙂

Since April 2017 another fascinating PaaS in the Microsoft Cloud reached general availability: Azure Analysis Services.
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud?
This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.

Gabi Münster