Buyer's Guide: Business Intelligence in the Cloud

by Drew Robb

While there is plenty of hype about business intelligence in the cloud, even vendors encourage companies to take a measured approach to deploying it.

Business intelligence (BI) vendors are involved in a headlong rush to provide their software in the cloud. The drivers include anywhere access, improved scalability, reduced implementation time and lower upfront costs. But users have concerns about vendor lock-in, performance issues, security and even software ownership.

So should companies dump their existing on-premise BI software and move to the cloud? We asked some experts to give users sensible advice, as well as an overview of the market. In addition, we picked a few interesting cloud BI offerings from literally scores now on the market.

“Most BI vendors are incorporating cloud offerings in 2011/2012, so a list loses its value,” said Barry Cousins, senior research snalyst at Info-Tech Research Group. “Large vendors have taken notice of Birst because of its flexible ‘On-Premises/On-Demand’ model that allows customers to easily shift components of the solution across the firewall. Also, the big vendors are trying to emulate QlikView’s flexible data access for end users, ease of use, and HTML5-based mobile UI (user interface).”

Flexibility, he believes, is the key to cloud success. That means making it easy to transition parts of the business intelligence solution between on-premises and on-demand, in either direction at any time, backed up by friction-free licensing models. In addition, users want less rigid data models, allowing the user to blend structured corporate data with external unstructured data.

He doesn’t advise companies to leap into the cloud with the expectation that they will save lots of time and money right away. He advises them to get ready for a financial outlay and to commit time to the project in order to do it right.

“Organizations should not make this decision simply to avoid an overburdened IT department because the governance and process employed by IT is critical to the result,” Cousins said.  “Instead, view cloud-based BI as a potential improvement to a purely on-premises model.”

Among the keys to success, he added, are thorough preparation in terms of resolving data quality issues, proper training of personnel and a good plan to be able to distribute business intelligence throughout the end user’s job experience with integration into CRM/ERP systems, rich email distribution and mobile device support.

The addition of cloud-based platform components creates added complexity for operations, Cousins said. Thus, decision makers should demand a rigorous design and testing period before go-live.

What sorts of questions should users ask of incumbent vendors if they are looking at an upgrade of an aging system? Cousins advised users to look beyond features and cost (though they remain important) and begin by asking for case studies from customers implementing a similar architecture.

“Focus on the architectural flexibility your organization may need over the coming years,” he said.

Here's a short list of business intelligence vendors with cloud offerings:


QlikTech is one of the vendors Cousins called out as an innovator in cloud business intelligence. Donald Farmer, QlikTech’s vice president of Product Management, said many providers of cloud-based applications are adding monitoring, reporting and analysis to their services and using its QlikView product to drive the analytics of their hosted services.

“QlikView is regularly deployed on small departmental servers and managed by the department's informal IT ‘whiz kid’ rather than a formalized IT role,” said Farmer. “But these small on-premises deployments have the advantage that they can grow easily to a full IT-managed solution.”

Vendor hype to the contrary, he added that cloud-based business intelligence is developing slowly. The reason: Business intelligence adds the most value when it integrates data from multiple, complex systems and gives users the opportunity to explore a complete view of the business. This is difficult to do on the cloud, because it remains a challenge to bring all the data together from many systems, integrate it, cleanse it, match it and conform it.

“Real BI is growing slowly on the cloud and cloud solutions are very limited,” said Farmer.

One of his pet peeves is solutions that call for the management of additional servers. He urges users to look for solutions with excellent manageability and a small footprint. When selecting products, the best approach is to follow the data.

“Think first about your data sources and assess how much pre-processing of data is needed before it is ready for analysis,” he said. “Typically this may be 70 to 80 percent of the entire effort. If this must happen on premises, ask yourself how much you will really save - either financially or operationally - hosting the final 20 percent on the cloud?”


Jaspersoft carved out a reputation as one of the early adopters of open source technology for business intelligence. Now it claims it offers the industry's first business intelligence for platform-as-a-service (PaaS).

“We are working with all the major PaaS providers to ensure our BI platform is available within these new cloud-based development and deployment environments,” said Karl Van den Berg, vice president of Product and Alliances, Jaspersoft.

Partnerships include Red Hat, VMware’s CloudFoundry PaaS environment and others. Van den Berg calls attention to the fine points when selecting cloud business intelligence – understanding the differences between software-as-a-service (SaaS) BI, BI for SaaS and BI for PaaS.

For example, SaaS business intelligence, which he defines as hosting a business intelligence platform or application in the cloud and delivering business user functionality on demand, requires significant customization and users with requisite technical skills and a business problem that allows cloud-based consumption to be a better alternative. Business intelligence for SaaS, on the other hand, requires building BI functionality into a SaaS-based application for the purpose of delivering specific, data-driven functionality within that application.

Business intelligence for PaaS is a set of BI components, built from web-based and open standards, available as a set of reporting and analytic technologies that enable a developer to quickly assemble a modern, data-driven application and then deploy and manage it in the cloud. This approach, he said, creates greater agility, reduces infrastructure and start-up costs and delivers faster time-to-value through a better user experience.

Jaspersoft offers all three flavors.

Van den Berg advises users not to try and do too much, too soon. Think big, but start small. Starting small means beginning with a core use case or set of users that will benefit most from cloud business intelligence and then growing the deployment over time to more users and more use cases as needs evolve. Thinking big means you need to have the end goal of a broader deployment in mind. Avoid selecting a cloud business intelligence offering that is not going to scale, for example, in terms of cost or in terms of the variety of data sources (like NoSQL) that you may have to support in the future.

“The cloud has changed the game for BI. The business/license model and architecture are very different,” said Van den Berg. “An incumbent is often not best suited for the cloud BI use case. If you have evaluated carefully and believe your current vendor is a fit, you should check if their cloud BI offering is with its on-premises software or if an easy upgrade path exists.”


Tibco is another of business intelligence upstart that is gaining quite a following. Tibco Silver Spotfire is the cloud/SaaS offering alternative to the Tibco Spotfire on-premise enterprise business intelligence solution. The idea is to put enterprise-class business analytics in the hands of individuals and small companies at an affordable price.

“With Spotfire, no data modeling is required to create interactive dashboards and publish them securely to the web for interactive viewing by browser or iPad,” said Brendan Gibson, Tibco's senior product manager, Spotfire. “Spotfire has tools for combining data sources and making sense of it all.”

He cautions users not to be fooled by what he termed “20th century reporting technologies” that have been re-jiggered for a SaaS delivery model. 

“Competitive businesses won’t beat their competition with a BI strategy that relies on reports and dashboards alone,” Gibson said. “The state-of-the-art is a strong mobility and web availability story, contextual collaboration capabilities as well as universal adaptability – i.e., the ability to support a broad base of business and technical users.”


As well as showcasing a few of the up-and-comers, no guide would be complete without including one of the major players. IBM is being cited as a leading business intelligence vendor that is furthest along in providing the latest generation of cloud technologies to facilitate cloud-based business intelligence and analytics. Its InfoSphere Big Insights on the Cloud, for instance, is a Hadoop-based tool.

“Apache Hadoop is one of the hottest topics in enterprise data management today,” said Leon Katsnelson, IBM director of Big Data Cloud Initiatives. “IBM InfoSphere BigInsights is built upon Hadoop's open source software framework, and is available both on-premise and in the cloud.”

IBM’s new Hadoop-based analytics software on the cloud is said to be deployable within 30 minutes. InfoSphere BigInsights merges the analysis of traditional structured data found in databases along with unstructured data. As it is cloud-based, those performing analyses don’t need Hadoop programming skills.

This product is available in basic and enterprise editions. It can be used for public, private and hybrid cloud deployments. Clients already using this IBM technology include Hertz, Beacon Institute, KTH Royal Institute of Technology and Danish energy company Vestas Wind Systems. The latter company, for example, used it to analyze petabytes of weather data to improve wind turbine placement.

Cloud BI is Coming

A long list of young gun vendors is giving the established business intelligence players a run for their money when it comes to cloud functionality. Whoever wins the race, one thing is clear: Cloud business intelligence is coming.

According to a recent Gartner survey, one third of IT managers are planning ­to use a SaaS-based business intelligence offering soon and 17 percent have already dumped (or are about to) their on-premise business intelligence in favor of cloud BI.

Drew Robb is a freelance writer specializing in technology and engineering. Currently living in California, he is originally from Scotland, where he received a degree in geology and geography from the University of Strathclyde. He is the author of Server Disk Management in a Windows Environment (CRC Press).

  This article was originally published on Thursday Mar 22nd 2012
Mobile Site | Full Site