Excel Dashboard Templates

Learn how to create Excel dashboards.

Monday, April 9, 2007

Law Firm KPIs & Metrics on an Executive Dashboard

This series of excellent executive dashboards focuses on law practice management via monitoring financial and client KPIs. They are the output of a hardworking executive dashboard guru at the law firm of Bryan Cave. Based on Redwood Analytics, these dashboard screenshots show exactly what gets a lawyer's juices going. Take a look at these metrics. This first dashboard screenshot starts off with a listing of clients and their attributes (fees collected, fees billed, collection contribution, billing contribution, effective rate, collection realization).

Click on the images below to open them fully to see all the details of each executive dashboard.





Upon drilling down into a client's details, we see financial metrics such as speed of collection, accounts receivables, and most interesting, how such KPIs for this client compare to firmwide metrics:


Gauges allow for a visual depiction of the financial metrics on this executive dashboard:





Finally, we get to see the planning module where each lawyer can plan out how much each engagement can contribute to their numbers.





Tag: Executive Dashboard