Optimizing Real-Time Energy & Asset Management

Objective

The global energy brand aspired to utilize the large amounts of live data created by their Fuel Stations & Convenience Stores (IoT Devices at POS) to track Energy, Carbon footprint, emergency alerting, assets maintenance & expense control.​

Industry: Energy & Resources​

Technology: Microsoft Fabric, Notebooks, Pipeline, One Lake, Dataflow, Semantic Models, Power BI, SharePoint, Power Automate, Power Apps, Data Activators​

Goals:

• Utilize live IoT data to create reports for management and implement real time emergency alert system.​
• Centralized data from SharePoint, REST APIs, and other sources to track energy use and carbon footprint.​
• Create systems for global asset monitoring with detailed insights for decision making using Power BI reports.​
• Build dynamic applications to facilitate maintenance tracking across worldwide locations.

Our Solution

• Ingested millions of records a day into reports with alerts and custom Power application apps.​
• Build dataflows and notebooks to ETL the real time API data into Fabric One Lake.​
• Unified data after ingestion from SharePoint, APIs & other sources, developed reports to track energy, assets, tariffs and maintain POS systems worldwide.​
• Real time email alerts using Power Automate and utilized Power Apps to trace their global maintenance efforts.

Business Value

• Tracked carbon and energy footprints, managed their assets and devices, get insights based on location devices and manage tariffs and other expenses.​
• Informed decisions based on the Power BI reports and track their assets globally.​
• Alerts mechanism enabled the client to take quick actions in case of emergencies.​
• Utilize large amount of real time data and look deeply into the working of each POS system (IoT) across the globe.