TB+A: Power BI & Automated Air Quality Data Integration

Overview

Troup Bywaters + Anders (TB+A) is a high performing engineering partnership delivering high quality building services consultancy across the UK and Europe from eight offices. Their purpose is to be a socially responsible and ethical partnership.

As a carbon neutral business their operations are aligned with the UN Sustainable Development Goals.

TB+A bring a full service approach to their clients, providing advice and support with the design, planning, construction, operation and ongoing management of their property and assets. Underpinned by an exemplary Integrated Management System achieving quality and consistency.

Problems

01 Access to Air Quality Data

In keeping with their values, ethos and operational high standards around sustainability and working environment, TB+A implemented a network of Air Quality sensors across their 8 offices. Due to the data only being available via the hardware supplier portal, it was not easily accessed and actively being used by the staff as had been intended.

02 Data Reporting

TB+A required a mechanism for reporting to internal and external stakeholders that was easy-to-use and could integrate between systems, easily.

Objective

01
To create an automation that would enable staff to have up-to-date and easy access to this important data.

Solutions

Simoda created an intelligent automation in Power Automate that:

+ Required no operational or staff time

+ Could regularly access the client portal via an available API and create a Power BI report to visualise the data

+ Was made available on the front page of the companies SharePoint based intranet

+ Provided a reporting mechanism for internal and external stakeholders

Testimonials

"Simoda created a fully automated solution with Power BI to enable information to flow smoothly from a disconnected external source into our systems which is accessible to all internally."

Chris Hinton

Head of IT