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

  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

  • .NET 9 Preview 3: 'I've Been Waiting 9 Years for This API!'

    Microsoft's third preview of .NET 9 sees a lot of minor tweaks and fixes with no earth-shaking new functionality, but little things can be important to individual developers.

  • Data Anomaly Detection Using a Neural Autoencoder with C#

    Dr. James McCaffrey of Microsoft Research tackles the process of examining a set of source data to find data items that are different in some way from the majority of the source items.

  • What's New for Python, Java in Visual Studio Code

    Microsoft announced March 2024 updates to its Python and Java extensions for Visual Studio Code, the open source-based, cross-platform code editor that has repeatedly been named the No. 1 tool in major development surveys.

Subscribe on YouTube