An analytics scorecard is one of the best ways business leaders can use data to measure business performance, predict future outcomes, and identify revenue growth and cost savings opportunities. It’s effective because it’s numbers driven, fact-based, and uses a straightforward format that makes the information easy to consume and digest. When defined well, it creates actionable insight.
What a scorecard isA scorecard is an analytical instrument containing a handful of important KPI’s, which are metrics aggregated from data the business has sourced from its internal systems, or data it can acquire from outside the company. The format for scorecards varies from industry to industry, business to business, and even from department to department, depending on who the scorecard user is and how they will use it. A C-level executive will require a set of KPI’s that covers all business lines of the company across operating regions/countries within his or her purview. A department lead, like a retail buyer for example, will require a different set of KPI’s, such as those on a vendor scorecard, that enable the buyer to evaluate vendors and negotiate favorable buying terms.
KPI’s to includeIn my experience, there are two main types of indicators to use in a scorecard: 1) lagging indicators, and 2) leading indicators.
Lagging IndicatorsLagging indicators are the top level metrics that provide the initial view of what’s happening in the business. A lagging indicator measures numerical output of business activities. The most common lagging indicators are sales, cost, or profit — measured in units, whole currency, or as a percentage to total. A lagging indicator could also be a count, average, minimum, or maximum, based on factual data. This is not a definitive list, there are others, depending on the business.
Leading IndicatorsWhile lagging metrics measure output, leading indicators are aggregations of activities that drive the lagging metric. A lagging metric has one or more metrics that lead into it. For retailers for example, a lagging metric is sales, and some of the leading metrics that drive it are customer or transaction count, average basket size, and basket assortment.
Deeper dive analysis and actionable insightsAny of the above leading indicators can drive revenue, and the scorecard should support a deeper dive analysis, so that the user can drill down and identify opportunities or estimate root cause of a problem, and take action where necessary. Last week I spoke with Teresa Curtis, retail expert, and former Senior Manager for Gap, Inc, to talk about how she uses data in retail. Her response: “I would look at the numbers to tell a story of what happened in the past, and then use that analysis to modify the story for the future.” Here’s a great example of exactly this, from the chain restaurant industry. Using sales data on a scorecard, we can drill down to analyze guest preferences and habits. Through analysis, we can identify that in some regions, Sunday family brunch is more popular than in other regions. We can also identify where business lunches occur with greater or less frequency than in other regions. Analytical findings:
- In the locations where family brunch is more popular, we can drive sales by advertising with features like a kids menu, holidays celebrations, or special birthday events.
- In the locations where there is low cover count during business lunch, we can reduce staff or close during lunch hours.
- In the locations where there is high cover count during business lunch, we can entice guests with offerings to come in for dinner or visit on the weekend, to extend the momentum of the weekday business lunch.
- Lagging indicators: Sales by restaurant, region
- Leading indicators: Customer count by service type, time of day, day of week
- Analysis: Identify target sales growth or cost reduction opportunities by restaurant, region
- Actions: Targeted advertising based on sales growth opportunities; staff and/or operating hours reduction
- Outcome: Increased sales in target growth areas, reduced operating costs