Free BI!

BorisevelsonBy Boris Evelson

Now that I caught your attention with the title -- it's not what you think. It's not about freeing BI from the constraints and limitations of corporate politics, organizational silos, and lack of proper data governance -- although that's a very worthy topic to write about.

This morning, Google will unveil a beta version of its spreadsheet application with some new advanced features, such as Pivot Table. The Pivot Table is a product developed by Panorama, a small, but upcoming BI vendor (they are currently being evaluated in detail by Forrester BI Wave '08), who were, interestingly enough, the original inventors of Microsoft Analysis Services OLAP (Online Analytic Processing) engine. So now, part of Panorama code will be inside two of the biggest software companies in the world!

Free_sign_medWith this new feature, every Google spreadsheet user will have access to powerful OLAP, as a free BI SaaS add-on to Google Docs. In my opinion -- a very wise move by Google to continue to push Google Docs into enterprises.

When I wrote a research document on the intersection of BI and spreadsheets, I had to defend my thesis that Excel is here to stay in front of several Forrester analysts and research directors. Some of them questioned the long-term viability of Excel vs. Google apps free SaaS model. I still stand by what I said and wrote -- business users are much more concerned with rich functionality, familiar interface, and ubiquitousness of Excel, even given the low- to no-cost Google option and its out of the box collaboration capabilities. With close to 400 million Excel copies out there, Excel and, specifically, Excel for BI is here to stay.

In order to compete with Excel, among many other features, Google spreadsheets lacked specific business functionality needed to analyze vast amounts of data stored in these spreadsheets. With Panorama free add-on Google spreadsheets, users can now take advantage of this lightweight -- but still very respectable and powerful -- OLAP engine. Yes, out of the box native pivot tables in spreadsheets can do basic analysis on rows and columns of data, but Panorama takes it much farther with more powerful OLAP functions like (I don't actually know yet what subset of full Panorama OLAP functionality is available as Google add-on):

  • Drill up/down
  • Drill across/Drill through/Drill anywhere
  • Allocations
  • Combine/merge/split dimensions
  • Exception handling and conditional formatting

Are there any immediate takeaways for our audience, I&KM pros? Probably not, since this offering is far from a large enterprise grade reporting and analytics solution, lacking such necessary features as end-to-end metadata management, data cleansing, connectivity to all corporate data sources, and many others. However, I do hear of an increasing demand among power users for a BI "sandbox" environment, where one could perform all sorts of data analysis without being constrained by corporate security, priorities, system availability, and many other issues that typically keep IT lagging in delivering on the barrage of never-ending business requests for BI enhancements. As a result, I always advise all BI vendors to include BI "sandbox" functionality in their product offerings. Outside of the firewall, sandbox, SaaS BI application could just be the answer.

What's next? Will Google buy and offer Data Warehouse and BI SaaS services on this infinitely scalable platform? Not sure, given security and WAN bandwidth concerns. But watch for a blog from my colleague, Jim Kobielus, with more on these interesting possibilities.

Regardless of what Google does next or what other BI vendors will do in response, BI users now have yet another free BI option (yes, limited, but you can't beat the price) in addition to Open Source BI tools available from Ecliplse BIRT and other Open Source BI projects sponsored by Actuate, Jaspersoft, and Pentaho.


re: Free BI!

Nice post Boris.So this seems to come on the heels of a busy year for Google's Apps strategy that's now barely one year old.Google's lineup for business now includes:- Editors: Google Docs and Spreadsheets, Presentations- Instant Messaging: Google Talk- Calendaring: Google Calendar- Email: Gmail- Team collaboration: Google Sites (formerly JotSpot)- Portal: Google Start Page, iGoogle and a growing library of Google gadgets- Search: on-premise Google appliances and cloud-based search services- ..and now BI.The categories are beginning to look a lot like those covered in Forrester's Information Workplace research stream.Yet Google's strategy strangely reminds me of three key tenets of Walmart's early moves into discount retail:1.) Stick to the rural areas where competitors aren't present. In this case, that means avoid big IT shops where companies like IBM, Microsoft, Oracle, and SAP compete based on IT pro relationships as much as they do on actual product. This is not to say, Google isn't catching the eye of big business. They are.2.) Give individual consumers what they want: convenience and every day low prices. It's clear that workers are taking more and more control of the technology they use at home, and when permitted to do so, at work. Google's prices *look* low, but the jury is still out on the fully-burdened cost of these services for businesses.3.) Build a world-class logistics operation and execute efficiently. Google's not only world remowned for their data center efficiency, they're also moving at a faster pace than big enterprise software companies that have miles to go before they can untether themselves from protracted product development cycles, channel conflicts, and cannibalization of existing products.Needless to say, big questions remain around not just the economics and market acceptance of these tools in the cloud, but also technology issues like security, privacy, compliance.Between this, Microsoft's "Business Productivity Online" initiative, and IBM's "Bluehouse" project - which are all focused on cloud-based information worker tools - it's shaping up to be an interesting year.

re: Free BI!

Hi Boris,This is an interesting post, but I found it quite misleading. For example when you say:"With Panorama free add-on Google spreadsheets, users can now take advantage of this lightweight -- but still very respectable and powerful -- OLAP engine." Do you mean that Panorama will offer its own OLAP engine? Panorama has been a front end to 3rd party OLAP engines for quite sometime, but they never had their own one. Are you trying to tell us they are developing an OLAP engine?Google on the other hand has their BigTable data service, but it is not quite OLAP service. So who is actually doing OLAP in this scenario? Is it a real OLAP repository which can be queried with MDX or something that just "looks like" OLAP.I am not sure if you worked on any real world OLAP implementations, but there is a lot more to OLAP than simple pivot tables through Excel.