Panorama Business Intelligence

While Gartner and other BI analysts and experts have recognized the magnitude and impact of Google and Panorama’s partnership on the BI world, some others are still a bit confused as to the meaning of this new development.

Let me try to explain why we have made such a significant bet on being the company that powers Google Apps and Google Docs with BI.

If you ask common business people if they perform BI (most will not even know what that means unless you ask about “analysis and reporting”), 90% will answer “sure I do, I use Excel”.

The sad reality (sad for us BI companies) is that we (BI companies) only deal with 10% of the population – the “Power users”, while 90% perform their reporting and analytics inside spreadsheet applications. It’s true, the numbers are changing and more people use BI tools but the ratio compared to spreadsheet is still very VERY low.

(more…)

As promised, we released the first enterprise extension for Panorama Analytics for Google Docs in the form of SQL Server Analysis Services support. In the following days we are accepting new users by registration on our web site www.panorama.com/google/ssas but in the next couple of weeks this will open up for the masses.

We’ve seen a very large amount of registrations since we announced on Thursday and expect to respond to all our users in the next couple of days.  We thank everyone for their patience. 

Many have emailed me asking about our plans for the product with Google.   Well, we have a long list of systems and platforms we plan to support in the coming months with a goal of making the experience of using Google spreadsheets and other Google applications (such as iGoogle for dashboarding) a very powerful experience.   I can’t disclose the exact plans yet but whether you use SAP or a SaaS based solution, you should expect to get some powerful functionality right from within Google Docs.

So why did we start with SQL Server Analysis Services?  For two main reasons: (1) we got feedback from our existing customers who wanted to get a powerful extranet, collaborative solution for BI while using  their existing BI data infrastructure and (2) it is the most popular data source (outside of spreadsheets themselves) for analysis using Pivot Table functionality.

(more…)

New Support for SQL Server^TM Analysis Services Allows Enterprise Customers to Use
Google Docs to Analyze, Report, Visualize Their Corporate Data

Fresh from announcing their addition of Business Intelligence (BI) to Google Docs, Panorama Software, a global leader in Proactive Business Intelligence, has revealed a new solution for the enterprise level market.  The beta version of its newly developed functionality for Google Docs will allow the support of its first enterprise data source – Microsoft SQL Server^TM Analysis Services, the most pervasive OLAP solution in the industry.   This is the first of what will be many enhancements and new functionalities that Panorama will roll out for Google Docs in the next few months.

Microsoft Excel has been known to be the only spreadsheet tool capable of providing BI capabilities in the form of analytics and reporting for enterprise level data.  By adding support for SQL Server^TM Analysis Services, enterprise companies can now use Google Docs, the most powerful Software as a Service (SaaS) based spreadsheet in the world with its strong collaborative capabilities, to get more out of their enterprise data in new and flexible ways.

Companies have long wanted a fresh way to analyze corporate data using a spreadsheet application, while also enjoying advanced collaboration, mobility and access-from-anywhere functionalities.  With the new support for SQL Server^TM Analysis Services by Google Docs with Panorama Analytics, enterprise customers have exactly what they have been asking for.

(more…)

Today Nigel published is report on the new strategic direction Panorama is taking. You can read the full report here: http://www.olapreport.com/Comment_Panorama_Google.htm

 

Here are a couple of quotes:

“Google takes its first step into the OLAP world by partnering with the same company that helped Microsoft’s entry a decade earlier…”

 

“Formed in 1994, Panorama is now one of the longer-lived small, independent vendors in the OLAP world — but unlike others, its survival has not been based on hiding in a specialist niche. We have tracked the company since mid-1996 (well before most analysts) and have observed the remarkable influence on the industry it has had since then….”

 

On PowerApps: “Behind the simple pivot table interface is rather more OLAP technology than might be expected. As the Google spreadsheet is Web-based, Panorama cannot use the RAM on the client machine to cache the multidimensional data, which is of course what Excel does with local PivotTables. Instead, Panorama uses an undisclosed proprietary OLAP server to do the job, generating server cubes on-the-fly from the data in the users’ spreadsheets. This cube-creation process does cause a delay of at least 10 to 15 seconds (more with larger cubes), and screen refresh after any user action also takes several seconds, so the user experience is not nearly as slick as in Excel.”

Coming home on a balmy spring afternoon, you finger through the multiple envelopes haphazardly stuffed in your mailbox.  Your eyes are met with the usual junk mail, bills and ever-present grocery store leaflets, but an envelope from your internet service provider, a small company, catches your attention and results in a raised eyebrow.  Within it you find a nicely written corporate letter from a senior executive informing you that the company has been acquired by a large, well known communications corporation.  This letter was being sent just to inform their existing customers of this acquisition and to assure you that you could expect the same, if not better, level of service.  Fittingly, it wasn’t long after that you begin to notice slowdowns in your connection speed and customer service that has little or no answers for your many newfound problems.  The closest thing you get to an explanation is from a customer service agent who gives a clearly well-rehearsed line about how, while the company goes through a state of transition, your patience is greatly appreciated.

It is with the same curiosity that many in the business intelligence industry have raised their collective eyebrows at the sweeping changes that have taken place in the world of BI.  Consolidation has become the name of the game as major companies have bought major BI players with the intention of bolstering their positioning in the BI landscape.  While such acquisitions make headlines within the industry and are often heralded as great leaps forward, behind closed doors the story is significantly different.  On the most basic level, post acquisition, the pressure mounts for these companies to figure out how to integrate their products as best as possible due to the problem of overlapping technologies. 

(more…)