Recently I was working on a dashboard to help myself manage my consulting time. As a consultant, my key performance metric is the percent of time I spend each week billing clients. This number is called my “billability rate”.
The dashboard I created helps me track my billability rate over time and analyze outliers. However, I also needed the ability to look forward. At the end of each quarter, my billability rate is reviewed, so it would be helpful to quickly perform a scenario analysis based on my schedule to forecast that final rate.
[iframe src=”http://axisgroup.com/viz/barchart_dynamic.html” width=”100%” height=”100%”]
Based on the most recent data entered, the chart draws a bar for each remaining work week until the end of my company’s fiscal quarter. The black line on each bar can be dragged to change the forecasted amount of hours that will be billed in each week. On the far right, two text boxes update to indicate how many billable hours have been forecasted and the effect of that forecast on my final billability rate at the end of the quarter.
In this embedded example, the data is fake and has hard-coded values for the inputs; however, in the extension object the necessary data to draw this chart is received from QlikView.
While this implementation has a very specialized use-case, I have uploaded the extension object in case people want to take a look at the code or even modify it for their own purposes. Download UtilizationPlanner.qar