Software // Information Management
Commentary
8/20/2008
07:35 AM
Rajan Chandras
Rajan Chandras
Commentary
Connect Directly
RSS
E-Mail
50%
50%

Is Excel a Complete BI Solution?

The recently released Forrester Wave for Enterprise Business Intelligence Platforms assesses 12 BI vendors/tools. The report does not include Excel as one of the 12 solutions, which led me to ponder: Can we consider Excel a BI tool in its own right? To qualify for the survey, the vendor (and tool) must provide...

The recently released Forrester Wave for Enterprise Business Intelligence Platforms assesses 12 BI vendors/tools. The report does not include Excel as one of the 12 solutions, which led me to ponder: Can we consider Excel a BI tool in its own right?

The Forrester report (The Forrester Wave: Enterprise Business Intelligence Platforms, Q3 2008 - free copy courtesy of SAS) specifies that, to qualify for the survey, the vendor (and tool) must provide:• At least three out of the four major functional BI components: production/operational reporting, ad hoc querying, OLAP, and dashboards. • The ability to query databases using SQL and MDX. • A self-contained, complete, fully functioning BI environment, i.e. the tool must be a self-contained, complete BI environment or platform that does not have to be necessarily embedded in other applications. • Sufficient market presence and interest from Forrester clients, defined as at least 100 in-production customers present in more than one major geographical region, with more than 10 percent enterprise-grade, cross-line-of-business installations with more than 100 users. • Significant BI revenues: at least $40 million in BI revenues.

Interestingly, it's not too much of a stretch to make Excel fit into all the above criteria:

• Excel can be (and is often) used for operational reporting, by connecting to databases, and also for analysis and dashboards using pivot tables and charts (plus the power of VBA - Visual Basic for Applications). • Excel does not necessarily have to be embedded in other applications. • Excel certainly has sufficient market presence, well exceeding the stipulation above. • Excel comfortably crosses $40 million in revenues, even when constrained for reporting and analysis usage. (Microsoft Office accounts for some $10 billion annual revenue, give or take a couple.)

Which leads us to the question: Should Excel be considered a BI tool, worthy of inclusion in surveys such as the Forrester Wave? To draw a rough analogy, can a Swiss Army knife - tiny knife, clippers, corkscrew and all - be considered as a tool for hunting?

I ran this thought by the author of the report, Forrester analyst Boris Evelson who, incidentally, is also the author of an interesting report last year on the use of Excel as a BI tool (Ouch! Get Ready - Spreadsheets Are Here To Stay For Business Intelligence).

In his response, Evelson explained that if he included Excel as a standalone BI solution and not just a BI presentation tool, it would have scored rather poorly since it still relies on the underlying BI/DBMS infrastructure for components that are critical for large, complex enterprise BI, such as real-time BI, OLAP beyond pivot tables, report formatting and scheduling, unstructured content etc.

"I vote for Excel as a BI UI, or Excel as a lightweight, departmental or SMB BI solution," he wrote. "But standalone Excel cannot be the one-and-only BI tool to fulfill complex and broad BI requirements in large enterprises."

Excel continues to pose an intriguing challenge to BI solution vendors and practitioners alike, the central question being: when implementing a BI solution, to what extent do we intentionally architect a solution that caters to users preferring to stay with Excel, and/or design the solution to draw users away from Excel?The recently released Forrester Wave for Enterprise Business Intelligence Platforms assesses 12 BI vendors/tools. The report does not include Excel as one of the 12 solutions, which led me to ponder: Can we consider Excel a BI tool in its own right? To qualify for the survey, the vendor (and tool) must provide...

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Must Reads Oct. 21, 2014
InformationWeek's new Must Reads is a compendium of our best recent coverage of digital strategy. Learn why you should learn to embrace DevOps, how to avoid roadblocks for digital projects, what the five steps to API management are, and more.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
A roundup of the top stories and trends on InformationWeek.com
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.