The Good and The Bad of the SAP Business Intelligence Platform

The real driver of any activity is a decision. In terms of business, any company can be thought of as a decision factory. While a product director makes big decisions every week, other employees might make smaller, but more rapid ones. Deciding on a thing requires some knowledge. And, the more you know, the better the decision. In the business sphere, a certain area of technology helps people make the right decisions by supporting them with the right data. This field is called business intelligence or BI.

Business intelligence consists of multiple hardware and software units that serve the same idea: Take data and show it to the right people. While BI won’t tell you if it’s time to walk the dog, or make a marriage proposal, it can be fairly effective for business decisions. The popularity of BI made it a need-to-have thing, which caused growth of the BI solutions market.

There are a lot of BI vendors, and you might stick with recognizable names as QuickSight, or Power BI by Microsoft, if the market is a dark forest for you. But today we’ll speak about less famed vendor SAP BI. This article will provide general information about the SAP BI platform and each separate solution. We’ll also analyze the product as a whole to find its pros and cons and give you some points to take into account.

What is SAP Business Intelligence?

Database and data management solutions

  • Extracting raw data from its sources,
  • Transforming data and storing it in the warehouse, and
  • Giving access to the data for certain groups of people via the end-user interface.

So, in terms of storing and managing data, SAP offers its database and data management products. This set includes 4 products:

SAP HANA and Database is a managed database or database management tools.

Data Warehousing is a warehousing service to collect and manage all corporate data from a single storage.

Enterprise information management is a general tool for data, data quality, and metadata management.

Cybersecurity Governance, Risk, and Compliance are self-explanatory. These are tools that support data security, fraud protection, and risk management.

SAP HANA and Data Warehousing are both warehouse solutions that can be combined with each other. Each solution can be deployed on premise in the cloud or hybridly, combining the benefits of both previous variants. These features come hand-in-hand with the analytical platform and its instruments.

Analytics Solutions

The analytics solutions platform includes the following different products for business intelligence and data analysis:

SAP Analytics Cloud is a Software-as-a-Service (SaaS) business intelligence solution, that provides access to all the corporate analytics from one place. Consider Analytics Cloud as the interface for all BI-related SAP products. Analytics Cloud provides access to all the database solutions and combines different analytical instruments in one place.

Collaborative Enterprise Planning performs the role of a corporate planner, where each department can arrange its actions with others based on data-driven decisions. So this is a Google Calendar on steroids for enterprises that plan strategic and financial decisions.

Predictive Analytics is a tool that allows you to apply machine learning algorithms to predict future trends based on your data. Predictive analytics comes with pre-built algorithms and machine learning model management tools.

SAP Business Intelligence. This product focuses specifically on the tools that concern business analysis, reporting, and visualizations of the given data.

SAP business intelligence is a core product that includes several data access instruments. The instruments within SAP BI can be divided by end-user groups. The first group is business users (or data consumers): a user group that queries data, while not dealing with the inner structure of the database. The second group is data analysts (or the IT department): These users operate within a database to add meta, explore data, and support queries.

From the end-user perspective, let’s break down the instruments included in the SAP BI offer:

SAP BusinessObjects BI Suite is an on-premise BI platform that provides real-time data access. Business users can operate with the data without too much involvement by the IT department, as it is a self-service BI system. BusinessObjects offers various capabilities such as reporting, ad hoc (instant) reports, interactive dashboards, and data visualization.

BusinessObject interface with some visualization examples

Like most BI tools, BusinessObjects has in-built instruments for business users that allows for creating visualizations via a drag-and-drop interface. It can be integrated with many of other products with the help of APIs. Integrations include additional analytical instruments, data sources, or separate applications such as ERP.

SAP Lumira is a tool for creating data visualizations/dashboards. Lumira is a part of BusinessObjects that helps business users and data specialists to work on data analysis. Another important feature is that the results of visualizations can be shared across the organization and in Microsoft Office documents.

SAP Crystal solutions is a BI suite for small to midsize businesses packed with different reporting tools and sharing features. The difference between BusinessObjects and Crystal solutions is in performance numbers. However, user reviews on trustradius.com show that Crystal solutions are used by enterprises not less than small and mid-sized businesses.

As in the case with database solutions, analytical instruments can also be deployed on premise or in the cloud. Depending on the architecture you choose, there is a certain degree of flexibility in choosing the product and deployment options. Having a full picture of SAP’s BI products and how they interact with each other, we’ll move to discussing the platform as a whole.

The Pros of SAP Business Intelligence

The number of SAP BI reviews is overwhelming among enterprises

So, based on the big picture, here are the advantages of using SAP Business Intelligence products.

While not surprising for an old, established company like SAP, it has to be considered a pro. SAP offers all required technological units to leverage a data platform and reporting tools at your company. There are a couple of options for each product, so depending on your needs you may deploy on an actual server or use the cloud. Cloud, on premise, and hybrid deployment options are valid for nearly the entire product line both in Analytics solutions and Database solutions.

Analytics Cloud, in turn, is a good way to centralize your BI related instruments in one place. From this place, you may provide permission-based data access, so that each user will utilize an interface touching only the data required for them to do their job.

Seamless graphical user interface

SAP Business Intelligence provides a bunch of good instruments with intuitive user interface. While it may require some time and skill to learn how to use it (pretty much like any BI tool), SAP user interface happens to be easy to understand. On top of that, with accessing all the instruments from a single web-based interface, it’s much easier to conduct onboarding for your business users.

Sharing functions and Microsoft Office compatibility

Nearly all the reporting or dashboarding instruments on SAP Analytics solutions are armed with sharing functions. This guarantees your employees or executives can easily share valuable insights with each other. When we speak about reporting, these can be reports in the textual format, visual storytelling, or shared access to the constructed dashboards.

It’s also possible to upload the data into Excel or Spreadsheets documents and share across organization the “traditional” way.

But if your primary concern is data security, you can provide rules and permission either via database SQL permissions or data management tools.

Self-service tools availability for wider user audience

SAP BI offers a number of self-service instruments (BusinessObjects, Lumira) that provide a toolset for casual users to cope with data. It doesn’t mean that your BI users won’t need any help, but it will definitely reduce maintenance costs and time spent on reporting-related tasks.

SAP HANA real-time database and performance

Data Source Integrations

Flexibility

While the list of pros looks pretty solid, there are no unicorns. So we’ll pivot to cons now.

The cons of SAP business intelligence

Expensive licensing and overall pricing

Poor customer support and platform administration

Platform heterogeneity

Reporting performance and quality

Server shut down due to heavy loads

What is the best fit for SAP business intelligence?

Good fit for the enterprise. SAP is mostly used by big companies for a number of reasons. The primary focus of the product line is to serve enterprise needs. BusinessObjects and Analytics Cloud are good for distributing content for a large number of consumer groups. The Enterprise Planner and overall list of integrations (namely with SAP’s ERP) suggest good option for corporations with a large amount of data and human resources to supply data with. Add here costs, and a complete service range for creating a BI solution, and you’ll get an optimal solution for the enterprise.

Integration with multiple data sources. SAP offers some good options on integrating with various data sources, mainly because of SAP HANA source agnosticism. The overall list of integrations is massive enough. The last-but-not-least feature is integration with MS Office products, the most used data storage format.

Originally published at AltexSoft tech blog “The Good and The Bad of the SAP Business Intelligence Platform

Being a Technology & Solution Consulting company, AltexSoft co-builds technology products to help companies accelerate growth.