Posted on

Project ROI Analytics with Zoho Analytics 

In our previous posts about project management analytics, we looked at how Mark, a fashion entrepreneur, could use Zoho Analytics for project overview and task analytics.

Now its time to look at how service businesses which uses a project management software like Zoho Projects can utilize Zoho Analytics to gain insights for monitoring the overall project ROI and performance.

 Consider Sophia, who runs an IT consultancy where the motto is “time is money.” Let us discuss a few key reports that will benefit someone in her position.

Billable hours analysis

For Sophia’s business, Billable hours are directly related to a project’s profitability that can thereby impact the company’s bottom line. Hence her twin objectives would be to minimise the non-billable activities and subsequently maximise the billed hours for the client work.

The following reports show the spread of billable vs non-billable hours and the overall billability percentage across projects. This helps Sophia to identify the projects that are consuming a lot of non-billable hours, and see if there’s a possibility of reining them in.

She can further view the billable – non billable hours stack by individual resources. This can help her in optimising the billable hours at the resource level. 

She can also view the overall billability trend by hours and percentage over any given time period. In this case, the last 12 months.

Now Sophia can compare the total hours billed every month against a minimum threshold required for the company’s smooth sailing. This helps her to identify months where the billable hours have fared below expectations.

She can also look into ‘the average billable hours per day’ and ‘the average billable hours by members’ for each project over its lifetime.

How significant are these reports for Sophia’s business? They can help her in better understanding of the fluctuations in overall billable hours, especially during months of steep rise or downfall.

Billable Revenue Analysis 

We had discussed earlier that “time is money” for Sophia’s business. But she can realise the money in hand only if the revenue gets accrued from the client for the hours billed. The total amount billed by different projects over the past few months, can be seen by her as shown below.

She can also view further into the revenue accrued by individual members under each project.

She can also holistically see the revenue per individual for the entire resource set.

The average billable amount by month by project is a measure of revenue potential. Sophia can maximise her total billable revenue only if she optimises the billable hours of each project according to its revenue potential.

Using both the billable revenue and billable hours analysis, she can identify both the high and low performing projects and individual resources, that could definitely help her on the future course of action.

ROI Analysis: Planning vs Actualisation

For all the plans Sophia makes to improve billable hours and revenue, its ROI (or) effectiveness can be only seen from the actual results. Any further improvement or corrective action cannot happen without analysing the planned vs actual comparison.

The following ‘Planned vs Actual’ report series shows the results in terms of billed hours and revenue along with the percentage of actualisation for both, over the last 12 months.

Sophia can see the same comparisons by months or individual resources as shown below: 

She can also see the hours and revenue actualisation trend over the past few months.

Sophia can also look into the resource utilisation (i.e) actual vs planned billed hours logged in by the workforce.

She can also see the utilisation trend as shown below. Both these reports help her in identifying and course-correcting discrepancies if any in terms of resource allocation and utilisation. 


While these are just a few examples, Zoho Analytics offers much more predefined reports for project management and performance. In addition to this, custom reports can be created for any specific requirements.

We have seen how Zoho Analytics is useful for Sophia to monitor overall project performance by billable hours and revenue accrued, and identify the scope and opportunities for improvement in terms of ROI.

Like Sophia, if you are in the services or consulting business, where projects have become increasingly agile, insights offered by Zoho Analytics can rightly serve you towards achieving your core business objectives. Set up Zoho Projects Analytics for free to explore and know us more.

Source: Zoho Blog