We are creative, ambitious, and ready for challenges!
Connect with Us
Using Data & Analytics to empower Retta in its sustainable efforts
Published:
October 3, 2023
Category:
Product Engineering
Client:
Retta
Overview
Retta is the largest professional service group in the Nordics specializing in the brokerage and management of apartments, properties, and offices.
Real estate accounts for up to 40% of the global carbon emissions. As a professional property management company, Retta aims to provide property owners with solutions that reduce their carbon footprint and electricity bills. Its mission is to help its customers make responsible decisions and promote the green transition through the services it provides 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, the ESG report validates the energy class of the building based on actual energy consumption and CO2 emissions.
Starting Point
One of the important tasks in ESG reporting is to calculate the energy data which can then be used to assess the environmental impact of the building, inform stakeholders about its sustainability performance, and guide future improvement strategies.
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 could be collected and analyzed.
Routa Digital team helped Retta by creating a data lake/data warehousing solution that 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 various formats and structures of data and then transform them into a state where they can be utilized.
After evaluating various platforms and tools, we decided to use Azure Data Factory (ADF) for ETL solution, Azure Databrics for data processing engine, SQLServer for database, Azure Blob store for data lake and Microsoft Power BI for reporting and visualization.
A Valuable Impact
The project was a success and delivered as planned. With the implementation of this data lake solution, Retta now has access to accurate and reliable energy data that would help them channel their efforts toward a sustainable future. Our comprehensive solution encompasses a spectrum of functionalities, including processing energy data on an hourly, daily, monthly, and rolling 12-month basis, as well as handling weather data processing, CO2 emission calculations, and facilitating ESG reporting. By leveraging these capabilities, Retta can streamline its energy management processes and enhance its ability to make informed decisions for long-term sustainability.
Feedback:
‘At Retta, our mission is to make the real-estate sector more sustainable, more profitable, and more responsible. We are happy that we found a partner who values these sentiments as well. Our journey with Routa Digital feels rather like a problem-solving and value-creation exercise, than an “IT project”, and is colored by a business-first attitude and results-based approach. The team was flexible, efficient, and easy to work with-– Lauri Leino, SVP, New Services & ICT || Chief Strategy / Acceleration / Development / Information Officer