BI KPIs for lawyers

BI Generator for displaying lawyer KPIs from the perspective of the employees. The config set was specially designed for law firms.

When you import this config set, the root folder Controlling and BI is created. This contains the subfolder Lawyer KPIs. This is particularly useful for law firms that work with cases. The measures provide an overview of internal/external hours, productivity, charged services as well as turnover and write-offs per employee. Furthermore, the chargeable and factually charged hourly rate per employee is shown across all cases.

To edit and access the folder, the users must be assigned to the Folder access Controlling and BI user group.

This application is an additional feature. You can find the corresponding config set here.

Application

The config set creates the subfolder in the Controlling and BI root folder, which is shown in the folder structure as follows:

Note: Lawyer KPIs are also available on the individual user or in lists of users.

The data is regularly calculated either via a scheduled task during the night or is initiated manually, if you want to see the BI measures directly.

Part one

The following BI views are grouped by employee:

  1. Client work vs. internal processes
  2. Productivity

In the first BI view, the work effort on a case is shown in hours. Essentially, the external and internal services on productive or unproductive cases (both charged and uncharged) are compared here. The BI measures External hours productive, Internal hours productive and Internal hours unproductive are available.

Other measures such as External hours charged productive and Internal hours charged productive can be added to show only the factually charged hours. These measures are not automatically shown by default.

In addition, the productivity, i.e. the recorded entered hours on productive cases compared to the total invested hours, is presented.

Part two

The following BI views are grouped by employees:

  1. Chargeability
  2. Hourly rate
  3. Turnover and write-offs

The chargeability represents the percentage ratio between the internal and external chargeable hours on productive cases. For this purpose, the chargeable and factually charged hourly rate as well as the revenues and write-offs thereof are presented.

Requirements and download

  • You need a licence for the Business Intelligence module.

Before importing the config set, we recommend you read the article Key information about the additional features. Config sets modify data in Vertec, which can overwrite existing data.

The exact import process is described in config sets.

You can download the additional feature with the following link:

Version Requirement Download
6.8.0.1 ConfigSet_BILawyerKPIs.xml

The following objects are created by importing the config set:

Folder

 Root folder Controlling and BI with the following subfolder:

  • Lawyer KPIs
User groups
  • User group Folder access Controlling and BI

The users must be assigned to the appropriate user group.

Reports & Scripts
  • Script: BiGeneratorLawyerKeyFigures
BI views

The following BI views show created:

  • Client work vs. internal processes
  • Productivity
  • Chargeability
  • Hourly rate
  • Turnover and write-offs
BI measures

The following BI measures are created:

  • External hours productive
  • Internal hours productive
  • Internal hours unproductive
  • External hours charged productive
  • Internal hours charged productive
  • External fee charged productive
Translations

A total of 16 Translations will be created.

 

Netherlands

United Kingdom