Panorama Business Intelligence Blog

New PowerApps Platform Gives Enterprises, ISVs and Developers a Cost-Effective Way to Power Business Intelligence Applications Via the Web

TORONTO, ON – (June 4th, 2008) – Panorama Software, a global leader in Proactive Business Intelligence solutions, today officially announced its PowerApps™ strategy, a cloud computing analytical engine for Business Intelligence (BI) applications. Through PowerApps, ISVs and software developers can now take advantage of the first “Analytics as a Service” platform to develop and extend various analytical applications using the power of cloud computing.

PowerApps is a Web-based, hosted and extremely efficient OLAP (OnLine Analytical Processing) platform that cancreate, manage and support any type of analysis scenario. The platform offers APIs to create OLAP cubes as well as to deliver and create customized, user-facing reports from within Google Apps™.

PowerApps is the analytical engine powering Panorama’s analytical solution for Google Docs™.For more information please visit: www.panorama.com/google/.

“Cloud computing challenges the rules and commercial model of the software platform vendors, and is a significant major trend in the software world,” said Gerry Brown, Associate Analyst with Bloor Research International. “Panorama’s PowerApps delivers analytics as a service, and joins solutions such as Amazon® S3 and the Google BigTable in offering a differentiated cost-effective alternative solution to those of the traditional platform providers.”

(more…)

I want to show you a work I finished few months ago. I’m very proud of this work as it will be in the desktop of our CEO and I got many compliments for it. Making this was possible thanks to the Panorama SDK.

There’s a problem getting out screenshots out of my company, so I did a sketch in Power Point. Note that what you see in the picture is not the real screenshot of the work (It’s much more beautiful in the reality…).

This is the functionality of the leds map (my design, if you have any comments):

• The leds map is simply a web site, meaning zero-footprint in the client’s computer. Some computers in my company has java compatibility problems, so I added a parameter you can send with the site’s URL which changes the applet’s java version (see more in the next post, which will be more technical).
• The leds map has to be small, about a quarter of the screen. That’s because it’s intended to be a part of the CEO’s desktop.
• When the map loads, a picture with a turning-around The Thinker statue is shown with a “Loading” message below (our CEO loves that statue…).
• After the map has been loaded, the user sees two axis with the leds in them. The two axis can represent any Meta-Measures you’d like: Short-Term Profit Vs. Long-Term Profit, Client’s Satisfaction Vs. Company’s Profit, etc. This is a point that many people have difficulty to understand, so I’ll give an example: The yellow led is in the top-right corner, so that says that the underlying measure is very important in both the meta-measures. Going on with the example, that says that this measure is very important for theClient’s Satisfaction and for the Company’s Profit. Note that the leds never move. Only their color changes.

(more…)

First it was the blog world that was buzzing about Panorama’s initiative with Google and now analysts are turning their attention to the unique offering by Panorama and Google.

Aberdeen Group, a leading provider of fact-based research focused on the global technology-driven value chain, issued a “Market Alert” yesterday offering an interesting opinion about the Panorama/Google solution.

Read it hear - http://www.aberdeen.com/launch/report/market_alert/5173-MA-panorama-google-business-intelligence.asp

The world of Software as a Service (SaaS) is becoming increasingly attractive for many businesses as companies look for viable options other than continuously investing money into buying software that needs to be installed and maintained in-house .  Not only is SaaS becoming a viable option, it is also becoming a feasible alternative, in many cases, to traditional application software vendors.  There are numerous reasons that can help explain this phenomenon.  On the IT side of the equation, most CIOs are always on the lookout for ideal application delivery options and the ability to dramatically reduce large amounts of their budgets spent on IT-related administration and support is a very attractive proposition.  Furthermore, the cost of staffing and increasing IT-complexity makes a SaaS-based approach very appealing. On the business side of the equation, there are many cases where buying a service helps reduce the burden from IT when there is a need for a new solution to support the business.  

A great example of a SaaS-based solution is Google Apps.  Google’s solution compels companies to ask themselves why they would install a productivity suite when they could just use it as a set of services.  The uptake on Google Apps has been tremendous and the potential for both improvement and growth can be seen (500,000 companies currently using it worldwide with 3,000 added every day).  Another example of a remarkable SaaS-based solution is Salesforce.com. With one million users, their value proposition is based on the fact that an organization need not purchase and install a cumbersome CRM system that will cost a fortune to maintain.  Rather, use it as a service and keep your headaches to a minimum!

(more…)

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…)