Is Excel a Complete BI Solution?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?

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...