Get your balanced scorecard here!
- By Jack Vaughan
Data warehousing vendors have
had more than modest success in recent years, bringing to market a manner of
database that is especially useful for analyzing business trends. But the data
warehouse and (closely related) OLAP industries have not yet caught fire in
quite the way that advocates hoped. What is missing is the "killer app."
The Lotus 1-2-3 spreadsheet is still the best previous example -- many desktop
PCs sneaked into the enterprise just to run 1-2-3 for a harried department manager.
That was a killer app. Will data warehousers discover a single defining application
suite that ev-eryone needs and that can be implemented without too much to do?
Some think the balanced scorecard concept, which came out of Harvard Business
School in the early '90s, fits the bill. It was formulated by professors Robert
Kaplan and David Norton, who sought to combine operational and financial measures
of an organization's effectiveness. With the balanced scorecard, a company CEO,
for example, could view the firm from several perspectives simultaneously. At
this point in our story, some of this is perhaps too familiar to organizations
that have spent a lot of money on consulting associated with one or another
well-heeled scholarly methodologies (Remember reengineering?).
At any rate, today, Kaplan is a key figure with Renaissance Solutions, a Cambridge,
Mass.-based systems integration house that has carried the balanced scorecard
banner forward and experienced leaps in revenue. It seems a natural to try and
automate this data gathering/performance monitoring methodology, and at least
one data warehouse/OLAP vendor -- Gentia Software Inc. of Wakefield, Mass. --
has formed an alliance with Renaissance and tied its star to the balanced scorecard.
Of course, there are things that look a lot like a balanced scorecard, but
do not quite fit its definition. IT shops have been keeping track of things
for years -- especially in the telecommunications business, where regulators
have consistently asked for reams of operational data. Sometimes these things
are described as key performance indicators. Other times the discipline is described
as "enterprise performance management."
The true "balanced scorecard" stipulates that you stage financial
measures (say your -- and your industry's -- ROI), plus specific operational
measures. These operational measures should include internal processes, customer
satisfaction and gauges of the organization's ability to learn. What some might
more simply call a "scorecard" could include what you want it to include;
however it would not be a true balanced scorecard by Kaplan's definition.
There are obstacles to compiling scorecards, balanced or otherwise. If your
firm does not already have, for example, mechanisms for measuring customer satisfaction
in place, setting up such measures can be the most intimidating part of the
project. Corporate politics can also be an issue. Lords of in-house fiefdoms
will want to define the scorecard so as to succeed -- always elusive, objectivity
may be the first casualty.
Again, if this seems a bit familiar, it is. A balanced scorecard report for
corporate leaders sounds like the executive information system (EIS) cockpit
much discussed in IT circles in the 1980s. What may be the case is that the
things that once stopped the EIS movement are less numerous, and the things
that enable such systems today are more available. In fact, the accession of
the Web client enables more people in organizations to access analytical info,
which is one of the precepts of the balanced scorecard.
The ultimate app
"A balanced scorecard is kind of the ultimate business intelligence application,"
said Wayne Eckerson, vice president of technology services, The Data Warehousing
Institute, Gaithersburg, Md. "It has to incorporate all the different technologies
that we've been talking about for many years -- warehousing, OLAP, distributed
networking and middleware -- to actually pull all the scores from all the individuals,
and then consolidate them."
There are a number of companies that play in that space right now, said Eckerson,
who expects the number of adherents to grow. But implementation is not without
obstacles. "The problem is that it's more of an organizational challenge
in many respects to prepare a company to access
itself using these kinds of measurements and tools," he said. "It's
a big endeavor, and you have to be committed to it."
Few vendors have promoted this "ultimate app" as has Gentia. Last
August, the company took a big step toward a mass-
deployed balanced scorecard when it released a Web-enabled version of the "Renaissance
Balanced Scorecard." Together with Renaissance, Gentia last year spearheaded
the formation of a Balanced Scorecard Council.
There are at least three levels to ascend in the quest for the true balanced
scorecard, said Michel Gaiss, vice president of corporate marketing for Gentia.
It is worthwhile to outline these steps: Depending on the available budget or
the extent of management support, IT might want to bail out of a scorecard project
before reaching the ultimate level. Gaiss points to three distinct steps:
PERFORMANCE MEASUREMENT, in which you set up report
PERFORMANCE MANAGEMENT, in which you add accountability
to reporting; and
STRATEGIC MANAGEMENT, in which you add control
to accountability and reporting.
Gentia was formerly known as Planning Sciences during a long pre-history in
an-alytical software markets. The firm, said Gaiss, defines its overall business
as "enterprise performance management," which he further defines as
a means to help an organization perform the "measurement, control and communication
of its objectives, initiatives and progress toward success."
At least one Gentia user said the decision to go with Gentia's software was
a "top-down" decision and involved Renaissance consultants. This according
to Debbie Smith, director, business development, at Bell Emergis in Ottawa.
The spin-off of a telecom giant (Bell Canada), Bell Emergis was familiar with
the thousands of measures that a telecommunications company can fall captive
to. Because of this, Bell Emergis explicitly decided not to try and measure
too many things on its balanced scorecard, said Smith.
"A telephone company has thousands of measures in place operationally,"
she said. "The natural inclination might be to say 'We'll stick them on
a balanced scorecard.'" Large organizations embarking on a balanced scorecard,
she noted, have to work to winnow down a long list of measures.
Smith said Bell Emergis became a lead customer in defining the Web-enabled
version of the Gentia Balanced Scorecard software. "The software worked,"
The challenges of the balanced scorecard are mainly organizational challenges.
"It requires overhead work or back-office type work," Smith said.
Individuals have to set up and continually refresh the pertinent data.
Another vendor positioned as a balanced scorecard proponent is CorVu Corp.,
Eden Prairie, Minn. CorVu recently forged a deal with Atlanta-based Armstrong
Laing to provide a combined Balanced Scorecard/Activity-Based Costing system
solution. Taken together, the products can provide a framework for setting strategic
goals and a means to measure progress toward objectives, said Liz Shahnam, program
director at the St. Louis offices of the Meta Group.
The deal is a further indication of the ongoing melding of business process
theory and software technology. Moreover, said Alan Missroon, CorVu vice president
of marketing, the alliance may provide the first coupling of two business methodologies
proposed by business expert Robert Kaplan. Balanced scorecarding is melded here
with a methodology that supports Kaplan's theories on activity costing, said
CorVu's Missroon. While CorVu products provide the scorecard support, Armstrong
Laing's Metify ABM application converts general ledger and other data into business
process and activity costs for determining target costing strategies. CorVu
and Armstrong Laing, said Missroon, hope this product pairing will help customers
automate the balanced scorecard approach in order to track and improve customer
and channel profitability.
Other voices, other vendors
It may be too early to tell, but prominent data warehouse vendors can probably
be expected to re-tailor their established tools as dedicated scorecard, if
not balanced scorecard, offerings. Many are ready to discuss aspects of enterprise
performance analysis. Include among these SAS, Seagate, Information Builders
Inc. and others.
"It certainly is one of the hot spots in the marketplace today, whether
you're talking about key performance indicators or the balanced scorecard,"
said Donald MacCormick, London-based director of Seagate's Holos product line.
What is new? "EIS tended to be hand-fed. But today's balanced scorecard
can drill all the way down into the underlying data. If you see a blip, you
can dig down [into the background data]," he said.
No, it is not so new, said Mark Moorman, program manager for business intelligence
at SAS Institute Inc., Cary, N.C. "We've been a KPI [key performance indicator]
company for years. We have historically had tools for financial consolidation,
customer relationship management, human resources and data warehouse quality
[assurance]." Users can form a useful version of a scorecard from this,
"The potential of the balanced scorecard is that it moves you from an
anecdotal company to a performance management-driven company. The difference
between traditional OLAP and balanced scorecard is the difference between doing
things right and doing the right things," said Moorman.
"People go out of business every day 'doing things right,' but not doing
the right things right," Moorman remarked. Thus, he infers, the scorecard
can bring more sense to the enterprise.
For its part, Information Builders Inc. (IBI), New York City, does not position
its InfoCube product as a balanced scorecard. But, in describing it as an application
template for managers who analyze sales and marketing performance, IBI reps
suggest InfoCube may be simpler to launch and more broadly useful. It is also
"InfoCube is an analytical application template for use with any industry,"
said Kevin Quinn, IBI director of sales for enterprise reporting. "It does
its work with the assumption that you have [already gathered] this data,"
InfoCube is targeted toward financial issues, and follows a 'Rule of 8' schema,
assuming that there are eight kinds of dimensions typically measured in sales
and financial data analysis. One of the dimensions InfoCube uncovers for analysis
is based on a rule of its own. It is the "Pareto" tool, which culls
data for signs of the 80:20 rule. With it, you may unearth, for example, that
your top 20 customers account for 80% of your business, and, horrors, that 15
of those customers cut back on their business with your organization during
the last quarter. This analytical module takes its name from Wilfredo Pareto,
the late Italian economist who devised the law of the "trivial many and
the critical few" to explain common financial truths.
In one era
Having died in 1923, Wilfredo Pareto clearly missed out on the golden era of
high-ticket consulting engagements. In any case, it is the high odds that consultants
will be required that will tend to influence the application development manager's
"yeah or nay decision" on the balanced scorecard. It is not safe to
assume that there will not be business consulting required with the balanced
scorecard. Organizations already prone to engage consultants will be more willing
to take on such projects.
If the systems they create help companies grow revenue, the balanced scorecard
will become commonplace as chief executives grow to depend on these interactive
meters of corporate performance.
The goal is eternal -- to turn strategy into tactics via effective feedback.
Such systems will be considered because missing infrastructure elements that
inhibited EIS in the '80s have become more available. These links include data
warehouses based on relational technology, as well as networks and user interfaces
based on TCP/IP and HTTP.
Bell Emergis chimes in the decision to go with software from Wakefield, Mass.-based Gentia Software
Inc. at a Canadian telecommunications company was a "top-down" decision
and involved Renaissance consultants, said Debbie Smith, director, business
development at Bell Emergis' offices in Ottawa. Smith was a business planner
and process development specialist at Bell Canada prior to joining Bell Emergis,
which was spun-off from its parent firm more than a year ago. Bell Emergis'
goal is to develop innovative intelligent network applications.
"As a new organization, the leader knew we needed some kind of management
discipline," said Smith. "He [James Tobin, executive vice president
of Bell Canada, as well as president of Bell Emergis] saw balanced scorecard
as a world-class process.
"We started work using the process that Renaissance [Solutions, a Cambridge,
Mass.-based systems integration house] used, and it starts with interviewing
the leadership. All of the business unit leaders contributed by identifying
what they felt the whole strategy was," Smith said. She and two consultants
pulled together this information in just six weeks, preparing what she called
a straw model that was placed in front of a team of leaders in a workshop.
"We then went away and worked with folks in the organization to determine
what appropriate measures would be needed to ensure we were on track to meet
strategic objectives," she said. "We kicked that around a lot and
there was a fair bit of discussion. This was healthy because we weren't trying
to measure things that a telephone company traditionally measures.
"We came away with a long list of measures," said Smith. The next
challenge was to shrink it down to a list that was manageable.
Smith looked at other products. "This whole area is still in its infancy,
so nothing was extremely mature and nothing had a long list of users,"
she said. "The Gentia product was out in front quite noticeably in terms
of how it adhered to the spirit and philosophy of the balanced scorecard methodology."
The main technical requirements from Smith's perspective were that the eventual
system be server-based and Web-enabled.
The challenges of the balanced scorecard are mainly organizational ones that
the balanced scorecard brings to the fore. "The biggest challenge was in
the behavioral [realm]," said Smith. "We were trying to achieve things
in the future that were hard to measure. And somebody had to step up to the
"It is essential to enlist opinion makers in the organization in order
to ensure that peoples' time is freed up for the effort," she added.
Challenges are process-related as opposed to system-related, she noted.
Smith sees the balanced scorecard as a competitive advantage, and so she describes
hers in general terms. "You want to look at cash flow and revenue trending,
that sort of thing. We have some customer satisfaction measures, too,"