15 Mar 2020 - Exec dashboard v1

Executive dashboard added, with revenue target and utilization metrics. Project budget and settings pages updated.

Included in this release

  • The first version of an Executive Dashboard (revenue & utilization)
  • Improvements to the project budget screen, updated calculations and a list view of the budget breakdown
  • Some refinements to the project settings screen
  • The All leave screen can now be grouped and sorted
  • There have been no updates to the API and SQL Views

If you have any feedback or questions please let us know - send an email to support@projectworks.io and one of the team will get back to you pronto.

Executive dashboard - v1

One of the things we've been talking about for awhile is to start surfacing some of the important business metrics that Projectworks can track. In this release we have started this with a first version of an Executive Dashboard, beginning with revenue targets and utilisation tracking. There are a lot of other metrics that we will add to the Exec Dashboard throughout the year, as well as working on dashboards targeted at other levels of organisations.

The first version of the dashboard sees widgets for revenue targets and utilisation tracking. The numbers are presented for the previous month, current month and next month. Each widget needs to be configured separately to show the results for the relevant office and or budget.

Executive Dashboard - revenue and utilization

Revenue targets

The revenue targets widget presents the financial forecasts compared to the selected budget. You will need to create revenue budgets in the admin section to monitor revenue forecasts against budgets. 

Utilisation tracking

Up until now all utilisation reporting was historic, based on timesheet entries. The dashboards allows you to see a forward view of utilisation based on resourcing on billable projects. Util for the previous month is based on timesheets, the current month on a mix of timesheet entries and remaining resourcing while the next month is solely based on resourcing. A report showing a 12 month view of resourcing will be coming in the future. Note: The utilisation metric is based on billable people for the selected office, working on billable projects for any office. 

Project budget updates

The purpose of the budget screen is to make it easy to see that state of the budget for your. We've made a couple of adjustments to the calculations, revised some of the language and added a new "at completion" comparison of projected revenue vs the budget. 

Project Budget Updates

Project settings updates

A number of visual refinements have been made to help with reading a screen with a lot of information: These include:

  • New toggle for switching budgets from active/inactive. It's more visual so its easier to distinguish between them
  • Inactive budgets can be hidden 
Project Settings Updated

API and SQL views

There have been no changes made to the API and SQL views in this release.