BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20170407T111500Z DTEND:20170407T121500Z LOCATION:Dome 5, SQLBits 2017, The International Centre SUMMARY:Near real-time IoT Analytics of Pumping Stations in PowerBI DESCRIPTION:An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI X-ALT-DESC;FMTTYPE=text/html:

Near real-time IoT Analytics of Pumping Stations in PowerBI

In this session we will show an alternative IoT analytics solution, addressing real-life issues in SCADA data and Azure. The solution analyses anonymised data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. We will show how we dealt with the idiosyncrasies of SCADA data, how we formulated the likelihood of spills at pumping stations, how we achieved near real-time reporting, and still produced compelling visualisations in PowerBI using various techniques. This is an end-to-end solution utilising Azure Blob Storage, Azure Data Warehouse, Azure Data Factory, Azure Batch, C#, Azure Analysis Services, and PowerBI. At the end we will also compare the pros and cons of this solution to other real-time analytics options.

Mehmet Bakkaloglu

Mehmet is a Manager in the Business Insights & Analytics practice at Hitachi Consulting. Based in London, he works with clients around the UK on Microsoft Azure and on-premise solutions. His sector experience includes Water, Healthcare, Retail and Transport. He has 13 years of professional experience covering the UK, Africa, and North America. He received his M.Sc. from Carnegie Mellon University in the US, and his B.Sc. from Bogazici University in Turkey

UID:SQLBITS3334SEQUENCE:0 DTSTAMP:20170524T003533Z END:VEVENT END:VCALENDAR