News

Google Makes Pact with Key Microsoft BI Partner

Google and Panorama Software partner up to develop SaaS tool for Google Docs.


By John K. Waters

Google and Panorama Software partner up to develop SaaS tool for Google Docs.

Search giant Google Inc. is partnering with business intelligence (BI) company Panorama Software Ltd. to develop a Software as a Service (SaaS) analytics, reporting and data visualization tool for Google's free, online applications suite, the two companies have disclosed. The pact is noteworthy because the tool -- Panorama's NovaView BI engine -- is also licensed to Microsoft, which uses it as the basis of its SQL Server Analysis Services.

Panorama Analytics for Google Docs, now in beta, integrates the functionality of the Toronto-based company's flagship NovaView BI suite with the online spreadsheet program. It was released as a free desktop gadget that draws on a set of analysis, reporting, dashboard, visualization (charting) and data-modeling tools to create Panorama Pivot Tables. The resulting pivot table and charting functionality allows users of Google Docs spreadsheets and iGoogle dashboards to analyze their data "at a much more sophisticated and granular level," said Panorama's VP of Marketing and Strategy Oudi Antebi in a prepared statement.

Panorama and Office
Founded in 1993, Panorama pioneered Online Analytical Processing (OLAP) technologies, which provide multidimensional, summarized views of business data used for reporting and analysis (think "data cubes"). Microsoft acquired Panorama's OLAP tech in 1996, and rebranded it as SQL Server Analysis Services.

Panorama and Google have worked together before, establishing a thin layer of integration between NovaView and the online spreadsheets program. But this new collaboration could signal the start of a much deeper level of integration that mirrors Panorama's relationship with Microsoft, Ovum analyst Madan Sheina says. Panorama's strategy of making its lightweight-yet-powerful OLAP engine into a SaaS offering lines up nicely with Google's cloud-applications computing model, he tells RDN, and users shouldn't be surprised to see the company develop SaaS-NovaView integrations with Google's Web analytics and Internet advertising offerings.

Furthermore, the partnership gives Google an opportunity to do more than just drive greater use of its spreadsheet application among consumers, Sheina says. The company likely believes it will help with its efforts to attract small to midsize businesses that use Google Apps and want more enterprise-friendly capabilities.

ISV Opportunities
Panorama is also encouraging ISVs to follow Google's lead and tap into NovaView's APIs to develop customized SaaS BI apps. Sheina suggests that ISVs will see this integration as a new opportunity to write custom report templates, analytics and dashboards to help with corporate decision making and planning.

"The Panorama-Google offering now expands the range of free BI options for customers beyond just open source tools from the likes of Pentaho, JasperSoft and Actuate BIRT," Sheina says. "It could prompt Excel users to re-evaluate the per-set licensing they have invested in Excel as they consider the shifting dynamics of delivering BI from desktop to online [cloud] environments."

Overall, the collaboration is "a move that turns the heat up on Microsoft Excel," he says. But he adds that "Google still has some way to go before it can match Microsoft's BI capabilities in Excel, but this integration is a good start."

About the Author

John K. Waters is the editor in chief of a number of Converge360.com sites, with a focus on high-end development, AI and future tech. He's been writing about cutting-edge technologies and culture of Silicon Valley for more than two decades, and he's written more than a dozen books. He also co-scripted the documentary film Silicon Valley: A 100 Year Renaissance, which aired on PBS.  He can be reached at [email protected].

comments powered by Disqus

Featured

  • Windows Community Toolkit v8.2 Adds Native AOT Support

    Microsoft shipped Windows Community Toolkit v8.2, an incremental update to the open-source collection of helper functions and other resources designed to simplify the development of Windows applications. The main new feature is support for native ahead-of-time (AOT) compilation.

  • New 'Visual Studio Hub' 1-Stop-Shop for GitHub Copilot Resources, More

    Unsurprisingly, GitHub Copilot resources are front-and-center in Microsoft's new Visual Studio Hub, a one-stop-shop for all things concerning your favorite IDE.

  • Mastering Blazor Authentication and Authorization

    At the Visual Studio Live! @ Microsoft HQ developer conference set for August, Rockford Lhotka will explain the ins and outs of authentication across Blazor Server, WebAssembly, and .NET MAUI Hybrid apps, and show how to use identity and claims to customize application behavior through fine-grained authorization.

  • Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard simple techniques, and so evolutionary optimization training is used.

  • Low-Code Report Says AI Will Enhance, Not Replace DIY Dev Tools

    Along with replacing software developers and possibly killing humanity, advanced AI is seen by many as a death knell for the do-it-yourself, low-code/no-code tooling industry, but a new report belies that notion.

Subscribe on YouTube