Skip to main content

Comparison of Machine Learning Functionalities of Business Intelligence and Analytics Tools

  • Chapter
  • First Online:
Apply Data Science

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

    Google Scholar 

  10. 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

  11. 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

  12. Panizzo DS (2017) Wine quality, 29. Oct 2017. https://www.kaggle.com/danielpanizzo/wine-quality. Accessed: 15. Sept 2022

  13. 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

  14. 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

  15. SAP SE (2022) Horizontweiter MAPE. https://help.sap.com/viewer/41d1a6d4e7574e32b815f1cc87c00f42/3.1/de-DE/4ff1d39db49d4e69a22d1d58eb0cd28d.html. Accessed: 15. Sept 2022

  16. 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

  17. QlikTech GmbH (2022) Qlik sense datenanalyse-plattform. https://www.qlik.com/de-de/products/qlik-sense. Accessed: 15. Sept 2022

  18. QlikTech GmbH (2022) Qlik sense business free trial. https://www.qlik.com/de-de/trial/qlik-sense-business. Accessed: 15. Sept 2022

  19. 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

    Chapter  Google Scholar 

  20. TIBCO Spotfire Inc (2022) Using an evaluation summary. https://www.tibco.com/. Accessed: 15. Sept 2022

  21. TIBCO Spotfire Inc (2022) Details on regression modeling – options. https://www.tibco.com/. Accessed: 15. Sept 2022

  22. 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

  23. 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

  24. 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

  25. 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

  26. RapidMiner GmbH (2022) Normalize – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/cleansing/normalization/normalize.html. Accessed: 15. Sept 2022

  27. RapidMiner GmbH (2022) Remove duplicates – rapidMiner documentation. https://docs.rapidminer.com/latest/studio/operators/cleansing/duplicates/remove_duplicates.html. Accessed: 15. Sept 2022

  28. 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

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Gabriele Roth-Dietrich .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Fachmedien Wiesbaden GmbH, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

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)

Publish with us

Policies and ethics