Sustainability Data Analytics and Reporting

Inspiration

Leverage AI/Analytics to reduce environmental footprint namely energy, water, emission and waste to achieve corporate sustainability goals

What it does

The comprehensive list of datasets from different stakeholders belongs to organization unit across different businesses under a corporate have to be manually gathered, integrated with different systems, processed, validated and reported periodically. The data available in electronic form, IT systems or regulatory authorities are the sources and forms the basis to perform analytics and corporate reporting.

How we built it

Built using Microsoft Power Platform - Power Apps, Power Automate, Power BI to enable data gathering, validation and integrated and Cognitive Services are used to perform intelligent data processing from documents.

Challenges we ran into

Human error in data gathering
No traceability and audit trails of data
Time consuming process to validate and aggregate data
Easy and convenient way to access reports
Advanced analytics to prediction
Gathering data from documents

Accomplishments that we're proud of

Specific to Energy Data for a large manufacturing unit are accomplished

Enabled Power Apps platform to prevent error in data gathering
Enabled data lineage across the value chain of data gathering aggregation, validation and reporting
Workflow enabled for creation, modification, reviews and approval across the value chain
Advanced analytics and reporting for corporate
Proof of value for intelligent document processing to avoid manual efforts and errors

What we learned

Rich features of Power Platforms and Cognitive Services to enable Sustainability Data Analytics Platform

What's next for Sustainability Data Analytics and Reporting

Enhance the solutions to 9 manufacturing units for data analytics and reporting for Energy, Water, Waste and Emission in next 4 months
Production grade implementation of intelligent document processing
Self-service corporate sustainability reporting for CxO