Checklist for business intelligence software
The most important criteria for choosing business intelligence software
What is important when deciding on business intelligence software? The selection process has many participants: IT and the specialist department, management and controlling, administrators, users and report recipients – they all have their own ideas and requirements that the new system must meet. And even if we already have a clear recommendation for you: A systematic vendor comparison is part of the process.
We have compiled the most important criteria for you here, as inspiration for your requirements catalog and at the same time our positioning. You should pay attention to these features and functions when evaluating and comparing business intelligence software. And when you have acquired a taste for it, the best thing to do is to see for yourself live what DeltaMaster can do for you!
1. Intelligent dashboards
Good business intelligence software should present the company’s status in such a way that users can grasp it without having to search through individual reports. DeltaMaster from Bissantz solves this with a color-coded dashboard: Each analysis and reporting application can be assigned its own key metric—such as order intake, contribution margin, pipeline, or closing rate. This way, you can see at a glance which topics you should focus on first. DeltaMaster even takes care of the parameterization, configuration, and layout for you. Because visualization in business intelligence should be primarily about signaling and prioritization.
2. Standard reporting
BI software should be able to generate standard reports for performance monitoring, variance analysis, and forecasting without assistance from IT or external service providers. With DeltaMaster from Bissantz, start wizards handle this task: Using drag-and-drop functions, you simply choose the desired methods to measure performance – for example, gross margin calculations, P&L, or input-output calculations in short- and long-term views. The wizard will automatically integrate all necessary structures to dynamically calculate cumulations and variances to the budget or previous year into your data model. Many other so-called BI tools can’t even do that manually, let alone automatically.
3. Integrated forecast
Modern BI software should not only analyze past data but also translate key metrics into forecasts and scenarios. To this end, Bissantz’s DeltaMaster projects all key metrics into the future with a single click and processes them into scenario simulations. To do this, DeltaMaster uses sophisticated AI methods as well as, optionally, simple, robust techniques such as exponential smoothing and linear regression, values calculated by external modules, or methods developed specifically for you by our forecasting specialists. You can create your own forecasting models using simple natural-language commands or through dialogs with the powerful MDX query language.
4. Open data storage
Good business intelligence software does not maintain its own “proprietary” copy of your data, but rather accesses your existing data warehouse system directly—this preserves your data sovereignty and avoids duplicate data maintenance. DeltaMaster from Bissantz does exactly that: For enterprise reporting and KPI monitoring, you use the interfaces to the usual data warehouse systems of the major vendors. Unlike other products, DeltaMaster does not use proprietary data storage. Many of our clients value this independency. We support the following databases: Microsoft SQL Server/ Analysis Services, SAP BW/Netweaver BI/HANA, IBM Cognos TM1, Oracle Essbase, Infor.
5. Flexibility
BI software should enable customized business applications for various departments without becoming a one-off solution that must be readjusted with every update. With DeltaMaster from Bissantz, you can design custom applications for sales, purchasing, production, logistics, finance, marketing, sales, etc. Nevertheless, DeltaMaster is a standard product. It is delivered to all customers in the same form and remains compatible with all existing customer applications during updates. Customer requests are generalized and abstracted in such a way that they are available as improvements for the entire customer base.
6. Collaboration
Good business intelligence software should make it easy for teams to share insights—from sending reports to commenting on individual data points. DeltaMaster from Bissantz offers, among other features, simple email report distribution, automated text messages to mobile phones, and commenting functions down to the individual data point. A repository manages the division of labor between report editors and report recipients.
7. Role-based access
Different roles within the company should be able to have different user and access rights. DeltaMaster’s role-based concept addresses both user operations and data access: Boards of directors and supervisory boards love DeltaMaster for its unparalleled clear and concise templates for reports and performance monitoring. CEOs appreciate that they can immediately grasp the most important insights and recommendations for action and, if necessary, drill down into details along predefined or automatically generated paths. Managers value the flexible filtering and search functions. And controllers appreciate that they can go further and deeper wherever they wish. This supports the seamless transition between roles and tasks that is typical for many companies. The DeltaMaster repository also ensures that data and roles align.
8. Ad hoc analysis
Good BI software should allow for creative, experimental ad-hoc analyses without requiring every analysis to be defined in advance in the data model. This includes slice-and-dice or pivoting functions to compare and analyze customers, regions, products, or other attributes on any level. DeltaMaster also lets you group and classify objects by attributes dynamically or with fixed thresholds – regardless of their values. Wizards help you calculate quotients, sums, variances, or multivariate statistical values. Using drag-and-drop functions, you can visualize the results with circle, bar, or column elements, or with the particularly appealing typographically scaled Bissantz‘Numbers. You can even apply budget-actual variances, or deviations from previous years, and other complex calculations to existing data with just a click of a button.
9. Business methods
Business intelligence software should already include established business analysis methods, rather than requiring them to be recreated from scratch. DeltaMaster by Bissantz comes with a selection of proven methods. These include rankings, time series, portfolio, concentration, map, location, and cross-table analyses, early warning signals, and drill-through functions to individual postings. AI features also enable deviation analyses that extend into the semantic context. These methods require no parametrization and are designed to work on every data model.
10. Mobility
Good BI software should allow reports to be viewed on smartphones, tablets, and desktops, and should present them in different formats rather than forcing a single view for all devices. DeltaApp flexibly accommodates the unique features of modern output media. Most people, for example, view mobile devices in portrait mode but standard computer screens in landscape mode. Both the design templates and functional concepts in DeltaMaster take this into account. The reports of DeltaMaster look just as impressive on the big screens of laptops, desktops, kiosk systems, and business control centers as the smaller displays of smartphones and tablets. You can centrally store data and applications in the cloud and use them both online or offline.
11. AI and data mining
The potential of AI should not go untapped. DeltaMaster combines proven data mining techniques with the capabilities of modern artificial intelligence. Business users can analyze known issues as well as discover hidden patterns, correlations, and anomalies without having to define them in advance. The methods are easy to configure and deliver results that include clear, plain-language explanations that can be easily presented to management. The methods include multidimensional rankings, component comparisons, shopping basket analyses, and Bayesian methods. In addition, DeltaMaster provides access to modern AI methods—for example, through the integration of large language models, AI assistants, and MCP servers.
12. Self-service BI
Self-service BI is virtually indispensable for a smooth workflow. DeltaMaster supports spontaneous self-service analysis – even on new pools of data. Once you have imported your Excel, Access, or other relational sources, you can get right to work. During the modeling process, DeltaMaster automatically suggests measures and dimensions. You can build hierarchical structures with just a few movements of the mouse. Best of all, users don’t require IT support or special technical skills. In no time, they can access their data in a clean, structured model for further analysis. By using artificial intelligence, even unstructured contextual information can be incorporated into analyses.
13. Guided analytics
Good business intelligence software guides users toward the right analysis method and visualization, rather than requiring in-depth knowledge of statistics. DeltaMaster automatically enters the suitable charts in your evaluations and suggests the correct graphical visualization for any tables. An analysis wizard examines cross tables for outliers using cluster analysis and other methods. To apply more complex methods such as distribution or regression analysis, you only need a few prior instructions. No programming is necessary.
14. Signaling
User-friendly BI software conveys key messages unambiguously even at a glance—traditional, ambiguous traffic-light colors are often insufficient for this purpose. That is why the signal concept developed by Bissantz uses physiologically appealing colors and works without parameters: DeltaMaster colors all values and graphic elements in shades of blue and red – depending on if they have a positive or negative effect on a specific KPI or your business as a whole. It applies this same principle to the program interface, background of the screen, report lists, headlines, and other elements. This communicates a clear message that you cannot miss – even with just a quick glance at your desk or from afar on a kiosk system or business control center. What’s more, DeltaMaster always lists the values that are primarily responsible for the respective coloring.
15. Analysis paths
When selecting software, make sure that root cause analysis is as intuitive as possible. Starting from the KPIs of your dashboard, DeltaMaster will guide you to those areas where there is room for improvement – whether in your product range, organization, suppliers, clients, or cost centers. DeltaMaster applies award-winning methods, for example, that document a chain of underlying causes. You can define typical paths as a predefined succession of clicks and keep sight of both the starting point and path travelled.
16. statistics
For specialized statistical analyses—such as those of campaigns, website traffic data, quality metrics, or customer surveys—business intelligence software should include its own functions rather than requiring separate statistical software. DeltaMaster from Bissantz includes the necessary statistical functions for this purpose: Using wizards you can create univariate and multivariate KPIs. Box plots help visualize prices and other ranges. DeltaMaster draws trend arrows and concentration curves – correctly, neatly, and fully automatically. Separate modules for distribution and regression analyses are also available.
17. Easy handling
Good business intelligence software should be easy to use without a lengthy training period—ideally via drag-and-drop or voice commands, rather than forcing users to navigate through complex menus. With DeltaMaster, many functions can be controlled using AI-based voice commands, and all key actions can be performed with simple, intuitive mouse movements. Menu texts are phrased in clear language, and icons are used sparingly. For settings such as coloring, scaling, labeling, and layout, DeltaMaster uses tried-and-tested default settings, so you don’t need to configure them manually. At all application levels, DeltaMaster requires far fewer buttons and clicks than other BI products.
18. Visual analytics
Even complex situations should be easy to break down and analyze. The patented Hyperbrowser of DeltaMaster sheds light on complex structures – quickly and securely. You simply drag and drop a measure into the data model, and DeltaMaster will color code it to show if it has a positive or negative effect on the result. This instantly reveals compensating effects hidden in your data. The Graphical Tables in DeltaMaster make data-dense reports understandable at a glance. Interactive in-cell charts such as zoomable sparklines deliver more details as they grow larger.
19. Planning
Good BI software should integrate planning, analysis, and reporting into a single data model, rather than requiring separate tools for each. DeltaMaster’s planning features close this loop. The software supports top-down and bottom-up data entry on cell and aggregated levels as well as fixed values and multi-level cell comments. Intelligent cells „know“ how to allocate entries. You can instantly integrate multidimensional, real-time analyses in the planning application to test the plausibility during the data-entry process and gauge the effects on the results. You can also display the planning status of different organizational units in the dashboard.
20. Report distribution
Don’t underestimate the efficiency gains that come from automated and time-controlled report distribution. DeltaMaster automatically generates personalized reports – even for hundreds of users. Based on templates that you have generated, DeltaMaster reloads the data, applies colors and warning signals, adapts reports to user-specific criteria, and takes care of exporting, emailing, or storing the file. You can trigger this process with a click of a button, at a set time (e.g. daily, weekly, monthly), or by periodically evaluating conditions in order to respond to events (e.g. exception reporting). In addition to reports, concise summaries can also be distributed in the same way.
21. Portal
Business intelligence software should be integrated into a centralized login and authorization system.You can display all DeltaMaster applications centrally in a separate, automatically configured portal or integrate them in leading portal systems such as Microsoft SharePoint. In combination with DeltaMaster Repository, the portal applies the valid permissions and roles for individual users. Singlesign-on options are supported.
22. Cloud BI
Modern BI software should be able to run either on-premises or in the cloud. DeltaMaster in the Microsoft Azure cloud makes Business Intelligence solutions even easier and quicker for you to access. In a very short time, you can test and directly use workshop results, studies and proofs of concept live in DeltaMaster. In the pilot phase, you can access your DeltaMaster reports on the web (browser) and in the app from the first day. There are no server components for you to configure. Costs are transparent and easy to calculate.
23. Kiosk systems and
business control centers
Make sure that information can be made available in the right place. DeltaMaster makes the information in your company accessible and instantly usable without any setup times and little to no interaction. We offer solutions for kiosk systems, monitor walls, and business control centers. Mobile users do not need to take their devices with them – there are devices ready where you need them. You can also integrate images, films, Web sites, and video streams as part of a multimedia corporate communications concept.
24. Office integration
Good business intelligence software should not lock reports away in a closed system. You can export DeltaMaster analyses and reports to HTML, PDF, Word, Excel, and PowerPoint files. For writing-intensive reports with custom designs, DeltaMaster also offers a live integration in Word. With this add-in, you can transfer reports and report elements down to individual cells and update them dynamically. This functionality is also available for
PowerPoint.
25. Innovation
A BI software provider should reinforce its innovativeness through its own research. In cooperation with Germany’s largest corporations and midsize companies, we conduct research in a variety of fields including executive management, employee motivation, perception/visualization, and data analysis/forecasting. These insights flow into best practice applications that serve as prototypes for new solutions. To ensure that our R&D profits from scientific findings, we conduct our own basic research and participate in cooperative research projects. Our analytic and visualization methods have received multiple patents, the innovation award from the German Informatics Society (GI) as well as several design awards.
26. Information design
Good business intelligence software designs its layout, colors, and structure according to clear principles. DeltaMaster is a pioneer in visualization and design. Sparklines, Graphical Tables, and performance-based color coding are just a few examples of the visual standards that DeltaMaster sets. We synchronize our layout, color, structures, and warning concepts with scientific laws of perception that apply to the brain, eyes, and ears – regardless of personal preferences and customs. This ensures that even new users quickly feel comfortable working with DeltaMaster reports.
27. Product design from
Studio F. A. Porsche
Presentation matters. We have perfected the reports and analyses in DeltaMaster in cooperation with the experts at Studio F. A. Porsche. The results are a high-resolution feast for your eyes. DeltaMaster always complements the available data and presents a dramatic, intuitive overview or precise detail.
28. Prebuilt functionality
65 to 80 percent of project steps are identical in all companies. That’s why we offer prebuilt functionality to simplify, unify, and automate these steps. Our ETL tools are designed for end users and even used by large clients.
29. Customer satisfaction
Look out for real user experiences. Studies such as the BI Survey and the Planning Survey from BARC regularly confirm that our clients are pleased with our product, service, and support. This is primarily due to the fact that our consultants answer many of our clients’ questions directly. They aren’t just fluent in BI, they are native speakers who offer their experience to tackle all your business, technical, and project-specific challenges. When you call our hotline, you are connected to our office – and not some call center
30. Consulting
A professional BI provider offers you comprehensive support. According to your needs, our excellent team of consultants can help you with the design and operation of a BI solution, continuous and automated data management, the integration of AI into controlling, or the implementation and use of specific platforms and technologies such as Microsoft Fabric. By the way, we invest a full day each week in training our consultants.
31. Partners
Make sure BI providers have a strong network so they can also serve your specific niche. To support special application topics, we work with certified partners who are tightly integrated with our development and shine in their fields of expertise. The offerings of our partners range from pre-configured DeltaMaster solutions that support specific industries or processes to long-term operations.
32. Awards and prizes
Our clients use DeltaMaster to gear up for the fierce competition in their markets. Some have won prizes for their innovative applications – for example, the Best Practice Award of the BARC Institute or the Service Management Prize the German Customer Service Association (KVD). The German Informatics Society (GI) has also honored us with their Innovation Prize. DeltaMaster also receives top accolades from
our users as well. In the annual BI Survey conducted by BARC, DeltaMaster regularly earns first place rankings in a variety of categories.
33. Early recognition and variance radars
You cannot put counteractions into effect overnight. That’s why the analytic methods of DeltaMaster examine all changes in your organization down to their root causes. All reports contain variance signals that place each value in relation to your expectations, forecast, or budget. After all, you can only identify where you need to make changes, if they can work, or if you need to plan again from scratch if you have suitable comparisons. DeltaMaster tracks down the causes – even those buried deep in your data. This helps you see if specific product and customer attributes are the reasons behind your variances without losing sight of the big picture.
FAQ: Frequently Asked Questions
Key information at a glance, answered concisely and clearly
The criteria you should prioritize when selecting BI software depend on your specific situation and objectives. However, it’s safe to say that integration with your existing data sources, ease of use for your business users, and security and access control policies are generally more important than additional features such as AI.
For small and medium-sized enterprises (SMEs), the most important factors in business intelligence software often are a quick implementation without a long IT lead time, intuitive operation for business users without programming knowledge, and a pricing model that scales with the company’s growth. DeltaMaster from Bissantz imports Excel and Access files directly and requires neither dedicated IT resources nor specialized technical knowledge to get started. As the company grows, additional departments and analyses can be added without having to rebuild the existing structure.
When selecting business intelligence software, a large, international corporation should focus particularly on scalability across multiple subsidiaries, currency conversion, centralized access management, and adherence to group-wide compliance and security requirements. DeltaMaster from Bissantz offers the appropriate features and concepts for this purpose.
Switching from Excel analyses to business intelligence software is usually worthwhile when reports are compiled manually, the risk of errors increases, or multiple people need to access the same, up-to-date data. DeltaMaster from Bissantz automates these tasks, thereby significantly reducing the manual maintenance effort.