Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.

Gallery

Contacts

Routa Digital Finland Keilaniementie 1, 02150 Espoo

contactus@routadigital.com

+358 40 870 5898

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