Opertaions & Asset Management Dashboard

Sep 4, 2023

Using Legacy System Generated Files to Build a Power BI Dashboard and Data Store

Te Whatu Ora is New Zealand’s health authority overseeing the country’s healthcare system. It leads the day-to-day running of health systems across the country.

Partnering with the facilities management team, we provided technical resources to develop Power BI dashboards, data engineering, training, and consulting services around reporting via legacy systems.

Solution

Our initial goal while developing the solution was to reduce the manual effort required to generate insights via legacy on-premise systems the team were using. Post achieving the milestone we developed Power BI dashboards to generate management insights on KPI achievement, Operational risks and asset management.

Finally, we provided support, maintenance and handover back to the internal analyst resources to manage the day-to-day running of the dashboard.

Outcomes

  • Partnering with the team to develop Operations Power BI Dashboard to better manage the day-to-day maintenance of NZ’s health care assets

  • Automated data flows to reduce manual effort required in manipulating data

  • Provided training and handover the internal analysts