Microsoft Power BI Visualizes IoT Data From Azure Stream Analytics
A new integration allows customers to create real-time dashboards based on Internet of things data from their Azure Stream Analytics.Microsoft's business intelligence and analytics product, Power BI, is already helping enterprises keep an eye on key business metrics by transforming big data into charts, tables and other visualizations. Now, Azure Stream Analytics customers can use the cloud-based tool to convert Internet of things (IoT) data into insights that update in real time. Capable of handling millions of events per second, Azure Stream Analytics enables organizations to perform real-time analytics on data from IoT devices using an SQL-like language. Used in conjunction with Azure Event Hubs and IoT Hubs—two other cloud-based IoT communications and data collection services—Stream Analytics enables customers to aggregate and filter streaming data for further analysis. This week, Microsoft released a new output connector for Power BI, ushering in the creation of interactive, live dashboards that offer users an up-to-the-minute overview of their IoT device deployments. "This will dramatically reduce the latency and time to action on your most important business metrics," said Ryan CrawCour, a program manager at Microsoft Azure Stream Analytics, in an April 21 announcement. "We have been working with hundreds of customers in public preview to visualize data from sensors, business applications, social media, user logs, etc."
The connector can help eliminate several steps involved in building an analytics solution, said CrawCour. In addition to ingesting, processing and storing data in a database, drawing insights from IoT sensors, devices and applications often requires developers to build custom software that is in constant communication with the database. Further, they are also often required to build the end-user dashboards.