Challenge:
Senversa undertook a significant pilot initiative to address the complex Environmental, Social, and Governance (ESG) data management and reporting challenges faced by Melbourne Airport. The existing data management process relied on spreadsheets, third party data and a number of data projects, leading to potential issues such as inconsistent data entry, formula errors, and various data sets. To mitigate these challenges, the organisation sought an advanced and well-structured pilot solution to streamline ESG data capture, management, and visualisation for comprehensive analysis and reporting.
Solution:
Senversa devised a digital enablement solution, leveraging the Microsoft software stack, tools the organisation already had access to. The key elements of the solution were:
- Proposed database structure: Recognising the limitations of a conventional master spreadsheet approach, Senversa configured Microsoft Lists to align with the ESG data categories. The data collection process for each ESG category was mapped, enabling the identification of essential data columns forming the foundation of the List.
- Development of the new data capture solution: To ensure streamlined and standardised data capture, Senversa crafted an intuitive PowerApps application that was integrated with the List, facilitating real-time data display and management. The List and App features included:
- A customisable and scalable structured data solution.
- Data integration with Power BI, ensuring consistent reporting capabilities.
- Data filtering and export functionalities for in-depth analysis.
- Support for attachments and comments, ensuring comprehensive audit trails.
- Implementation of conditional forms, empowering role-specific data entry and access controls.
- Configuration of POC Power BI Report: As a proof of concept, Senversa incorporated historical data into the List and PowerApps application, alongside a Power BI dashboard comprising a Summary report and a Usage report. The Summary report aggregated data into financial year totals, effectively presented through a range of interactive and visually compelling graphic representations, encompassing gauges, cards, charts, and time-series line charts.
Outcome:
The implementation of the APAC ESG Digital Enablement solution yielded several notable outcomes:
- Enhanced Data Management: The adoption of Microsoft Lists as the bedrock of the database solution significantly improved data management practices, effectively addressing the complexities and errors often associated with traditional spreadsheets.
- Streamlined Data Capture: The introduction of the PowerApps application facilitated consistent and efficient data entry in a single, central location, empowering personnel to contribute data based on their designated roles and access levels, ensuring enhanced accuracy and user satisfaction.
- Sophisticated Data Visualisation: The Power BI dashboard emerged as a potent tool, providing intuitive and interactive visualizations, thereby empowering APAM personnel to analyse ESG data comprehensively for robust reporting and informed decision-making.
- Scalability and Collaboration: The inherent scalability of the solution facilitated seamless expansion and collaboration with external stakeholders, thus amplifying the organisation’s collaborative potential and strategic partnerships.
Conclusion:
Senversa’s execution of the APAC ESG Digital Enablement solution not only effectively addressed the organisation’s data management challenges but also set a new benchmark for innovative and sophisticated ESG data management practices. By expertly integrating Microsoft Lists, PowerApps, and Power BI, Senversa successfully streamlined operations and demonstrated the immense potential of digital technologies in revolutionising ESG reporting and bolstering the organisation’s overall sustainability.
View More Projects