Business Intelligence B.I. – What is Important?

Digitalisation - Publications By: Dr. Harald Dreher - Mar 30, 2021

Profitieren Sie von 3 Jahrzehnten Erfahrung in IT-Strategie, Digitalisierung, ERP-Beratung und Prozessoptimierung.

Business Intelligence (B.I.), Digitalisation and Digital Transformation are just some of the buzzwords so commonly used today, sometimes it is difficult to interpret and understand both the contents and meanings of such terms.


Person working with Business Intelligence Software

Business Intelligence (B.I.), Digitalisation and Digital Transformation are just some of the buzzwords so commonly used today, sometimes it is difficult to interpret and understand both the contents and meanings of such terms.


What is Business Intelligence?

First of all, Business Intelligence (B.I.) is a term from computer science, or more precisely business informatics, and describes procedures and processes for the systematic analysis of data in a company. Business intelligence is a process that analyses technology-driven data, prepares it and presents it to management in presentations or so-called dashboards as a basis for decision-making.

Business Intelligence usually includes a variety of tools that enable companies to collect data from their I.T. systems or external sources. Queries are defined from requirements for management decisions, data sources are "tapped", so to speak, and processed into reports, dashboards and data visualisations. These data visualisations can include financial information up to transaction data from a value chain. Process key figures, so-called key performance indicators (KPIs) as well as data from competition or market timing evaluations are of course also included.


What Are the Reasons for a B.I. System in Companies?

From our practical experience in consulting on the conception of business intelligence systems and the creation of specifications for BI selection, we repeatedly find that we are basically given 3 reasons for a business intelligence system:

  1. The diversity of IT systems means that a higher-level evaluation of data and facts for management is only possible with a great deal of effort.
  2. Further development of the management information system for extended presentation of information
  3. Organisational challenges to quickly obtain decision templates on a reliable data basis

In many companies, the classic I.T. structures have developed over time into complex, often very different systems. These different corporate I.T. landscapes, from the classic ERP system to CRM systems and logistics software, make it difficult to implement a consistent application for management reporting due to the large number of interfaces.


The range and variety of a B.I. system can consist of paper-based reports and lists created in the classic way from legacy systems. Additions of modern cockpits and the use of modern, specific data analysis to projection and simulation tools round off the range of applications.

We also repeatedly experience the use of specialised evaluation tools on a PC basis at the individual staff level. Often these systems are based on the ideas of trainees and students. Small databases and spreadsheets are often used for this purpose. It goes without saying that it is difficult to check the quality of the calculations and the consistency of the data, especially with larger evaluations of this kind. It is self-evident that this cannot represent the future, and above all that it cannot represent the connections to ERP systems or product life cycle systems. At this point, those responsible in companies immediately steer towards a professional orientation in order to maintain or restore competitiveness.

Management decisions based on data are fundamental advantages that BI systems make possible.
Of course, the quality of the data sources is crucial. The poorer the source data material, the poorer or less reliable the evaluation results, even if they are - as is often the case - nice to look at. Therefore, the qualification of master data or the qualification of business processes is part of every business intelligence initiative or even a simple presentation in a management dashboard. The topic of data quality is a decisive lever whether your investment in a BI tool pays off or not. Most of the time, data sources are also the proprietary ERP systems and/or article databases, whose contents must first be qualified.


What Are the Reasons for this Business Intelligence B.I. Diversity?

  • The reasons for this diversity can also be found in the organic growth of I.T. technology. Various technological trends such as mainframes, medium-sized data technology for small and medium-sized businesses, client server architectures up to today's cloud storage and cloud computing solutions have been incorporated into the investments and I.T. renewals at companies. Often, of course, under time and economic pressure, so that it is not always guaranteed that all legacy data could or should be migrated. This is why we repeatedly experience in companies the complete range of technological developments of an entire generation of managers or technicians.
  • Another reason for this structure, according to our empirical data analyses, is that companies have proven to be very adaptable in the market and that they have developed new business models in the course of their organic growth. Many of our clients have responded not only horizontally (by expanding their product range) but also vertically (by expanding their supply chain and changing their value chain). Challenges from globalisation and the associated competitive pressure have also been used by our clients to buy market share and take over competitors. Especially in such cases, the requirements for a common, comparable and, above all, fast analysis tool are enormous.
  • There are various approaches to analysing data and evaluating it for management decisions. However, most Business Intelligence solutions are based on the use of so-called Online Analotical Processing (OLAP) tools and methods. The more possibilities a BI system offers to isolate and display data from a data pool (also referred to as an OLAP cube), the more possibilities there are for interpreting or presenting correlations from a different perspective.

What is the Motivation for a Business Intelligence Solution?

A clear, functional and technical architecture of the I.T. landscape is a mandatory prerequisite for a B.I. system that can be used throughout the company and obtains the necessary user acceptance.

In a heterogeneously grown I.T. landscape, total costs for Business Intelligence BI are usually higher than in a more homogeneous I.T. landscape, because coordination efforts, interface programming and interface monitoring are lower.

High data quality is the prerequisite for trust in the results of business intelligence software. Here, too, we repeatedly find that heterogeneous I.T. structures tend to be responsible for lower data quality.
However, data quality is of course not solely dependent on the infrastructure and a heterogeneous I.T. landscape, but also on the people involved who either enter, monitor or define this data. We therefore always try to avoid system breaks (i.e. the transfer of data from one system to another I.T. system by people). Likewise, if data is entered manually, it must be checked by the system for semantics and correctness during data entry. This can prevent a system from receiving, processing and reissuing data that was not correct to begin with. Turning incorrect, non-correct data back into correct data in a system is usually a rather costly project.


In our experience, lack of transparency and individual, manual procedures for data evaluation lead to inefficiency and are cost-intensive. That is why we recommend that all our customers set up a set of rules for data quality, a so-called BI governance, in which the procedure for data generation, its further processing and its storage is regulated and thus comprehensible. Once this has been created, it only remains to implement it throughout the company.


What are the reasons for introducing a Business Intelligence B.I. system?

  • Organic growth of the company
  • Evaluations of shop systems
  • Marketing information - comparison of marketing initiatives, tests, comparisons
  • Rapid changes in a company's environment (e.g. digitalisation - digital transformation)
  • Classic comparisons that go beyond the standard evaluations of common ERP systems
  • Acquisition or takeover of other companies to evaluate their data sources

    Excellence in defining the requirements for a business intelligence system is a prerequisite for a successful BI project in order to improve the competitive advantage of one's own company, because reliable data is then available quickly and cost-effectively and can be visualised in an appealing way for the management.


Für Fragen oder Anregungen nutzen Sie den Kontaktbutton und sprechen Sie direkt mit mir. Book an obligation free 30-minute consultation now
We hope you find this publication useful. If you have any further questions on this topic, we look forward to hearing from you." - Dr Harald Dreher