Is Excel Best Way to Bring BI to the Masses? You Bet, Says Microsoft

We hear a lot about making business intelligence moreIt’s no surprise, then, that Microsoft is pitching
user-friendly, more pervasive — more democratic, ifseamless integration with Excel as a key selling point
you will. All of the BI vendors are plugging these termsfor its PerformancePoint Server 2007. That emphasis
into their sales pitches. Taking Excel and making it partmay pay off, based on the comments of folks in this
of the bridge to BI seems to make a lot of sense.Enterprise Systems article. According to the article,
Read how Microsoft is pitching a seamless transitionmany companies use PerformancePoint Server 2007
for BI tools using Excel.as a complement to Excel and Excel-centric business
One of the continuing knocks against businessprocesses, rather than a replacement for them.
intelligence is that it remains too darned difficult for allJohn Workman, senior manager of performance
but BI specialists.management for Microsoft partner RedPrairie, which
Back in April, for instance, I blogged about Acecreated its newest application for SQL Server 2005
Hardware’s decision to swap out an overlyand PerformancePoint Server 2007, says that his
complex BI system for a simpler reporting tool fromcompany's clients have cheered the Excel integration
Information Builders. Interestingly, one of the keycapabilities. He says:
reasons Ace opted for the tool was its ease ofIt is amazing how many companies out there run their
integration with Microsoft's Excel.business on Excel. The ability for a non-geek
Though spreadsheets have typically (and oftenemployee to build ad-hoc reports in Excel while
justifiably) gotten a bad rap, they are such a fixture inconnecting to OLAP cubes with a live connection has
the corporate world that, like kudzu and cockroaches,really made an impact on our clients.
they will never be eradicated. Some BI vendors haveThis article includes lots of details about
given up on trying to fight spreadsheets and insteadPerformancePoint Server 2007, including a rundown of
are creating ways to use their products with Excel.the product features. One of the primary strengths of
Writes IT Business Edge blogger Loraine Lawson:the product, according to the article, is the fact that,
While most vendors - and many IT departments -unlike many other Microsoft products, it is built from
struggle to convert the spreadsheet-addicted,scratch. Thus, it includes no inherited weaknesses or
Microsoft and a few other BI vendors have acceptedknown flaws, and Microsoft can more easily address
the Excel problem as a business reality and given upproblems during development.
converting the business users, according to the StateWhile the article is largely complimentary, it does
of Business Intelligence report. Instead, they’requestion whether most companies will get enough BI
developing ways for their BI tools to work with thebang for their $20,000 bucks (cost of a single server
spreadsheet-addicted.license).