Introduction

Unclear use and understanding of the term business intelligence (BI) and analytics have made it difficult to grasp the scope of disciplines and software categories that fall within the realm of business intelligence tools. This article offers a pragmatic business intelligence and analytics definition and clarifies the topics business intelligence and analytics covers with insights into the relevant tool types. 

To help improve your understanding of this complex subject, this article addresses the following points:

What is BI?

Business intelligence and analytics is a key element in a modern and successful business strategy. The right business intelligence tools enable companies to retrieve more relevant data, gain better insights, enhance the decision-making process and therefore create a competitive advantage.  

Business intelligence applications specifically cover the collection, processing and provision of data for controlling, managing and planning corporate performance. To help define business intelligence, it is necessary to understand at what steps of managing decisions it comes in. The visualization below shows the management cycle and the core of traditional business intelligence steps that will be elaborated upon in this article. 

Business Intelligence Functionalities

Figure 1: Business intelligence offers functions to support the management cycle in organizations

To realize the strategic direction of an enterprise, different business intelligence tools offer functionality for reporting, dashboarding and analysis as well as planning, budgeting and simulation.

Don‘t miss out – Get the latest BI product insights, research, surveys and more!

Business intelligence and analytics span range of application types 

All BI solutions help to generate, prepare, display and deliver decision-relevant information to users. The level of skills required to use an application and the degree of flexibility for the user vary between the differet types of business intelligence tools. Figure 2 displays typical BI application types along these two dimensions.

Business Intelligence Application Types

Figure 2: Overview of typical functional areas of business intelligence software tools

Dashboards and analytical applications

Dashboards and analytical applications provide a quick overview of what is going on in the enterprise. They are typically characterized by a high level of aggregation of key figures that allow the user to monitor the performance of the business or its main areas at a glance.

In terms of presentation, this format favors a dynamic overview and shows KPIs in easy-to-understand graphics. For the user, the benefit comes from this easily digestible format from which a broad understanding of how the business is doing with regard to the relevant KPIs can be gained. The interface usually comes with basic drill, search and filter functionality that guides the viewer through their analyses, what they are seeing and how these numbers came about.

Business Intelligence Dashboard

Figure 3: Example of a simple and graphics-focused dashboard

The simplicity and accessibility for all levels of knowledge and data literacy make this type of application a popular choice for monitoring important business processes. While dashboards and, for the same reason, standard reports used to be built by dedicated experts, business users increasingly build them in a self-service manner powered by increasingly powerful and easy-to-use tools.

Standard reports

Like dashboards, standard or formatted reports inform the reader about the status of the enterprise with the help of specific KPIs. The difference lies in how the information is communicated and its density. Standard reports present information in a predefined format, making it easy to compare results over time. They often contain detailed information that does not fit the one-screen approach of dashboards.

Additionally, reports are typically page-oriented and often compiled into report books. They can be distributed based on events or schedules or they may be retrieved on demand. Standard reports are supplied in numerous ways: through interactive portals, via mobile devices or email as PDF, Excel or other formats.

The interaction level for the recipients depends on the nature of the report (type) as they can be static or dynamic. Static reports are often used to conveniently distribute information to many users who may not even have direct access to the BI tool. Dynamic reports allow filtering and aggregations that give users greater control to focus on their distinct information needs.

In principle, reporting tools are a popular choice to satisfy consistent and recurring information needs. As such, they still comprise the backbone of information distribution in many organizations as laid out in the recent BARC study on “The Future of Reporting”.

Business Intelligence Report

Figure 4: Example interface for a digital report

Ad hoc reports and analyses

While recurring and predictable information needs are sufficiently covered by standard reports and dashboards, there are situations that warrant a specific investigation and interest. For this, ad hoc reports and analyses play a critical role. In a nutshell, they are created by business users to quickly gather required information instead of providing it in a highly formatted and standardized way – here speed trumps perfection.

The flexibility of the queries fired is facilitated by a well-defined and curated semantic layer that shields users from underlying technology and offers the available objects in an accessible form. Such an abstraction layer is vital for ad hoc reporting tools to remain easy to use and is key in helping users combine data efficiently. Ad hoc reports typically allow one query per report and offer limited formatting options to speed up content creation.

Querying data becomes more accessible through natural language queries (NLQ) where the user can ask questions in natural language that are then translated into queries.

Business Intelligence Ad Hoc Analysis

Figure 5: Example of an ad hoc analysis in a tool

Want to rate your BI and analytics software?

Share your experience in the world‘s largest and most comprehensive survey of BI software users

Take part in The BI & Analytics Survey

Analyses

In comparison to ad hoc reports, analysis tools provide a more flexible and direct interaction with data and access to the data model. The goal is to generate insights by detecting patterns, deviations or clusters.

In that sense, analysis here describes the flexible navigation within data to answer urgent business questions. Popular types of analysis fall into three categories: dimensional (OLAP), visual and set-oriented analysis. The most popular ones among them are dimensional (OLAP) and visual analysis.

Dimensional analysis allows business users to quickly retrieve results from highly structured sources (cubes) without requiring deep technical expertise. Stable data models, which are common in finance or planning, are an ideal fit for that technology.

Visual analysis leverages the capacity of the human brain to spot patterns and trends quickly. Typically, visual analysis is a good choice for analyzing data with changing structure and multiple attributes such as customer data, not least because the data preparation features are often bundled in the relevant tools.

The increasing ease of use driven by augmented analytics used to guide analyses makes analyzing data simpler and yet more powerful (e.g., by making more complicated statistical methods available to business users or pointing them to abnormalities they were not even looking for). Therefore, more and more users rely on leading-edge tools to support management decisions with new insights.

Business Intelligence Analysis Interface

Figure 6: Example of an analysis user interface