Optimizing Real-Time Energy & Asset Management

Tech Stack

Microsoft Fabric, Notebooks, Pipeline, Lakehouse, Dataflow, Semantic Models, Power BI, SharePoint, Power Automate, Power Apps, Data Activators

Problem

The client, a global energy brand, wanted to utilize the large amounts of live data created by their POS systems to generate multiple reports for their management teams and alert them of emergencies.

Solution

1. We created a solution in Microsoft Fabric ingesting millions of records a day into reports with alerts and custom power app applications.
2. The solution consisted of multiple dataflows and notebooks that cleaned and transformed the incoming real-time data into fabric Lakehouses. The real time data came from client REST APIs.
3. We also unified the data stored in the client’s SharePoint and other sources into One Lake in Microsoft Fabric.
4. We developed multiple reports which enabled the client to track their energy and carbon footprints, manage their assets, devices and tariffs and trace the maintenance of multiple POS systems worldwide.
5. The alerting mechanisms were created using Power Automate and directly connected to the reports providing real-time alerts and insights through emails. The alerts were segregated in multiple levels; hence they were managed differently.
6. We also utilized Power Apps to create dynamic applications for the client which helped them trace their maintenance efforts across the globe.

Impact

Using the solution the client was able to effectively keep track of their carbon and energy footprints, manage their assets and devices, get insights based on location of the devices and manage tariffs & other expenses.

The internal management of the client was able to take informed and wise decisions based on the multiple Power BI reports and track their assets in multiple countries.

The alerting mechanism enabled the client to take quick actions in case of emergencies.

The client was able to fully utilize their large amount of real-time data and look deeply into the working of each POS system across the globe.