The Best of Business Intelligence: Innovation at the Fringe
By Zach Gemignani
June 28, 2009
Find more about:
business
intelligence,
dashboard,
analytics,
visualization
Enough complaining about the broken bits of Business Intelligence; it's time to highlight the things that are good and right in the industry. Like most industries, the renewal and innovation occurs at the fringe, beyond the comfort zone of established vendors.
I've created five categories and a catch-all to capture the solutions and companies (not so much technologies) that are leading the next generation of Business Intelligence. The categories are:
- Analyst tools
- Dashboards
- Targeted solutions
- Open-source and free
- Advanced visualizations
- Other stuff
Naturally I've focused on areas of Juice expertise and focus -- not coincidentally, the places where we feel BI has neglected end-users. According to a study by the Business Application Research Center, BI end-user adoption sits at a lowly 8%.
I'm happy to take your suggestions (and update the post) for things I've missed in these categories or for entirely new categories.
Analyst tools
Tools that make it easy for analysts to pull data from multiple sources, analyze, visualize and share it.
Winner: Tableau, the reigning king of visual analytics tools, has added more web-based functionality to allow for online sharing and collaboration.

Runner-up: Good Data has arrived on the market with a web-first platform designed to democratize analytics. I had a chance to get a demo from the management team and was impressed with the ease of use and high-quality data presentation.

Dashboards
"A frequently updated analytical display that is clear and concise" (via a recent post)...and not likely to draw the rage of Stephen Few.
Winner: BonaVista Systems wants to make Excel a "first choice dashboard tool." From the humble position of sparkline plug-in vendor, BonaVista has taken a leadership role in encouraging more effective dashboard design.

Runner-up (tie): Two BI companies, Qlikview and Microstrategy, seem to be following BonaVista's lead. Unfortunately, they may only be dipping in a toe as I found just a couple examples that break from the traditional over-glossy, gauge-riddled dashboard interface.
Targeted solutions
Companies that serve a narrow slice of the BI world extremely well. The desire to be all things to all people has been an Achilles Heel of the BI industry. The general purpose BI platforms often prove too broad and too generic to serve the unique problems of specific industries or functional areas.
Winner: Wall Street on Demand is a brilliant, below-the-radar provider of information solutions to the financial sector. Their sparse, articulate marketing text and few screenshots hint at a company that knows exactly what they do and deliver high-quality BI solutions. I wish I knew more.

Runner-up (multiple): The following are just a few companies that have focused on an industry or functional segment to deliver targeted BI solutions:
- Quantivo for customer behavior analytics
- Visual I|O for pharmaceuticals
- LucidEra for sale pipeline reporting and analytics
Open-source and free
(I know there is a difference.)
Winner: Pentaho offers an open-source end-to-end BI suite that is a competitive alternative to the big-guys. Of course, the implementation it isn't necessarily cheap or easy.

Runner-up: If anything should scare the BI industry, it is the possibility of a Google Analytics model extended into more general data analysis and visualization tools. Google Fusion Tables may just be the tip of the iceberg.

Advanced visualizations
Bringing leading-edge visualization techniques out of academia and into the business world.
Winner: Many Eyes continues to impress with high-quality visualizations. They are easy to create and clean in design and usability. Impress your boss with a slick visualization in your next presentation.

Runner-up (tie): Openviz / Advanced Visual Systems and Panopticon appear to be the two BI vendors battling it out for leadership in advanced visualization solutions. Unlike Many Eyes, these guys lack Tufte-esque sophistication in infoviz design. That said, there is a big difference between creating a one-off New York Times-quality visualization and delivering a toolset that is re-usable in many different situations.
Other stuff to be admired
Free charts with good default design. InetSoft's Style Chart and Google Charts offer free, embeddable charts.
Jargon-free BI marketing. With few exceptions, BI web sites are densely populated with those awful stock-photography people sitting around conference tables (or worse, the ethnically-diverse V-formation marching at you) and meaningless business jargon and techno-babble. I really appreciate Blink Logic's web site with its straight talk and clean, readable design.
Beyond the desktop. RoamBI has a great-looking iPhone application that is designed to "transform your data into insightful, interactive visualizations delivered to the iPhone." It makes the Oracle and Qlikview iPhone apps look old-school.








14 comments | Show all comments only the last 5 are shown
Charles said:
Interesting choices, no mention of Xcelsius though, any reason why?
Howard said:
For open source... Actuate and BIRT... or Jaspersoft?
Zach said:
Charles, under what category would you consider Xcelsius a contender? From what I've seen, it doesn't encourage effective information design for dashboards (check out the shiny pies and speedometers in this screenshot: http://bit.ly/P5u9v). It is more presentation tool than analysis tool. And it doesn't do much to push the boundary of advanced visualization.
Clarence said:
Zach: You can checkout Zoho Reports (http://reports.zoho.com), next time around. Its a On-demand Reporting and Business Intelligence Service from Zoho, a leading provider of Online Office and Productivity suite.
I would also be happy to provide you a demo, if you require the same
Thanks,
Clarence
http://reports.zoho.com
Mail: clarence at zohocorp dot com
bts said:
This is a great summary. It gives many good pointers. Some comments have mentioned Jasper, BIRT among others. But these are remake of tools from 20 years ago. You picked a good set.
Keyur said:
Thanks for the great list. I use Tableau as well, and it's amazing. Wish they had a little more dashboard features, like the microcharts.
For microcharting, I use the open source and free:
http://sparklines-excel.blogspot.com/
T J Bate said:
Surprised you did not cover Visokio Omniscope..it has a lot to offer in ALL these catagories, and is often preferred to Tableau, QlikView, Excelsius and others. Should be on everyone's shortlist. Free to try:
http://www.visokio.com
Zach said:
TJ: Thanks for the suggestion on Visokio. It looks great and appears to be comparable to Tableau. I think you are overplaying your hand by saying it qualifies for ALL categories. It isn't open source/free, especially good at dashboard info presentation, or industry-focused (being used in particular industries is different).
Mike S said:
I believe you have miscategorized QlikView as a dashboarding rather than analytical tool. Yes, you can create dashboards with it, but that would be underselling its ability to combine millions of rows of data - and leave it at that granularity - from different types of data sources and perform analysis on it using their proprietary associative technology (see here for an explanation on that last point: http://demo.qlikview.com/AJAX/films/). The example you linked is lacking in dimensionality and may not be a great representation.
To suggest that they are following the lead of an Excel add-in company is funny; they actually consulted Stephen Few for their data visualization, which can be as muted or candy-like as you desire, in their latest release. And no, I don't work for QlikView.
Zach said:
Mike,
Thanks for the link. I appreciate that QlikView is a comprehensive BI platform. I wasn't trying to sell their product as much as point out ways that BI companies are pushing-the-envelope. From the looks of that demo, there may be other interesting ways that QlikView is innovating.
Qlikview may have consulted with Stephen Few, but it is hard for me to see the impact beyond that one dashboard. "Muted" design isn't the issue as much as poor choice of charts and distracting chart design.
Bjoern said:
Thanks for the great overview. I listed it in the Web Analytics TWINE: http://www.twine.com/twine/12v6ghwcm-1t1/web-analytics
ya_kokashko said:
Thanks for the great list. I use Tableau as well, and it's amazing. Wish they had a little more dashboard features. <a href=http://www.kokashko.com>kokashko</a>
ya_kokashko said:
Surprised you did not cover Visokio Omniscope
<a href=http://kokashko.com>kokashko</a>
Andrew said:
I have also been using Tableau and its just incredible how quickly it is to create very rich visualisations and share these with peers. It really does push the edge of the envelope and the mapping functionality puts the cherry on the top as I can now do a heap of spatial reports. Not one line of code!!!
said:
Add a comment