Business Reporting has always been one of the many soapboxes I love to jump on (http://www.accountinglibrary.com/blog/category/business-intelligence/, http://www.accountinglibrary.com/blog/category/business-alerts/, http://www.accountinglibrary.com/blog/category/exception-management/). While there is no doubt that sound business decisions are based primarily on the person making the decision, these decisions need to be based on sound information. Seat-of-the-pants decisions might work for small firms where the experience of the decision maker is the key element, but there is just too much information spread over too many decision makers for this practice to work in larger firms. In this case accurate and timely information must serve as the foundation upon which sound decisions can be based.

Why do you need this information?

Accounting and ERP systems can store and regurgitate just about anything you want. Actually it’s possible that for every transaction posted there can be 20, 30 or 40 fields that will allow you to slice and dice data any number of ways. The fact that you can carry reporting (intelligence?) to this level of detail doesn’t necessarily mean you should do it.

Start by asking yourself why you need the information. If it doesn’t lead to a decision, then you don’t need it.

In what format should this information be presented?

With the exception of audit trail reports, rows and columns are out. In no case can they lead to a decision.

Pie charts and bar chart are out as well. They, like row/column reports, are no more than a snapshot of a specific condition at a specific instant in time. People should never make snap decisions and that’s all this information can support.

Having said this, there is one use to which some specific data can be applied. Exception Management or Business Alerts are usually triggered by a specific value, but only if that condition falls outside an expected range. As an example, if a customer’s account exceeds its credit limit or a specific invoice becomes “x” days overdue, that condition should be brought to the attention of a named individual. Business Alerts handle the notification process while Exception Management gives users the ability to deal with an alert in a contact manager like application.

If rows and columns, bar charts and pie graphs are not acceptable, what’s left? Line charts are the only form of reporting that actually lets users develop a sense of the history and future of business conditions that can then give people the total picture. It really doesn’t matter where a company is today, nor does it matter where a company has been. All of that has already happened and cannot therefore be changed. What can be changed is the future and that’s where people need to concentrate their thoughts.

Think of a line chart as a beginning, a middle and an end. Historic values form the anchor upon which the line chart is constructed. The last current piece of data (the most recent value) is the jumping off point and the extension of the line formed gives us an idea as to where our future “might” be.

Once we see the total picture, we can determine if it’s heading in the right direction. Well, that’s part of the analysis, but not everything. The extended line chart gives us a hint of our future, but we still haven’t figured out if that’s where we want to be. You need a second line chart that acts as our target. Now we can see in an instant our past, one possible future and our target.

There are still two adjustments we might need to make. If the volatility of the data is significant, we may have to utilize some form of smoothing to make the data more understandable. Second, data does not follow a straight line path. Sometimes it’s increasing/decreasing over time. If that’s the case we may need to utilize some form of analysis that let’s us see these trends.

Now we can “see” the data and make a decision. If the trend seems to be within the acceptable range or budget we created, then no decision is required. If the trend seems to be heading in a negative direction, then we know we need to take action. No data analysis will ever tell us what to do, but this approach will help us determine if we need to do something and most importantly if the decisions we have taken seem to be having a positive affect.

What information needs to be extracted and displayed?

While it’s certainly easy to create graphs once the data values have been identified, the hard part is determining what you need to track. Remember, you can create any number of fields than can be used to feed your data analysis engine. Picking the right fields is the tricky part.

Think of an Income Statement. It’s got lots of data that could be graphed. Now think of virtually every accounting and ERP system’s ability to support drill down. If you can drill down from a data value to underlying information, then the information is of no use to you because it is being influenced by other data. Since you cannot track everything, you need to identify those basic factors that have the most influence on your business. Identify your Profit Drivers.

Maybe inventory turns in a distribution environment can be thought of as a Profit Driver. Don’t forget though that it’s not going to be possible to track every single item your carry. Maybe start with inventory turns as a whole, then by product line or possibly region. Where you start is not as important as your ability to quickly see where you may have a problem developing. Then you can drill down to a more detailed analysis.

Summary

Efective business decisions drive business profitability. These decisions need to be rooted in facts that can be brought to light instantaneously. People do not have the time to guess. They need to know where to place their attention. They also need to know whether the decisions they make are having the desired effect. If there is too much data, the issues may remain clouded. If there is no way to compare actual results against targets, how can you ever know if you are where you want to be or need to be. Finally, people need to identify those Profit Drivers that have the most significant impact on their organization or on their specific area of responsibility.

Forget about columns and rows. Forget about bar charts and pie charts. Adopt a proactive system that helps you track not just where you have been or where you are today, but where you could be tomorrow.

Introduction

One of the keys to increasing business profitability is giving each employee specific information they need to make sound decisions, the ability to concentrate on the areas of the business that require their immediate attention and an environment that allows them to collaborate with others to address issues that span more then their individual areas of responsibility.  Binding all of these success factors is one key concept.  If any business wants to achieve true success, they must be proactive, not reactive.  This article will discuss how people can use Business Metrics to identify critical issues before they can have a significant negative impact on the organization.

Background

Most classic business management reports are at their core no more than a picture of an organization at a specific point in time.  As such these status reports do not help people make decisions and do not effectively contribute to income and profit growth.

While this type of reporting was acceptable in the past (particularly since it was all we really had), we now have the technical ability to measure even the smallest events that drive any business.  The question is how can we build a framework for success?

Proactive Business Metrics

I cringe every time I see bar charts and pie charts as representative of what information users can extract from an ERP system and display on their “dashboard”.  While these charts certainly look pleasant (particularly when displayed in color), in the end they are nothing more than status reports and as such do not (or should not) drive business decision making.  Why? Bar charts and pie charts do not (and never will) lead to any form of decision or action.  A pie chart that displays the percentage of revenue generated by a firm’s top ten customers tells you nothing.  There is no basis for comparison to tell whether this is good or bad.  It looks pretty, but it leads to nothing.

Truly effective business metrics give you a basis for comparison that either tells you where you are going and whether you are above or below expectations. 

Let’s use Inventory Turns as an example.  Measure Inventory Turns each month and plot the values in a line graph showing the value for the past 12 months (or any time frame that is sufficiently long that a pattern can be discerned.  The user can visualize immediately where Inventory Turns has been and where it might be going.  It’s a good start, but not perfect.

Now add a system generate trend line that is calculated from the raw data.  In many cases the individual data points are so chaotic that it is difficult to see any trend, but the trend is what’s critical, not the individual value each month.  The trend line should not be a straight line, but a curve that shows whether Inventory Turns is improving or not.  A manager viewing this chart might be able to see instantly that the trend is acceptable and nothing needs to be done.  Next chart please!

Now let’s take this analysis one step further.  While the trend line in the example above may seem to indicate that Inventory Turns is acceptable, you need to add one final element.  How does Inventory Turns compare against expectations (budget)? Actually you could choose to not display the raw data as the trend line and the budget line are the two critical elements.  Now you have the complete picture: the actual trend and the budgeted trend.

This type of charting is used in the securities industry every day.  Computers track a stock’s value each day.  They also calculate a confidence interval above and below the trend line.  If the trend breaks above the upper confidence interval, a buy signal is generated.  Similarly, if the trend line breaks below the confidence interval, a sell signal is generated.  That is precisely what could be done to assist manager track inventory turns or any other defined success factor.

Business Metrics Delivery

Assuming that you have identified the Business Metrics that drive your business, how do you effectively deliver this information to named users?

1. Identify specific Business Metrics that drive an organization’s success and that lend themselves to a budget/actual comparison. 
2. Give users the ability to display any chart full-screen.
3. Give users the ability to drill down to the independent variables that drive the data displayed.  As an example, Inventory Turns is driven by sales, purchasing activities and receipts.
4. Give users the ability to view the actual data in table form.
5. Do not display information that is of no concern.  If the values in the chart are acceptable, give users the ability to either not have these charts displayed or display them at the bottom of their dashboard.
6. Give users the ability to request that a chart be included in their display list the following month.  In this example, Inventory Turns might fall within an acceptable range next month, but the user may want to “see” for themselves.
7. Utilize a red light / green light summary whereby users can view a list of their personal Business Metrics.  Actually all you would have to display is the name of the metric and a red/green light indicator.  This would be particularly useful if a person was tracking a significant number of charts.  If the information is acceptable, the green light will be displayed.  Obviously if the information is not acceptable, the red light would be displayed.  The user can then hyperlink to the metric of greatest interest.
8. Give users the ability to view the charts of those people reporting to him/her.  While we should assume that people will be attentive to their areas of responsibility, some managers might want to review the status of information tracked by people on their team.  Alternately, the system could be set up to track individual metrics as well as team metrics.

Summary

The real key to business success isn’t trend line charts.  It’s the recognition and subsequent tracking of what’s important to the business.  Before you can succeed in business, you have to understand what drives your business.  Then you concentrate on these basic or lowest common denominator success factors.  If you get them right, then your Income Statement will take care if itself.