Pretty Pictures of BI: Tableau

Of course, these “exploration” tools are also not intended to be full enterprise BI platforms. Instead, they are complementary to more robust products. You will not replace your existing BI products (SAP Business Objects, IBM Cognos, IBI WebFOCUS, MicroStrategy, etc.) with the limited scope of visualization software but you might consider supplementing them.

Competitive Vendors
The main data exploration products on the market today include:

• QlikView ($204 million revenue in 2011) 
• Spotfire ($105M 2011) acquired by Tibco in 2007
• Tableau ($62M 2011) 
• ADVIZOR Solutions ($10M?) which is also sold as WebFOCUS Visual Discovery

Tibco’s Spotfire is the old grand-daddy in this list and was quickly overtaken by the new kids on the block: QlikView from Sweden and Tableau from the Silicon Valley of the United States. 

Tableau to be the Winner?

Tableau arose out of a Stanford University research project from 1997 to 2002, and was spun off as a company in 2003. (Keep in mind that Jim Goodnight started SAS as a small college project which he later grew into a multi-billion dollar mega-software vendor.)

READ

Is UX Important To Business Intelligence Analytics?

 

As part of a Department of Defense initiative, PhD candidate Chris Stolte created a “Visual Query Language” to explore large multi-dimensional databases. As luck would have it, Stolte’s university mentor was Pat Hanrahan, a founding employee of Pixar. 

 

Together, they created what has been called “a kind of high powered, highly visual Excel,” which is a really good way of explaining the innovative software product. One of their first interested partners was Essbase, which makes sense. A common user interface for the Essbase cube was Excel, and Tableau was a nice next-generation version of that. 

 

Tableau is the type of visual analytics software that Microsoft itself should have added to Excel. 

 

The main Tableau products include: 

• Tableau Desktop (authoring/publishing tool)
• Tableau Server (web hosting component)
• Tableau Reader (web viewing tool)

Tableau Desktop is an Excel spreadsheet hopped up on visualization steroids. Based on selections, Tableau points out to the user the “best practices” for visually displaying data.

Several of about twenty-four “Show Me” options light up for the user. Simply clicking on one, such as a geographic map or a stacked bar chart, does all of the work. There is no coding and no macros, just an easy to use graphical interface.

READ

Are Advances In Analytics The Key To Increasing Hospital Profit Margins?

Within an hour after downloading a Windows desktop copy, I had used one of their accompanying demo files to generate a report, pie chart, bar chart, and geographic map.