We have created a partnership with Amber Green which allows us to complement our usual housing system consultancy services with their expertise

Automation of KPI calculation enables you to speed up production of all organisational KPIs giving you accurate up-to-date information and significant resource savings over existing methods.

KPI Generator2

Click image for more details and examples

The generator retains KPIs and their constituent elements for all previous periods and allows simple presentation of headline KPIs plus analysis – drilling, slicing and dicing – by any required dimensions. Because the underlying elements are also stored, the factors determining changes in performance are easily identifiable using tools such as PowerBI or Business Objects.

KPI Generator

Click the Image for more examples


  • Fully automated according to your required schedule
  • Eliminates re-keying from reports into performance system
  • Ensures consistent KPI calculation method
  • Saves management and performance team time
  • Enables users to interactively direct analysis


  • KPIs can be set for daily, weekly, monthly, quarterly or annual periods
  • KPIs can be based on a single period, year to date or rolling annual period
  • Each KPI has a target, based on either a single period or annual profile
  • When KPIs are generated, both variance from the target and percentage variance from the target are also calculated and stored
  • Optional weighted profiles to reflect known seasonal variations (eg Xmas, winter etc) can be used to inflate or deflate targets
  • Headline KPIs are stored in a single table for easy access
  • Dimensionally modelled tables and views for each KPI provide the ability to analyse data as required

Click here to send us a message or call 0203 697 1201