Forecast Analysis – An Effective Dashboard

FORECAST ANALYSIS

Last week I argued that a detailed variance report is not very helpful before and during the forecasting and budgeting process. That post continues to be one of the most popular ones recently. But why not take the basic ideas a few steps forward and create a dedicated forecasting dashboard? A dashboard allows us to view the critical information that we need to get our job done (i.e. create the forecast or the budget) in a single place. Conducting forecast analysis with this dashboard becomes easy and is less time-consuming than analyzing hundreds of variances in a spreadsheet.

A COGNOS 10 DASHBOARD

My colleague Paul took the ideas from the last post and he created an awesome forecasting dashboard in Cognos 10. Take a look (click on the image to enlarge):

forecast analysis
Forecast Analysis with IBM Cognos 10 - Business Insight

This forecasting dashboard is geared towards a revenue forecast. The widget in the upper left corner provides a quick overview of year-to-date product sales. You might notice the use of micro-charts: the sparklines display the sales trend for each region. The accompanying bullet charts show the current status against plan (YTD).

The other widgets provide a balanced mix of historical data (revenue, deal-size, expense ratio) and leading indicators (Win/ Loss Ratio, Customer Satisfaction). But there is also other important forward-looking information. Take a look at the lower left corner: We can view upcoming marketing events along with the anticipated number of participants and the expected sales pipeline. That is helpful for assessing future sales.

EFFECTIVE FORECAST ANALYSIS

This forecasting dashboard can help prepare for the actual forecasting process. It provides a better picture of the business than any detailed variance report can. And think about the time savings as well. The latter requires a lot of effort to be consumed. The dashboard on the other hand is efficient and effective. Last but not least, the dashboard can be utilized on a daily basis.

So, that is a forecasting dashboard built with Cognos 10. I love the look and feel. It is simple, clean and easy to interact with.

 P.S.: The type of information to be included in such a dashboard obviously varies by company and industry.