Abstract
Against the background of increasing need for data analysis in companies, which is carried out not only by data scientists, but also by end users with average IT knowledge, the question arises as to suitable BI systems that integrate machine learning functionality (ML) for data evaluation, but meet the requirements of an end user target group. This paper starts from the Gartner Magic Quadrant BI systems, which provide ML functionality in a free test license. For the five BI tools TIBCO Cloud Spotfire, SAP Analytics Cloud, Qlik Sense, Tableau and the Open Source tool RapidMiner, which is used as a neutral reference, the comparison is based on the ML workflow with the phases data acquisition and cleansing as well as model training, test, use and monitoring and analyzes the respective ML functionality offered. There are differences in the range of the spectrum of covered ML algorithm types classification, regression, clustering and association analysis, in the number of ML individual algorithms offered in each area and in the level of detail of the possible fine-tuning for the algorithms. The range extends from tools that are aimed at laymen without prior knowledge in data analysis and instead only contain a less transparent AI interface, over BI systems with ML algorithms that at least reveal the algorithm type, but hide the concrete algorithm and refrain from offering settings in order to address laymen with a basic understanding of data analysis, but little prior knowledge, to BI tools that boast a wide range of ML algorithms and a wealth of settings for fine-tuning and are therefore suitable for experts with sound specialist knowledge in the field of data science. In the end, fine-grained settings allow for more complex analyses, while BI tools with a high degree of automation and machine learning at the push of a button are more suitable for solving simple problems. It becomes clear that there is no such thing as a universally applicable BI system. Demands for detailed control options for the ML algorithms are diametrically opposed to the wide applicability by many users. Overall, the selection decision in the company must take into account the target user group and their prior knowledge in order to select the appropriate BI system.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Vorhies W (2016) Data scientists automated and unemployed by 2025!, 13. April 2016. https://www.datasciencecentral.com/profiles/blogs/data-scientists-automated-and-unemployed-by-2025. Accessed: 15. Sept 2022
IDC (2018) The digitization of the dorld from ddge to dore, November 2018. https://www.seagate.com/files/www-content/our-story/trends/files/idc-seagate-dataage-whitepaper.pdf. Accessed: 15. Sept 2022
Scarff B (2018) So beeinflusst machine learning die business intelligence, 02. Febr 2018. https://www.bigdata-insider.de/so-beeinflusst-machine-learning-die-business-intelligence-a-676786/. Accessed: 15. Sept 2022
Heinen B (2019) 6 GrĂ¼nde fĂ¼r das Scheitern von Data-Science-Projekten, 16. Sept 2019. https://www.inform-software.de/blog/post/6-gruende-fuer-das-scheitern-von-data-science-projekten. Zugegriffen: 15. Sept 2022
Hebben H (2019) Dieses potenzial haben citizen data scientists, bigdata-insider, 19. June 2019. https://www.bigdata-insider.de/dieses-potenzial-haben-citizen-data-scientists-a-829910/. Accessed: 15. Sept 2022
Engelmann J (2018) Datenanalysen auf Knopfdruck: Mit Augmented Analytics wirst auch Du Analytics-Profi, 30. May 2018. https://www.konversionskraft.de/data-analytics/datenanalysen-auf-knopfdruck-mit-augmented-analytics-wirst-auch-du-analytics-profi.html. Accessed: 15. Sept 2022
Richardson J et al (2020) Gartner, magic quadrant for analytics and business intelligence platforms, 11. Febr 2020. https://www.gartner.com/doc/reprints?id=1-1XYUYQ3I&ct=191219&st=sb. Accessed: 14. Dec 2020
Microsoft Corporation (2022) MLOps with Azure ML – code samples, 27. August 2022. https://docs.microsoft.com/en-us/azure/machine-learning/concept-model-management-and-deployment. Accessed: 15. Sept 2022
Lanquillon C (2019) GrundzĂ¼ge des maschinellen Lernens. In: Schacht S, Lanquillon C (Hrsg) Blockchain und maschinelles Lernen: wie das maschinelle Lernen und die Distributed-Ledger-Technologie voneinander profitieren. Springer, Berlin, S 89–142
Schulte B (2019) Machine-Learning-Modelle bewerten – die Crux mit der Metrik, 02. July 2019. https://blog.codecentric.de/2019/07/machine-learning-modelle-bewerten-die-crux-mit-der-metrik/. Zugegriffen: 15. Sept 2022
Patruno L (2020) Why is it important to monitor machine learning models? – ML in production. https://mlinproduction.com/why-is-it-important-to-monitor-machine-learning-models/. Accessed: 15. Sept 2022
Panizzo DS (2017) Wine quality, 29. Oct 2017. https://www.kaggle.com/danielpanizzo/wine-quality. Accessed: 15. Sept 2022
Brabban P (2019) Daily minimum temperatures in Melbourne, 23. March 2019. https://www.kaggle.com/paulbrabban/daily-minimum-temperatures-in-melbourne. Accessed: 15. Sept 2022
Lexikon S (2020) Root mean square error (RMSE; dt.: Wurzel der mittleren Fehlerquadratsumme) – statista definition. https://de.statista.com/statistik/lexikon/definition/303/root_mean_square_error/. Accessed: 15. Sept 2022
SAP SE (2022) Horizontweiter MAPE. https://help.sap.com/viewer/41d1a6d4e7574e32b815f1cc87c00f42/3.1/de-DE/4ff1d39db49d4e69a22d1d58eb0cd28d.html. Accessed: 15. Sept 2022
Litzel N (2018) Was ist augmented intelligence? 13. July 2018. https://www.bigdata-insider.de/was-ist-augmented-intelligence-a-733360/. Accessed: 15. Sept 2022
QlikTech GmbH (2022) Qlik sense datenanalyse-plattform. https://www.qlik.com/de-de/products/qlik-sense. Accessed: 15. Sept 2022
QlikTech GmbH (2022) Qlik sense business free trial. https://www.qlik.com/de-de/trial/qlik-sense-business. Accessed: 15. Sept 2022
Kirste M (2019) Augmented Intelligence – wie Menschen mit KI zusammen arbeiten. In: Wittpahl V (ed) KĂ¼nstliche Intelligenz: Technologie | Anwendung | Gesellschaft. Springer, Berlin, pp 58–71
TIBCO Spotfire Inc (2022) Using an evaluation summary. https://www.tibco.com/. Accessed: 15. Sept 2022
TIBCO Spotfire Inc (2022) Details on regression modeling – options. https://www.tibco.com/. Accessed: 15. Sept 2022
LĂ¼ken J, Schimmelpfennig H (2020) The degree of determination of linear regression, 03. April 2020. https://www.ifad.de/das-bestimmtheitsmass-der-linearen-regression/. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) RapidMiner 9: operator reference manual, cleansing data, 11. Febr 2022. https://docs.rapidminer.com/latest/studio/operators/rapidminer-studio-operator-reference.pdf. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) Remove correlated attributes – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/blending/attributes/selection/remove_correlated_attributes.html. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) Discretize by user specification – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/cleansing/binning/discretize_by_user_specification.html. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) Normalize – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/cleansing/normalization/normalize.html. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) Remove duplicates – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/cleansing/duplicates/remove_duplicates.html. Accessed: 15. Sept 2022
RapidMiner GmbH (2022) Automatic feature engineering – rapidMiner help. https://docs.rapidminer.com/latest/studio/operators/modeling/optimization/automatic_feature_engineering.html. Accessed: 15. Sept 2022
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Fachmedien Wiesbaden GmbH, part of Springer Nature
About this chapter
Cite this chapter
Roth-Dietrich, G., Gröschel, M., Reiner, B. (2023). Comparison of Machine Learning Functionalities of Business Intelligence and Analytics Tools. In: Barton, T., MĂ¼ller, C. (eds) Apply Data Science. Springer Vieweg, Wiesbaden. https://doi.org/10.1007/978-3-658-38798-3_7
Download citation
DOI: https://doi.org/10.1007/978-3-658-38798-3_7
Published:
Publisher Name: Springer Vieweg, Wiesbaden
Print ISBN: 978-3-658-38797-6
Online ISBN: 978-3-658-38798-3
eBook Packages: Computer ScienceComputer Science (R0)