Skip to main content

Performance Evaluation of Big Data and Business Intelligence Open Source Tools: Pentaho and Jaspersoft

  • Chapter
  • First Online:
Internet of Things and Big Data Analytics Toward Next-Generation Intelligence

Part of the book series: Studies in Big Data ((SBD,volume 30))

Abstract

Despite the recent increase in the utilisation of the tools of “Big Data” and “Business Intelligence” (BI), the investigation that has been carried out regarding the inferences related to its implementation and performance is relatively scarce. Analytical tools have a significant impact on the development and sustainability of a company since the evaluation of the clients information are critical aspects and crucial in the progress towards a competitive market. All corporations at certain phase in their life cycle, require to implement different and improved data processing systems in order to optimize the decision making procedures. Enterprises utilise BI outcomes to pull together records that has been extracted from consolidated analyses from signals in the data grouping of BI information scheme. This, in turn, gives a marked advantage to companies in the development of activities based on predictions, and also to compete with competitors in the market. Business Intelligence applications are precise implements that resolve this matter for companies that require, data storing and administration. The chapter examines the most recommended Business Intelligence open source applications currently available: Pentaho and Jaspersoft, processing big data over and done with six databases of diverse sizes, with a special focus on their extract transform and load and Reporting procedures by calculating their routines through computer algebra systems. Moreover, the chapter correspondingly makes available a complete explanation of the structures, features, and comprehensive implementation scenario.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 219.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 279.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 279.99
Price excludes VAT (USA)
  • Durable hardcover 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

References

  1. List, B., Bruckner, R. M., Machaczek, K., & Schiefer, J. (2002). A comparison of data warehouse development methodologies case study of the process warehouse. Database and Expert Systems Applications DEXA, France, 2453, 203–215.

    MATH  Google Scholar 

  2. Dresner, H. (1993). Business intelligence: Competing against time. In Paper presented a Twelfth Annual Office Information System Conference, Garther Group. London: Earl, M.J., 1989.

    Google Scholar 

  3. Atre, S., & Moss, L. T. (2003). Business intelligence roadmap: The complete project lifecycle for decision-support applications. Boston: Addison Wesley.

    Google Scholar 

  4. Gonzalez, J. F. (2011). Critical success factors of a business intelligence project. Novtica, 211, 20–25.

    Google Scholar 

  5. Sallam, R. L., Hostmann, B., Schegel, K., Tapadinhas, J. Parenteau, T., & Oestreich, W. (2015). Magic quadrant for business intelligence and analytics platforms. Retrieved from http://www.gartner.com/doc/2989518/magic-quadrant-business-intelligence-analytics. Accessed November 9, 2016.

  6. Gartner, Inc. (2016). IT glossary. Retrieved from http://www.gartner.com/it-glossary/business-intelligence-bi/. Accessed November 9, 2016.

  7. Hazlewood, W. R., & Coyle, L. (2009). On ambient information systems: Challenges of design and evaluation. Retrieved from http://www.igi-global.com/article/ambient-information-systems/3873

  8. Baldwin, H. (2014). A Match made somewhere: big data and the internet of things. http://www.forbes.com/sites/howardbaldwin/2014/11/24a-match-made-somewhere-big-data-and-the-internet-of.things/#5dda8d8f6513

  9. Kune, R., Konugurthi, P. K., Agarwal, A., & Chillarige, R. R. (2016). The anatomy of big data computing. Software: Practice and Experience, 46(1), 79–105.

    Google Scholar 

  10. Pentaho A Hitachi Group Company. (2005–2016). Pentaho: Data integration, business analytics and bid data leaders. Pentaho Corporation. http://www.pentaho.com. Accessed 10 Nov 2016.

  11. TIBCO Jaspersoft. (2016). Jaspersoft Business Intelligence Software. Available via TIBCO Software. http://www.jaspersoft.com. Accessed November 15, 2016.

  12. Tarnaveanu, D. (2012). Pentaho business analytics: A business intelligence open source alternative. Database System Journal, 3, 13.

    Google Scholar 

  13. Innovent Solutions. (2016). Pentaho reports review. Retrieved from http://www.innoventsolutions.com/pentaho-review.html. Accessed: December 12, 2016.

  14. Kapila, T. (2014). Pentaho BI & integration with a custom Java web application. Retrieved from http://www.neevtech.com/blog/2014/08/13/pentaho-bi-integration-with-a-custom-java-web-application-2/. Accessed November 11, 2016.

  15. Pozzani, G. (2014). OLAP solutions using Pentaho analysis services. Retrieved from http://www.profs.sci.univr.it/˜pozzani/attachments/pentaho_lect4.pdf. Accessed: December 12, 2016.

  16. Sanket. (2015). Fusion charts integration in Pentaho BI dashboards. Retrieved from http://www.fusioncharts.com/blog/2011/05/free-plugin-integrate-fusioncharts-in-pentaho-bi-dashboards/. Accessed November 13, 2016.

  17. Vidhya, S., Sarumathi, S., & Shanthi, N. (2014). Comparative analysis of diverse collection of big data analytics tools. International Journal of Computer, Electrical, Automation, Control and Information Engineering, 9, 7.

    Google Scholar 

  18. Olavsrud, T. (2014). Jaspersoft aims to simplify embedding analytics and visualizations. Retrieved from http://www.cio.com/article/2375611/business-intelligence/jaspersoft-aims-to-simplify-embedding-analytics-andvisualizations.html. Accessed December 16, 2016.

  19. Pochampalli, S. (2014). Jaspersoft BI suite tutorials. Retrieved from http://www.jasper-bi-suite.blogspot.com.au/. Accessed December 17, 2016.

  20. Vinay, J. (2013). OLAP cubes in Jasper Server. Retrieved from http://www.hadoopheadon.blogspot.com.au/.2013/07/setting-up-olap-cubes-injasper.html. Accessed: November 19, 2016.

  21. Informatica Data Quality Unit. (2013). Data quality: Dashboards and reporting. Retrieved from http://www.Markerplace.informatica.com/solution/dataqualitydashBoardsandreporting-961. Accessed December 21, 2016.

  22. Sagemath. (2016). Sagemath—Open-source mathematical software system. Available via Sage. Retrieved from http://www.sagemath.org. Accessed November 21, 2016.

  23. AIMS Team. (2016). Sage. Retrieved from http://www.launchpad.net/˜aims/+archive/ubuntu/sagemath. Accessed December 21, 2016.

  24. Stein, W. (2016). The origins of SageMath. Retrieved from http://www.wstein.org/talks/2016-06-sage-bp/bp.pdf. Accessed: November 28, 2016.

  25. MathWorks. (2016). MATLAB—MathWorks—MathWorks Australia. Available via MathWorks. http://www.au.mathworks.com. Accessed December 28, 2016.

  26. Gockenbach, M. S. (1999). A practical introduction to Matlab. Retrieved from http://www.math.mtu.edu/msgocken/intro/introtml. Accessed: December 28, 2016.

  27. Black, K. (2016). Matlab tutorials. http://www.cyclismo.org/tutorial/matlab/. Accessed: November 29, 2016.

  28. Lichman, M. (2013). UCI machine learning repository. Retrieved form http://www.archive.ics.uci.edu/ml. Accessed December 10, 2016.

  29. Parra, V. M., Syed, A., Mohammad, A., & Halgamuge, M. N. (2016). Pentaho and Jaspersoft: A comparative study of business intelligence open source tools processing big data to evaluate performances. International Journal of Advanced Computer Science and Applications, 10(14569), 1–10.

    Google Scholar 

  30. Pham, D. V., Syed, A., Mohammad, A., & Halgamuge, M. N. (2010). Threat analysis of portable hack tools from USB storage devices and protection solutions. In International Conference on Information and Emerging Technologies (pp. 1–5).

    Google Scholar 

  31. Pham, D. V., Halgamuge, M. N., Syed, A, & Mendis, P. (2010). Optimizing windows security features to block malware and hack tools on USB storage devices. Progress in Electromagnetics Research Symposium (pp. 350–355).

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Victor M. Parra .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG

About this chapter

Cite this chapter

Parra, V.M., Halgamuge, M.N. (2018). Performance Evaluation of Big Data and Business Intelligence Open Source Tools: Pentaho and Jaspersoft. In: Dey, N., Hassanien, A., Bhatt, C., Ashour, A., Satapathy, S. (eds) Internet of Things and Big Data Analytics Toward Next-Generation Intelligence. Studies in Big Data, vol 30. Springer, Cham. https://doi.org/10.1007/978-3-319-60435-0_6

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-60435-0_6

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-60434-3

  • Online ISBN: 978-3-319-60435-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics