Using a Marimekko Chart to Show Billable Hours by Client and Project

Where did we spend our billable time last week?  Answering this question lets you know if you’re servicing too many or too few clients or if your dependent on a few large projects or are spreading yourself too thin over many smaller projects.  In our weekly professional services dashboard, I used a Marimekko chart to show billable hours by client and within each client by project.  Here’s an example:

Billable Hours by Client and Project--Marimekko Chart

It looks like our top five clients make up about 80% of the total billable hours.  These clients have one or two large projects.  This is probably a healthy mix of clients and projects.  I’d be concerned if there were many smaller clients (under 10% of total billings) or many smaller projects.  I’d also be concerned if one client made up over 40% of billable hours.  If you look at this Marimekko every week, you can develop your own rules for what is a good mix of clients and projects.

In my dashboard, I also did a similar Marimekko for the upcoming week.  You can see this Marimekko and the rest of the dashboard in the SlideShare deck below:

Tagged with: , , , ,
Posted in Charting Strategy

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Buy Mekko Graphics

We accept all major forms of credit cards. For more information or to purchase by phone please call us at 781-250-2001, or email us at sales@mekkographics.com
Single
One User
$299
Volume
4-100 Users
Starting at $249
Enterprise
101 or More Users
Starting at $149
 Features
32 Chart Types
Significant Per User Discount
Easy Multiple User Administration  
Add Licenses any time at a discount
 
Custom Branding
Custom Corporate Training
API for Producing Charts Automatically