Data warehouse for recording carbon footprint measurements

Project Description

In the project assignment, the task was to create a unified data warehouse for the recording of carbon footprint measurements, which is provided a leading English business, the Zero Carbon Company. Additionally, we have developed a web application for climate action planning and carbon footprint reduction.

1

web application

1

data warehouse running on Keboola

90%

reduction of manual work

3 yrs

cooperation

The Zero Carbon Company collects data from gas and electricity consumption meters from pub, resturant & hotels locations across multiple of the UK hospitality sectors largest brands.  Zero Carbon Company is the industry’s leading provider of Carbon analytics, offering solutions to help businesses outperform carbon reduction targets and increase profits. The acquired data is analyzed to reveal developments and trends, typically 1-2 times a day.

Our goal was to create a unified data warehouse for measurement outputs as well as information regarding the ecological footprint of companies (e.g., from production, business operations, travel of managers, etc.). Simultaneously, we developed an application for the automated generation of comprehensive recommendations for reducing the carbon footprint of businesses.



Applied Technologies
Industry Solutions
Solutions

“Collaborating with Zero Carbon Company has been a new experience for intecs, allowing us to fully leverage our capabilities within Keboola. Additionally, we were able to assist in creating reports on Thoughtspot, a platform we don’t usually work with. Furthermore, the entire project has provided valuable experience for our application team that developed the web-based climate action plan generator on Azure.”

~ Jan Richter, Senior BI Consulatnt

Satisfied Client

intecs have been instrumental in transforming our Carbon Analytics platofrm offering to the UK hospitality sector, helping to deliver significant cost & carbon savings for our clients.  Their expertise in Keboola is unparalleled and their openness to learning and adapting to using new technologies to them such as the Thoughtspot Analytics platform has made them a pleasure to work with.

intecs have also worked with us on addiditional inciatives such as developing tools to automate the creation of Climate Action Plans for our clients.  These Climate Action Plans used to take days to manually generate and now can be done in a matter of hours.  We couldn’t be happier with the services provided by Intecs over the last 2.5-3 years and look forward to collabarating with them for many more years to come.

David Street

Data & Analytics Director, Zero Carbon Company