What we can achieve if Azure Synapse is integrated with Power BI.

We recently helped The Oil & Gas Technology Center (OGTC) and Microsoft to facilitate a codeless Power Platform hackathon to solve industry challenges like tackling CO2 emissions, avoiding downtime, increasing asset efficiency, etc. Intelligent Plant provided a live connection to vendors historians some of which contained years of data using the Industrial App Store.  Rightfully, the participants (engineers, data scientists and others) went ahead and tried to extract RAW data from data silos containing 5+ years of data for multiple sensors at 1s frequency, but is this the right approach?

Data historians are used throughout industry for mass-long term storage of time series data. There are a number of historians on the market with varying popularity but one thing they tend to have in common is their lack of integration options to popular visualisation tools such as Microsoft Power BI. Until now....

If you are an adventurous kind, you might discover a vast array of fancy chart types beyond the regulars you see or use every day: Sankey chart, spider chart (radar), waffle chart, candle stick chart, stream graph, sunburst, word cloud, stacked bubbles, and you name it. At some point, you might start to question: do I really need to know every visualization display ever created to be an effective analyst? My advice is: master core chart types first before getting fancy! It’s like storing house-fixing tools in your garage.

Recently I ran a free workshop for all of those connected to Enterprise DNA in some way. It was all about dashboarding and how to develop really compelling reports. Here's the reporting dashboard I showcased as I ran through my best practice visualization techniques - I'm making it available for download here along with the workshop recording