Using Data & Analytics to empower Retta in its sustainable efforts
Published:
October 3, 2023
Category:
Product Engineering
Client:
Retta
Company Overview
Retta is the largest professional service group in the Nordics specializing in the brokerage and management of apartments, properties and offices. Retta provides its customers with comprehensive services and solutions in real estate services for the housing and office space sectors.
Problem Statement
Real estate accounts for up to 40% of the global carbon emissions, which means that focusing on reducing these emissions can have major benefits. As a professional property management company, Retta aims to provide property owners with solutions that reduce their carbon footprint and electricity bills. Their mission is to help their customers make responsible decisions and promote the green transition through the services it provide to them. ESG report is an ideal and effective means of enabling companies to be more transparent and accountable about their current and planned sustainability initiatives. In real estate terms, ESG report validates the energy class of the building based on actual energy consumptions and CO2 emissions. One of the important tasks in ESG reporting is to calculate the energy data. Being the largest player in the industry, Retta had a huge base of energy data scattered across multiple sites and locations but there was no centralized solution where data can be collected and analysed.
How did Routa Digital helped Retta
RD team helped Retta by creating a data lake/data warehousing solution which brings together the energy data from multiple third party sources such as Metry API, Google Map API, AccuWeather API, Fingrid and CO2 Local Power APU in the agreed architecture that would enable ESG reporting in PowerBI.The major challenge in the project was to understand the data format and data structures and transform them into a state where it can be utilized
Technologies used in the solution
Azure Data Factory (ADF) for ETL solution
Azure Databrics for data processing engine
SQLServer for database
Azure Blob store for data lake
Microsoft Power BI for reporting and visualization
Results & Achievements
With this data lake solution, Retta will have access to accurate and reliable energy data that would help them to channel its efforts towards sustainable future.
The solution will help Retta with
Improved project planning and production planning
Efficient monitoring and control of the production processes
Streamlined logistics and purchase management
Improved inventory management
Dynamic takt management
Provision for disaster recovery/exception handling