Business Intelligence Comes of Age for Companies of All Sizes

November 24, 2009

By Bob Stein

Professional, reliable and easy to use Business Intelligence (BI) is essential to maintaining an edge and meeting financial performance objectives in the increasingly competitive convenience store retailing industry. The amount of change in the economy today, which can affect consumer confidence and behavior on an immediate basis, requires agile responses based on insights provided from valuable business data. Volatility in fuel prices, the stock market, retailer sales results and rising unemployment all make it necessary to be knowledgeable and dynamic in making decisions and changes in the business. To do so requires good data that is well organized and provides actionable insights: this is what Business Intelligence tools can do for retailers.

Characteristics of robust BI tools include the ability to efficiently compile data and report key performance indicators in an easy-to-understand visual/graphic “dashboard” that provides visual context of a company’s performance. For small and large retailers alike, BI offers an array of benefits that can improve a business owner’s decision making and increase profitability.

The “dashboard” interface of today’s BI solutions start with a daily snapshot of a convenience store operator’s business, placing data at its fingertips and allowing it to drill down from the dashboard to retrieve more details. Users can instantly compare today’s information against either budget or performance from previous months, quarters or years. Thus, the system gives store operators the tools needed to efficiently react to changing market conditions and make quick, competitive business decisions.

Users no longer have to spend countless hours sifting through multiple reports and data, because the BI software pulls all the available data as needed and consolidates information from various sources in different places, to immediately provide details about the business. BI quickly delivers information that in the past may have taken hours or even days to track down and compile.

The best business intelligence solutions identify both problems and opportunities for a convenience store business. BI can help retailers decide where to devote their resources and what operational trends they can exploit. The information helps users quickly respond to problem areas and improve store performance. Most importantly, the BI solution empowers convenience store operators to make decisions that can help affect their business in the most positive way, and ultimately gives them the data needed to gain a competitive advantage. The advent of Software-as-a-Service (SaaS) solutions means that even the smallest companies can obtain complete BI functionality and benefits.

Fortunately, even for small chains and single-store operators, access to quality BI is not out of reach. Traditionally, organizations had to either build or buy expensive systems to obtain BI power and knowledge. Today, Business Intelligence is no longer about massive, complex databases that require large staffs and larger IT budgets to maintain. Many tools can operate on small servers and interface with existing data warehouses to create decision support tools. This is inexpensive and fast.

With the SaaS model, the BI software and corresponding data are hosted by a technology vendor. Users, from independent retailers to large chains, pay a monthly subscription fee to access the power of BI — essentially renting the software and only paying for what they use.

Because users share the technology, vendor’s software and staff, this reduces upfront investments on servers and infrastructure, and eliminates the need for an IT staff to maintain and update the database. This does not mean, however, that a company’s information can be easily accessed and compromised. Advanced security features ensure complete confidentiality with this hosted model. The result is a BI solution — available today — that is faster, simpler, visually appealing, intuitive and best of all, more affordable than traditional solutions.

Hosted SaaS models not only benefit small retailers who lack the IT staff and resources to build, buy and support intricate BI software systems, but large organizations can also benefit by morphing their very complicated and involved systems into a much more simplified solution. The SaaS solutions available today make integrating BI into an organization very easy, regardless of size or budget.

With business more volatile and competitive than ever, BI is no longer a “nice to have,” it is now a necessary tool that enables retailers to stay at the forefront of their business by giving them access to the business data they need to make timely decisions and remain competitive. BI is a trend that is rapidly growing, and businesses today that don’t make use of it will be at an extreme disadvantage in a very short time.

The innovative, affordable BI tools available today are becoming more ubiquitous throughout the convenience store industry. These solutions are helping retailers of all sizes better understand their business and make optimal decisions that will ensure business success in the future and keep the convenience store industry healthy and prosperous.


At a Software Powerhouse, the Good Life Is Under Siege

November 23, 2009

By STEVE LOHR

A TOUR of its carefully tended, 300-acre corporate campus here leaves little doubt why surveys, year after year, rate the SAS Institute, the world’s largest private software company, among the best places to work.

There is the subsidized day care and preschool. There are the four company doctors and the dozen nurses who provide free primary care. The recreational amenities include basketball and racquetball courts, a swimming pool, exercise rooms and 40 miles of running and biking trails. There is a meditation garden, as well as on-site haircuts, manicures, and jewelry repair. Employees are encouraged to work 35-hour weeks.

Academics have studied the company’s benefit-enhanced corporate culture as a model for nurturing creativity and loyalty among engineers and other workers. Six years ago, in a report on “60 Minutes,” Morley Safer called working at SAS “the good life.”

But that good life is under threat today as never before. SAS’s specialty, a lucrative niche called business intelligence software, is becoming mainstream. Free, open-source alternatives to some of the company’s products are increasingly popular. On the other end of the spectrum, the heavyweights of the software industry — Oracle, SAP, Microsoft and, especially, I.B.M. — are plunging in and investing billions of dollars.

“It will be a dogfight,” says Bill Hostmann, an analyst at Gartner. “SAS has never faced a competitor like I.B.M. And I do think I.B.M. sees SAS as a big, fatted cow.”

The term “business intelligence software” applies to a wide range of products and services, but all the technology is aimed at helping businesses mine nuggets of insight from mountains of data. SAS has traditionally specialized in advanced software to analyze huge data sets and to generate predictive statistical models for large corporations and government agencies.

Credit card companies, for example, use SAS to detect unusual buying patterns in real time, and to spot potentially fraudulent charges. Giant retail chains use SAS to tailor pricing and product offerings down to the store level. Telecommunications companies use SAS to identify the few thousand customers, among millions, most likely to switch to another cellphone carrier, and to aim marketing at them. SAS software is also used to parse sensor signals from North Sea oil rigs, combined with weather and structural data, to predict failure of parts before it happens. Of the 100 largest companies worldwide, 92 use SAS software.

But as the stream of companies’ collected data turns into a torrent, SAS and other software companies are trying to find new ways to harness it. The information is generated not only by computerized systems for tracking operations, customers and sales. It also comes from new data sources like Web site visits, social network chatter and public records accessible over the Internet, as well as genome sequences, sensor signals and surveillance tapes, all in digital form.

This data explosion, experts say, is an untapped asset at most companies, which lack the tools and skills to exploit it. Yet the long-range potential, they say, is to use this data for far more fine-grained analysis of markets, customer behavior and operations, making business more of a science and less a seat-of-the-pants art.

“Now, the data is available so business can move toward evidence-based decision-making,” says Erik Brynjolfsson, an economist and director of the Center for Digital Business at the Massachusetts Institute of Technology. “This market is a huge opportunity.”

That opportunity is not lost on SAS. “Our advantage is the incredible depth of our technology, developed over years and applied to specific industries,” says James H. Goodnight, the chief executive and a co-founder of SAS. “No one can match our toolbox.”

Indeed, no one underestimates SAS’s technical prowess. The big question is whether the company’s seemingly pampered culture can embrace the higher-octane institutional metabolism that it will need to succeed.

“We know we have to change — no question about it,” says Jim Davis, 51, a senior vice president at SAS. “Our market space has changed dramatically in the last 18 months or so, more than at any time over the 33-year history of the company. We can’t sit back. Things are only going to get faster.”

THE company traces its roots to a time when computing was costly and for the few. Originally called Statistical Analysis System, it was founded in 1976 by Mr. Goodnight and three colleagues from the agricultural statistics department at North Carolina State University. Its techniques were initially used to calculate the intricacies of soil, weather, seed varieties and other factors to improve crop yields.

To build an audience, Mr. Goodnight spent nights packing up boxes of computer tapes and manuals, which he sent to university and corporate researchers. Soon, companies wanted him and his academic colleagues to develop software tools tailored for industry. In 1976 at a users’ conference, 300 or so people showed up, many from business.

“That was pretty much an ‘aha’ moment for us, that it was time to expand beyond the university,” Mr. Goodnight recalls. “It was a little scary, cutting the academic umbilical cord. But I was convinced we could do it.”

He and his colleagues at SAS developed their own programming language and software tools, and designed them for eggheads like themselves. Users were analysts with Ph.D.’s, working with programmers and employed by the largest companies at the forefront of using computing in their businesses, including banks, national retailers, insurers and drug companies.

SAS invested heavily in research and development, and even today allocates 22 percent of the company’s revenue to research. The formula has paid off in steady growth, year after year. Revenue reached $2.26 billion in 2008, up from $1.34 billion five years earlier.

Yet the company also faces the classic challenge of being the innovative pioneer — enjoying rich profit margins but facing new competition from rivals seeking to gain market share with lower prices and substitute technology.

In the last two years, the major software companies have scooped up companies in the business intelligence market. Among the larger moves, SAP bought Business Objects for $6.8 billion, I.B.M. bought Cognos for $4.9 billion and Oracle picked up Hyperion for $3.3 billion.

Still, those companies compete in the broad swath of the business intelligence market for reporting and analysis products. Such data on sales, shipments, customers and operations amount to a numbers-laden portrait of the recent past. The SAS stronghold is a more sophisticated kind of software typically called “advanced analytics and predictive modeling,” which uses historical and current data to try to peer into the future and model likely outcomes.

The competitive thrust that really grabbed SAS’s attention came in late July, when I.B.M. announced that it planned to pay $1.2 billion for SPSS, a maker of predictive modeling software. I.B.M. has placed SPSS and Cognos into a new business analytics and optimization group. That business will be supported by 200 scientists, and the company has said it will retrain or hire 4,000 consultants and analysts to work in the group.

“This is the big growth strategy for I.B.M., the company’s next big play for this decade,” says Ambuj Goyal, a computer scientist who is general manager of I.B.M’s business analytics software unit. “SAS comes from the legacy world of statisticians and programmers. The real opportunity is in deploying this technology broadly in corporations.”

To counter I.B.M. and others, SAS is looking to forge a tighter relationship with a big technology services company. It is also shortening product development cycles to 12 to 18 months, down from 24 to 36. “That’s what the market expects,” Mr. Davis says.

The most sweeping change is the company’s move toward the Internet model of software delivery — as a service that customers tap into over the Web, much as Google and other Internet companies do. SAS has dipped its toe in, with some initial products. But a major expansion is planned, supported by a sprawling $70 million data center scheduled to begin operating next year.

The remotely delivered software is part of a drive to broaden the market for SAS technology beyond an elite corps of quantitative analysts and into the rank-and-file of corporate professionals.

Analysts say the company’s strategy looks sound, even if the outcome is uncertain. “SAS has to do a lot of things right to succeed,” says Peter Sondergaard, senior vice president of research for Gartner. “But if it executes correctly, it could be a winner.”

ACROSS its campus here, there are signs that the SAS culture is evolving with the times. Rick Langston, 54, a senior software manager who joined the company 29 years ago, smiles and shrugs when asked about the 35-hour workweek. After leaving the office, Mr. Langston routinely checks on work e-mail at home.

These days, he explains, SAS is a global company with far-flung project teams, and overnight e-mails can resolve problems and speed things along. Deadline work to meet product development schedules, he adds, can mean long hours at times. “But this is certainly not a place where you are working 60-hour weeks, week in and week out,” he said.

To be sure, the corporate cocoon in Cary can breed insularity. SAS, for example, was slow to recognize the brewing challenge from free, open-source alternatives to some of its products. A free programming language and set of software tools for statistical computing, called R, has become increasingly popular at universities and labs.

The company shifted course earlier this year and modified its software so programs written with R work seamlessly with SAS technology. “Shame on us for not engaging more with the open-source community,” says Keith Collins, senior vice president and chief technology officer. “But we’re committed to doing that now.”

THE architect of the SAS culture is Mr. Goodnight, a lanky, laconic billionaire. The benefits have built up gradually over the years as a series of pragmatic steps, he says. The day-care program began after a valued employee was about to leave to take care of her young child. The on-site medical checkups grow out of the belief that “good health is good business,” he says.

Today, SAS estimates that its health care center saves the company $5 million a year, by providing care more cheaply than an outside insurer and by not having employees leave the campus for doctor’s visits. Employee turnover at SAS averages 4 percent a year, versus about 20 percent for the overall software industry.

The office atmosphere is sedate. There are no dogs roaming the halls, no Nerf-ball fights, no one jumping on trampolines — no whiff of Silicon Valley. The SAS culture is engineered for its own logic: to reduce distractions and stress, and thus foster creativity.

“The SAS model is sensible and durable; there’s nothing faddish or ephemeral,” says Richard Florida, a professor at the Rotman School of Management at the University of Toronto, who has studied SAS and is the author of “The Rise of the Creative Class.”

During the technology boom at the start of this decade, SAS considered a drastic change in its model: going public. Goldman Sachs bankers were brought in as advisers, and in 2000 SAS recruited a former Oracle executive, Andre Boisvert, as its president.

Under Mr. Boisvert, SAS installed a new financial reporting system and paid the sales force incentive commissions rather than salary only. But when technology stocks plummeted, the appeal of selling shares to the public also receded. Mr. Boisvert resigned from SAS in 2001 and is now an independent investor and consultant.

Mr. Goodnight recalls those days as a brief period of New Economy surrealism, and going public as a path wisely avoided. SAS, he says, is a culture averse to the short-term pressures of Wall Street, which he characterizes as “a bunch of 28-year-olds, hunched over spreadsheets, trying to tell you how to run your business.”

Unlike many other tech companies, SAS has had no recession-related layoffs this year. “I’ve got a two-year pipeline of projects in R & D,” Mr. Goodnight says. “Why would I lay anyone off?”

Mr. Goodnight, though 66, has no plans to retire himself. His fingerprints, colleagues say, remain all over the business, especially in meeting with customers and in overseeing research.

He is not only a statistician, but also a bit of gambler who enjoys calculating his chances. For example, he is co-author of a paper that simulated millions of possible outcomes in blackjack.

Mr. Goodnight regards his new rivals the way a confident card player might. He likes the odds, and he likes his hand.

“We’re pushing as fast as we can to stay ahead — on the cutting edge of everything,” he says. “We’ll do fine.”


Smarter Execs Focus On Goals, Not Just Metrics

November 19, 2009

They’re still using analytic dashboards, but tying the data to strategic goals.

By Doug Henschen

It’s 7 a.m. in San Antonio, Texas, and Rich Marcogliese, chief operating officer of Valero Energy, is holding his usual morning meeting with the plant managers of 16 major refineries throughout the United States and Canada. On the walls of the HQ operations center are a series of monitors centered by a giant screen with a live display of the company’s Refining Dashboard. Whether the executives are in the room or connected remotely, all eyes are trained on the Web-accessible gauges and charts, which are refreshed with the latest data every five minutes.

“They review how each plant and unit is performing compared to the plan,” says Valero CIO Hal Zesch, “and if there is any deviation, the manager explains what’s going on at their plant.”

For Valero, surprisingly little-known for a Fortune 10 (that’s right, one-zero) company with more than $118 billion (with a “b”) in revenue, just one dashboard needle moving from green to red might signal millions of dollars at stake. The point of the dashboard isn’t to call managers out; it’s to give executives timely information so that they can take corrective action.

Valero’s Refining Dashboard is just the sort of cutting-edge decision-support tool that thousands, if not tens of thousands, of companies are now attempting to create. Those companies have embraced the idea that decisions based on fact will consistently beat those based on gut. Business bestsellers including “Competing on Analytics,” “Super Crunchers,” and “The Numerati” have documented that it’s an approach that works. Financial analysts, board members, and even the news media increasingly expect sound, data-backed analyses from top management. And when things go wrong, regulators and, in some cases, even district attorneys follow the numbers to trace bad decisions.

Plenty of obstacles stand in the way of better decision support, from backward-looking metrics and ill-advised goals to antiquated budgeting approaches and technophobic executives. For management teams that can make use of the data–and these days there’s always plenty of data–there are huge opportunities to improve efficiency, develop innovative products, get closer to customers, and outsell competitors.

Start With Goals

Valero rolled out its dashboard in early 2008 at the behest of COO Marcogliese. He had launched a Commitment to Excellence program aimed at improving performance, and he wanted to see real-time data related to plant and equipment reliability, inventory management, safety, and energy consumption.

Whether driven by Total Quality Management (TQM) programs, Balanced Scorecards, or another methodology (more on those later), information-driven companies tend to succeed by establishing clear goals and expectations that are aligned from the top of the organization down to departments and individual employees. When results start coming up short, executives can manage the exceptions along the way rather than hoping for the best and reacting to surprises at the end of a quarter.

Valero’s goals and measures were inspired by Solomon benchmark performance studies well known in the oil and gas industry. Real-time performance data is compared against daily and monthly targets, and there are executive-level, refinery-level, and even individual system-operator-level dashboard views. It’s rare among business intelligence deployments to get fresh data every five minutes, but Valero has tapped directly into “process historian” systems at each plant in a six-month deployment of SAP’s Manufacturing Integration and Intelligence application. The data is aggregated and displayed using SAP BusinessObjects Xcelsius software.

 A major focus of Valero’s Commitment to Excellence program is reducing energy consumption, so the company is rolling out separate dashboards that show detailed statistics on power consumption by unit and plant. “Based on the data, managers can share best practices and make changes in operations to reduce energy consumption while maintaining production levels,” CIO Zesch explains. Estimated savings to date: $140 million per year for the seven plants where the dashboards are in use, with expected total savings of $230 million per year once the dashboards are rolled out at all 16 refineries.

The successes have created dashboard-envy within Valero, so IT is working on similar dashboard programs for sales and marketing as well as the strategic sourcing unit.

Focus On The Right Measures

The terms “scorecard” and “dashboard” are often used interchangeably, but there’s an important distinction. Scorecards are all about tracking against defined metrics, and most scorecards are attached to a methodology, such as the Balanced Scorecard or TQM, says Mychelle Mollot, VP of worldwide marketing, analytics, and performance management at IBM. “Top executives have actually laid out a map for where they want to drive the business, and they’ve created metrics that will drive the behavior that will get them there,” Mollot says.

Dashboards display key performance metrics and perhaps green, yellow, and red zones, but they don’t tend to show predefined targets or goals established by management and aligned to strategy.

Whether they call their decision-support tools scorecards or dashboards, only a small percentage of leading companies have actually mapped out enterprise-wide goals with a formal methodology. (The Balanced Scorecard Hall of Fame currently lists only about 120 members, including Best Buy, Hilton, UPS, and Wells Fargo.) Some companies come up with their own methodologies, but the key question is whether it’s a comparative decision-support interface –does it track performance trends relative to predefined goals? A much larger chunk of companies use dashboard-style interfaces that simply monitor the health of the business. “These types of decision-support tools aren’t often attached to a grand methodology or linked down to the bottom of the organization,” Mollot says.

It’s not that monitoring-oriented dashboards can’t be effective. But without high-level business strategizing (as Valero has done), there’s a danger you’ll end up sharing the wrong metrics. Sales stats and financial measures, for instance, can be lagging indicators, and decisions based on this data might miss a looming shortfall that might be obvious in sales pipeline information.

At Elkay Manufacturing, a $1 billion plumbing fixture and cabinetry maker, the CFO has led the company to embrace both the Balanced Scorecard (taught by The Palladium Group) and the Beyond Budgeting/Continuous Planning Framework (promoted by the Beyond Budgeting Round Table). The idea behind continuous planning is to be adaptive, revising plans and forecasts each quarter and always looking out six quarters rather than four.

The conventional budgeting process, by contrast, often takes too long, it’s a fixed contract, and “compensation schemes tied to it tend to encourage all sorts of bad behavior, like people sandbagging or just budgeting amounts based on last year’s budget,” says Adam Bauer, corporate planning manager at Elkay.

 Elkay’s stated strategy is to grow profitably, so its sales-related scorecards and dashboards include profit metrics so that salespeople don’t just drive revenue at the expense of the bottom line. Controller John Hrudicka says the company’s decision-support tools have identified initiatives that produced more than $13 million in hard-dollar profit improvements while “helping us transform our culture to a profit mind-set.”

Elkay put most of its decision-support technologies in place over the last two years. It tapped Host Analytics’ software-as-a-service financial performance management system, which it uses for budgeting, planning, reporting, and end-of-quarter financial consolidation. The system also supported the move, completed in September, to 18-month budgeting and planning cycles. Elkay chose Acorn Performance Analyzer software for activity-based costing–analyses that reveal the true cost of delivering products (including manufacturing, distribution, sales and marketing, and warranty claims) as well as the true cost of sustaining customers (including products purchased, discounts applied, and ongoing service and support costs).

Elkay already had both Oracle (PeopleSoft) and SAP ERP systems in place as well as an Oracle data warehouse. For decision support, Oracle Business Intelligence Enterprise Edition pulls information from all of these systems to deliver multilevel scorecards and dashboards. “It starts with the corporate scorecard and it rolls down from there to the divisions and all the way down to individual-employee goals that affect bonuses at the end of the year,” Bauer says. Bottom-up feedback, he says, is gathered during quarterly strategy reviews.

Foster A Data-Driven Culture

Few companies have worked as hard or as long at data-driven decision-making as Johnson & Johnson. In the 1980s, J&J embraced TQM and Phil Crosby’s Zero Defects approach. In the ’90s it moved on to Malcolm Baldrige-type criteria for performance excellence. Early in this decade, J&J focused on process excellence, and by mid-decade it had embraced powerful improvement tools including Six Sigma, Lean, Value-Stream Mapping, and Design Excellence. What most of these approaches have in common is an iterative process of assessing opportunities, developing goals, implementing improvements, and then monitoring their success with the aid of decision-support tools. Indeed, fact-based decision-making is now “part of the culture at J&J,” says Karl Schmidt, VP of business improvement, who leads a nine-person internal management consulting group.

J&J is decentralized, so there’s no single, overarching corporate dashboard. There are separate dashboards–or in some cases, balanced scorecards–within the pharmaceutical, consumer, and medical device and diagnostics product divisions and the dozens of companies in each of those groups. The key performance indicators include a mix of financial metrics (revenue, net income, cash flow); customer metrics (satisfaction, loyalty, market share); internal process metrics (product development, manufacturing efficiency, fulfillment); and employee measures (engagement, satisfaction).

As late as 2006, J&J estimated that all the top-line and bottom-line improvements rolled up across the company totaled more than $1 billion a year in “value creation,” Schmidt says. But more recently, those improvements haven’t been enough to insulate J&J from what he describes as “brutal economic conditions.” Early this month, J&J announced a restructuring that will cut up to 7,000 of its 117,000 employees worldwide. Restructuring is rife across the pharmaceutical industry, and Schmidt says having good decision-support tools is more important than ever.

“It comes down to fact-based decision making,” he says. “In tough economic times, you want the best available data and analysis to make better decisions.”

Cater To The Audience

Maine Medical Center created a dashboard this year to help it win reaccreditation as a Magnet-Designated Hospital for nursing, an elite distinction. The dashboard delivers eight key metrics on patient safety and satisfaction by hospital operating unit, so that nurses, nurse directors, and administrators can log on and check personal performance, unit performance, and rollups for the entire hospital.

But Maine Medical’s deployment underscores the decision-support truism that some executives are more savvy than others when it comes to using these tools. “I walked into the chief nursing officer’s office one day, and she had about 50 paper printouts of dashboard views wallpapering an entire wall,” says Doug Salvador, the center’s associate chief medical officer. “It’s nice that she valued the information that much, but I had to show her that she could always access historical views.”

Fortune 10 energy company Valero provides real-time data to managers at its 16 refineries.
Fortune 10 energy company Valero provides real-time data to managers at its 16 refineries.

Over the last three years, the medical center has used SAS Institute’s balanced scorecard software to codify patient-care quality and safety strategies as well as supporting goals and measures. Most goals are delivered though performance-improvement dashboards, which seem to be getting the job done. Maine Medical has been named to the U.S. News and World Report Best Hospitals list three times (for gynecology, orthopedics, and heart care), and its Cancer Institute in Scarborough, Maine, was selected this year as one of five model cancer programs in the United States by the Association of Community Cancer Centers.

Salvador says his group spends most of its time asking front-line caregivers how they can improve reports, scorecards, and dashboards, but the team is also “picking off” once tech-averse executives by making their decision-support tools more useful to them. In the past, the chiefs of surgery and medicine barely used the decision-support tools, he says, “but they now have access to physician-specific scorecards with performance data that they need when it’s time to re-credential doctors within their departments. They used to get e-mailed reports that weren’t very complete. Now they’re getting more data, and it’s presented in a more useful format.”

Look To The Internet

Some of the most decision-support-savvy executives can be found in e-commerce. For example, Patrick Byrne, CEO of Overstock.com, is said to use dashboards to help set his daily schedule. If the problem of the day is gross profit margins, that will drive who he calls in for a discussion. “If you get invited into a meeting with that kind of metrics-oriented CEO, you better have your hands on the data, including the detail at the next level down,” says David Schrader, director of strategy and marketing at Teradata, the vendor behind Overstock’s data warehousing environment.

Overstock can roll up its profit and loss statement every two hours, “which is absolutely world class,” Schrader says. That capability gives executives accurate, up-to-date insight into the financial results they can expect, and it also drives operational decisions such as spot buys of TV advertising.

Whether a company is an e-commerce powerhouse or not, digital marketing channels like e-mail, social media, and online advertising networks are increasingly important. Thus, top executives should be watching forward-looking, upstream measures such as Web site performance, Web-driven lead generation, and sales pipeline information. Here, again, you must be careful to select the right metrics.

“A lot of people are measuring the wrong thing, like how many people came in the door,” Schrader says. “What you really want to measure is how many people came in the door and became qualified leads.”

And once prospects become customers, you’ll want to know if they are good or bad customers. That’s where analyses such as activity-based costing and customer segmentation come in. Lessons learned should come full circle and be reapplied to lead-generation campaigns and marketing offers.

Tell A Story With The Data

Considering all the IT systems now in place, the growing dominance of Internet-based marketing, and the intensely digital nature of services-based industries, there’s no doubt that data-driven decision making is the way forward. But the key questions are, how prepared are these organizations to synthesize and share key performance indicators, and how prepared are executives to draw insight from information?

CIO surveys, software sales stats, and business bestsellers point to surging interest in business intelligence and business analytics. Villanova University’s School of Business recently responded by changing its curriculum with data-centric decision making in mind. For example, it added an undergrad course on analytics and risk assessment, and it updated the statistics courses required at both the undergrad and MBA levels to be more practical and applied.

The curriculum changes were guided in part by extensive interviews with a group of 16 business leaders (including Schmidt of Johnson & Johnson). The resulting “Current State of Analytics in the Corporation” report says nearly as much about tech skills as it does about executive decision support: The sweet spot for new hires continues to be that elusive combination of technical and business know-how and the ability to “tell a story” with data.


Business Intelligence Accelerator Improves NHS Nottinghamshire County Operational Efficiency

November 18, 2009

 NHS BI specialists, 21C, leverages existing Microsoft software infrastructure to liberate information silos in just two months

NHS business intelligence (BI) specialists, 21C, today announced that NHS Nottinghamshire County has deployed its BI Accelerator to improve operational efficiency. Utilising Microsoft products available through the NHS enterprise agreement, the BI solution is enabling the PCT to deliver wider access to more meaningful management and clinical information.

NHS Nottinghamshire County was created when six former primary care trusts (PCTs) in Nottinghamshire merged to create a new PCT. Andy Hall, Associate Director of Performance at NHS Nottinghamshire County explains, “One of the obvious challenges of such a merger was that despite good information infrastructures, the different systems didn’t match.”

The PCT outlined its requirements for developing a data warehouse and analytical tools to help it achieve world class commissioning status. 21C was selected to deliver on this vision as Nottinghamshire’s BI partner following an open tender and model testing process. Using 21c’s technology, Nottinghamshire will now be able to share information with managers, analysts and practice-based commissioning clusters, using graphical presentations and analytical tools to enable relatively non-technical users to uncover trends and relationships and use drill-down features to find answers.

According to Hall, the 21C approach of leveraging the NHS-Microsoft Enterprise agreement using tools such as SQL Server, MS Office and SharePoint was the right one. “It means that the centrally funded products are nearly free to PCTs and investing in Microsoft means we are assured of a future-proof infrastructure,” he adds. “21C clearly knows the NHS and its data. And, they turned it around incredibly quickly: from legacy systems to beta testing in just 8 to 10 weeks is outstanding.”

Paul Henderson, Managing Director at 21c added, “The significant advantages of BI needn’t be complex, expensive or time-consuming. PCTs are starting to take advantage of the NHS-Microsoft enterprise agreement to use tools such as SQL Server, MS Office and SharePoint. These are not only centrally funded products but assure a future-proof infrastructure.”

The PCT has named their Business Intelligence suite ‘ROBIN’ and there are plans to extend the scope over the coming months to support strategic teams, invoice validation, commissioning and public health functions.

About 21c

21c provides NHS Business Intelligence Portals based upon the Microsoft Business Intelligence software stack, best practice data warehouse design methodologies and most importantly an extensive health sector experience. The company demystifies business intelligence by delivering solutions, packaged or through consultancy engagements that connect health care professionals with their data and enable them to access information in way best suited to them. 21c’s solution provides PCTs with access to performance KPIs, operational or clinical dashboards or direct access to data using analytical tools. For further information see www.21c.it


Trends in the Healthcare Business Intelligence Marketplace

November 17, 2009

Jason Oliveira , Kurt Salmon Associates, writes:

The Business Intelligence Challenge

The importance of business intelligence (BI) has grown exponentially as healthcare providers respond to a wide range of internal and external demands.

While advances in health information technology may be improving clinical operations and increasing bedside data capture, exploiting this wealth of new data with legacy decision support systems remains a formidable challenge. In addition, decision makers and knowledge workers are demanding more from both the scope of data available and the maturity of tools for analyzing that data.

Demand-Side Trends

  • Healthcare organizations face increased pressure to invest in technologies that help them achieve strategic goals such as competing based on value and quality.
  • The collection of clinical data is growing exponentially as more providers adopt clinical information systems and use ambulatory electronic medical records. However, translating this data into actionable intelligence is challenging when using traditional, financially focused decision support systems.
  • Fiscal pressures continue to intensify as Medicare, state regulators and commercial insurers implement value-based purchasing, price transparency and pay-for-performance programs. Business intelligence solutions are required to meet the information demands of these programs.
  • The appetite for “self-service” decision support is growing. Healthcare professionals want tools that include dashboards, scorecards, data visualization, and real-time business activity monitoring.
  • Personal productivity tools like Access and Excel have created an explosion of uncontrolled and misapplied data management and analysis efforts. BI solutions are needed to rationalize the flow of data throughout the workforce.
  • Clinical and translational research is in the midst of an industry-wide revolution driven by the NIH Roadmap and the Clinical Translation Science Awards. Health systems must address the entire data management environment and the touch points among the basic science, clinical research and patient care arenas.
  • The emphasis on performance management initiatives such as the Balanced Scorecard, Six Sigma and Lean are expanding. These programs require efficient ways to gather and interpret data.

Supply-Side Trends

  • Legacy cost accounting, budgeting and revenue modeling systems are becoming obsolete. Healthcare organizations that need to upgrade/replace outdated systems are evaluating how to improve their overall BI capabilities beyond the financial.
  • Pure-play BI vendors have increasingly been acquired by mega-vendors (e.g., SAP’s acquisition of Business Objects, Oracle’s acquisition of Siebel and Hyperion, and IBM’s acquisition of Cognos).
  • There has been additional consolidation within the vertical healthcare space with the acquisition of Enterprise Performance Systems Inc. (EPSi) by Eclipsys. This follows Eclipsys’s acquisition of TSI and brings fresh foundation technology and functionality to the legacy Eclipsys decision support solutions portfolio.
  • The consolidation of enterprise resource planning (ERP) and BI vendors is significant to healthcare organizations interested in expanding their ERP investments into planning, budgeting, cost accounting and management financial reporting, and deploying BI capabilities in a single, ostensibly integrated environment with one vendor.
  • The market for next-generation clinical and financial business intelligence systems is in its early stages, and companies will be jockeying for leadership status over the next several years. The core Electronic Health Record (EHR) vendors such as Cerner, Eclipsys, Epic, Siemens and McKesson to various degrees are positioned to provide add-on BI solutions to exploit the data generated in their operational information system solutions.

Achieving Equilibrium

Faced with these dynamic demand and supply trends, the business intelligence challenge for healthcare organizations is to devise and pursue a strategy toward equilibrium. Equilibrium will seek to match the insatiable demand for actionable insight with the supply of data, tools and services, all at the right price for the organization. First, it must be recognized that there is no such thing as a perfect, optimal, off-the-shelf strategy and solution portfolio to “best” enable the BI needs of an individual healthcare organization. A three-step strategy framework is recommended to help an organization devise and deploy a carefully considered BI strategy that best achieves equilibrium.

  • Where are we now? Organize the strategy effort, create and educate the core participants, and assess the existing BI environment. The goal of the assessment is to identify high-level requirements of decision makers in regard to access to information, identify strengths and weaknesses of the current capabilities, and evaluate existing data resources, tools, and services.
  • Where do we want to be? Determine future-state requirements and determine the gaps from the evaluated current state. Evaluate alternative approaches to satisfying the gaps, and create the strategic BI road map that will guide the organization from the current to the future state.
  • How do we get there? Create and pursue the tactical implementation plan that could include BI technology selection, process improvement, support services reorganization and the iterative cycle of designing, building and deploying incremental BI solutions for the organization.

GoodData Helps Solution Providers Extend Cloud Business Intelligence Platform

November 12, 2009

New Program Enables Companies to Deliver Customer Analytics Solutions

GoodData today announced the launch of the GoodData Solution Provider Program, the next step in the company’s mission to broaden the adoption of SaaS business intelligence. With over 100 new users registering with GoodData each week, customers are beginning to access reporting and analytics services historically reserved for companies with dedicated BI staff.

Good Data logo

“GoodData uses cloud computing to fix the broken economics of business intelligence,” said Roman Stanek, GoodData Founder and CEO. “We are looking for partners who share this vision, and can help move our customers from initial success to broader adoption.”

The GoodData Solution Provider Program provides system integrators, implementation providers and independent software vendors technical assistance and go-to-market support to deliver customer analytics solutions to their clients. GoodData’s initial solution provider partners have built emerging cloud computing practices, and recognize Cloud BI as the perfect complement and extension to their businesses:

   •   Aiimi Limited, a UK specialist business consultant and leading provider of business intelligence solutions delivered via Software as a Service, supporting SME and Enterprise businesses across all sectors.
   •   Cazoomi empowers its users with the freedom of choice in Software-as-a-Service. Cazoomi’s innovative “My Automated Engineer” provides customers with the ability to self design & quote over 50 of today’s leading SaaS applications such as GoodData.
   •   CloudTrigger, a multi-discipline services firm focusing on Salesforce CRM, Force.com development, SaaS (Software as a Service) and Cloud Computing technologies to help organizations of all sizes realize more business value from their technology investments.
   •   Demand Solutions Group, which provides businesses with on-demand customer relationship management (CRM), enterprise resource management (ERP), and eBusiness solutions.
   •   Edge Solutions, a software and solutions company dedicated to helping organizations gain better insight into their business, improving decision-making and enterprise performance.
   •   Mansa Systems, an enterprise application services provider with core competencies in Software-as-a-Service (SaaS) Applications Implementation, Cloud Application Development, Data Management, Business Intelligence and Mobile Application Development.
   •   Project Leadership Associates, whose Business Intelligence Practice Group helps companies get the most from their data assets by building business driven solutions.
   •   Severn Consulting, a leading integrator providing services to nonprofit & commercial organizations. Services include data conversion & integration, process documentation, business intelligence – reporting and analysis, configuration & support.

“Driven by budgetary pressures in a demanding economy and the increased complexity of traditional Business Intelligence deployments, our clients are taking a huge interest in Software as a Service BI solutions as a more cost-effective, lower maintenance option to conventional analytics software” says Richard Day, Director at Aiimi.

“Business Intelligence is at the core of Cazoomi,” said Mike Bullen,. “GoodData provides us with the killer data, analysis, and cutting edge dashboards that our customers require to run their modern businesses”

“GoodData delivers BI in a SaaS model, which is a great fit for CloudTrigger and our customers,” said Lonnie M. Wills, CEO of CloudTrigger. “GoodData’s combination of easy-to-build dashboards and deep analytics is a powerful combination for companies leveraging SaaS and cloud computing.”

“Our Salesforce.com and NetSuite customers are clamoring for an analytics solution that will go well beyond standard reporting,” said Todd Fitzwater, Principal of Demand Solutions Group. “GoodData helps us deliver analytics cost effectively, and provides one of the most exciting user experiences we’ve seen in this space.”

“GoodData’s on-demand business intelligence model helps us meet customer requirements faster,” said Nathan Wenzel, Partner at Edge Solutions, Inc. ”All BI software should be as easy to work with as GoodData.”

“My clients are clamoring for greater insight into their customer relationships – more reports, dashboards and the ability to drill into their customer data” said Siva Devaki, Founder and CEO of Mansa Systems. “GoodData helps me deliver customer analytics in the cloud and extend my own business.”

“We are excited about bringing the Good Data platform to our customers,” said Andrew Grohe at Project Leadership Associates. “It will provide them with a scalable, cost-effective deployment path for their Business Intelligence projects.”

“Our clients immediately see the vision and value in GoodData,” said Catherine Folkes, Partner at Severn Consulting Group. “The combination of data integration and collaboration allow to them to spend their time evaluating their data for better results were in the past their efforts would have been in buying, creating and building the infrastructure. So often by the time they were done building the infrastructure, it was too late to react to the results.”

About GoodData:
GoodData is the first business intelligence company born in the cloud. Our Cloud BI Platform encourages companies to take an agile approach to customer analytics by making it easy to access and analyze the data that defines customer relationships across marketing, selling and servicing. It may sound complex, but unlike a lot of business intelligence, GoodData is free to start, simple to use, and costs a lot less than you think. GoodData is headquartered in San Francisco and located in the cloud at www.gooddata.com.


Talend’s Open Source Master Data Management

November 10, 2009

Talend announces the first open source MDM solution

Talend, a provider in open source data integration software, recently announced it has acquired all rights to the master data management (MDM) technology of Amalto Technologies. As a result of this acquisition, Talend will be the first company to offer an open source MDM solution, providing organizations with the exact features and benefits found in proprietary MDM solutions, at a fraction of the cost.

Organizations of all sizes need to ensure that they have “a single version of the truth” in order to have a trusted and unified view of the data on their customers, partners and employees. Unfortunately, MDM continues to be beyond the reach of most organizations. The entry point for deployment of proprietary MDM products can range from the hundreds of thousands to millions of dollars. Talend is democratizing MDM for the masses in the exact way it has done with open and cost-optimized data quality and data integration technology. It will shortly offer a free version of its open source MDM solution under the GNU General Public License as well as a commercial subscription version with value-added features and services for enterprise deployment. The new Master Data Management solutions will be available in early 2010.

“Many of the Global 5000 size organizations we work with will be delighted to see a major open source player enter the fast growth MDM market, especially at a time when organizations are doing all they can to optimize the ROI of their projects,” said Aaron Zornes, Chief Research Officer at The MDM Institute. “Talend has a proven track record in software technology domains closely related to MDM and will also bring their open source business acumen and track record to bear in the MDM market.”


MicroStrategy Earnings and Analyst Report -Open letter from Sanju Bansal, COO

November 10, 2009

As a follow-up to Doug Thede’s note earlier today, I wanted to briefly comment on the third quarter 2009 earnings press release we issued yesterday.

I’m delighted our quarterly revenues exceeded $100 million for the first time in our company’s history. This is a great accomplishment achieved through long-term commitment to delivering premium BI technology and service to our customers. Here’s the earnings release for more details: http://finance.yahoo.com/news/MicroStrategy-Announces-Third-prnews-1368082102.html?x=0&.v=1

This afternoon, InformationWeek and The Wall Street Journal both published positive online articles regarding our quarterly financials:
InformationWeek: http://www.informationweek.com/news/business_intelligence/analytics/showArticle.jhtml?articleID=221400057
Wall Street Journal: http://online.wsj.com/article/BT-CO-20091029-724987.htmlThere are several factors driving this year’s success:

  • Prospects increasingly believe that MicroStrategy 9 is the best BI platform in the market today
  • We continue to augment our customer portfolio with industry-leaders. New customers this year include Facebook, Tesco Group, Honda Europe, SUBWAY® restaurant chain, Société Générale, Dean Foods Company, U.S. Department of Energy, and Toshiba Europe, just to name a few
  • As current customers expand their BI deployments, they are choosing MicroStrategy for their growing requirements
  • Influential industry analysts such as Gartner are proactively recommending MicroStrategy technology to their clients
  • Innovative offerings, such as the MicroStrategy Reporting Suite, are enabling us to penetrate new markets

In addition to our strong financial results, Gartner recently published a detailed report on MicroStrategy entitled “SWOT: MicroStrategy, Business Intelligence Platforms, Worldwide.” You’ll find the report on our website at http://www.microstrategy.com/gartnerswot. In short, Gartner addresses some of the strengths of our company, including:

  • The impressive features and performance of MicroStrategy 9
  • Our world-class customer base (many with enterprise-wide BI deployments) and the high number of customers that choose MicroStrategy as their BI standard
  • MicroStrategy’s low total cost of ownership, thanks to our well-integrated platform
  • The high level of support that we provide to our customers

As we approach our 20-year anniversary in November, you can be very proud of the company that we have built, the impact we’ve had on the BI industry, and the positive momentum we’re experiencing today.

Personally, I plan to share this good news by forwarding this note to my professional colleagues, friends, and family; I encourage you to do the same. Thanks for all your effort and let’s keep up the momentum!

Sanju
——————————————-
Sanju Bansal | COO | MicroStrategy
1861 International Drive | McLean, VA 22102
Office: 703.848.8630 | Fax: 703.770.1710
bansal@microstrategy.com
Assistant: Kristina Glansdorp | Phone: 703.714.1210 | kglansdorp@microstrategy.com
www.microstrategy.com


H1N1 Flu Tracked By E-Prescription Data

November 9, 2009

By Marianne Kolbasuk McGee , InformationWeek

Rhode Island is the first state in the U.S. to begin tracking swine flu outbreaks using e-prescription data.

State public health officials are electronically monitoring possible H1NI outbreaks based on e-prescription data from pharmacies that dispense Tamiflu and three other antiviral drugs used to treat seasonal flu and swine flu.

One hundred percent of the approximately 183 pharmacies in Rhode Island are currently connected into an e-prescription network provided by Surescripts, which along with the pharmacies will be providing public health officials with the flu drug data weekly.

The data will include prescriptions ordered by doctors electronically, or by paper, fax, or phone from independent drugstores as well as those operated by large retail chains such as CVS, Rite Aid, Walgreens, and Stop & Shop.

Public health officials will receive de-identified prescription data along with ZIP codes and ages of patients to aid in the tracking and trending of flu outbreaks through the state. The system uses a computer program that complements another flu tracking system used by state officials. That system includes data from Sentinel, which collects flu data reported by 25 doctor practices located in various geographic regions of the state, and another state system that collects data from hospital emergency departments.

By tracking data from multiple sources, public health officials will get a more comprehensive look at developing trends, such as identifying possible H1N1 outbreaks based on location or patient age, such as clusters of school age children in specific towns.

By using the e-prescription data along with Sentinel and ER data, state health officials can also detect and monitor discrepancies between outbreaks reported by doctors versus outbreaks suggested by the number of flu related drugs being prescribed. The discrepancies could be due to factors such as the over-prescription of flu medicines in absence of actual flu cases, as well as the under-reporting of flu by doctors in a region.

For instance, if state public health officials determine that doctors within a certain zip code are prescribing an usually large number of antiviral medicines in the absence of reported flu cases, state officials could target outreach and educational programs to healthcare providers in those regions.

The system can also give public health officials notice if supplies of Tamiflu and other antiviral medicine are running low, which could trigger the state to release emergency stockpiles.

Thanks to ongoing efforts by a statewide collaborative of healthcare providers, consumers, and leaders from government and academia working to improve healthcare in the state — Rhode Island is the state with the highest percentage of pharmacies hooked into Surescript’s national e-prescribing network, said a Surescript spokesman.


Council sues IBM for ‘unsatisfactory’ MDM system

November 3, 2009

Southwark Council has launched a £700,000 legal battle against IBM in a row over a new computer system.

The council said it has lost confidence in IBMs credibility and integrity, and does not believe it will ever be able to have a workable business relationship in future.

Now the council is demanding damages of £717,061 from IBM after branding the new system defective. In 2005, Southwark wanted to install a new computer system allowing different departments to share information through a central repository of key data, called a master data management system, according to a High Court writ.

The council considered a rival system before going ahead with a contract with IBM, running to 19 pages, in which it agreed to pay £259,112 for the IBM Websphere software licence.   The council also agreed to pay £99,124 for skilled staff to implement the system, and £67,000 for the final piece of the system, Orchards ArcIndex, as well as consultancy services and support and maintenance, it is alleged.

But a preliminary review of the system in July 2007 found problems, including a serious deficiency with a vital system component, Orchard ArcIndex, the writ says.  There were also problems with the user interface, messaging integration, matching strategy, and a lack of reporting capabilities, the writ claims.

The council brands the system unfit for purpose and of unsatisfactory quality, and accuses IBM of failing to use reasonable skill and care when designing and testing the system. IBM also negligently claimed during negotiations that the system would meet the councils requirements, but these claims were false, and the system could not deliver its requirements, the writ claims. IBM failed to research solutions after a workshop to resolve problems, the writ says.

The council argues that although it tried to mitigate its loss by trying to find a solution with IBM that would make the system work, IBM tried to absolve itself from any responsibility for the software even though the contract for ArcIndex was an essential part of the system, it is alleged.   The writ was issued by Deborah Collins of the councils legal department.  Computing has requested a comment from IBM.