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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
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.
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.
Atre, S., & Moss, L. T. (2003). Business intelligence roadmap: The complete project lifecycle for decision-support applications. Boston: Addison Wesley.
Gonzalez, J. F. (2011). Critical success factors of a business intelligence project. Novtica, 211, 20–25.
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.
Gartner, Inc. (2016). IT glossary. Retrieved from http://www.gartner.com/it-glossary/business-intelligence-bi/. Accessed November 9, 2016.
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
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
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.
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.
TIBCO Jaspersoft. (2016). Jaspersoft Business Intelligence Software. Available via TIBCO Software. http://www.jaspersoft.com. Accessed November 15, 2016.
Tarnaveanu, D. (2012). Pentaho business analytics: A business intelligence open source alternative. Database System Journal, 3, 13.
Innovent Solutions. (2016). Pentaho reports review. Retrieved from http://www.innoventsolutions.com/pentaho-review.html. Accessed: December 12, 2016.
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.
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.
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.
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.
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.
Pochampalli, S. (2014). Jaspersoft BI suite tutorials. Retrieved from http://www.jasper-bi-suite.blogspot.com.au/. Accessed December 17, 2016.
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.
Informatica Data Quality Unit. (2013). Data quality: Dashboards and reporting. Retrieved from http://www.Markerplace.informatica.com/solution/dataqualitydashBoardsandreporting-961. Accessed December 21, 2016.
Sagemath. (2016). Sagemath—Open-source mathematical software system. Available via Sage. Retrieved from http://www.sagemath.org. Accessed November 21, 2016.
AIMS Team. (2016). Sage. Retrieved from http://www.launchpad.net/˜aims/+archive/ubuntu/sagemath. Accessed December 21, 2016.
Stein, W. (2016). The origins of SageMath. Retrieved from http://www.wstein.org/talks/2016-06-sage-bp/bp.pdf. Accessed: November 28, 2016.
MathWorks. (2016). MATLAB—MathWorks—MathWorks Australia. Available via MathWorks. http://www.au.mathworks.com. Accessed December 28, 2016.
Gockenbach, M. S. (1999). A practical introduction to Matlab. Retrieved from http://www.math.mtu.edu/msgocken/intro/introtml. Accessed: December 28, 2016.
Black, K. (2016). Matlab tutorials. http://www.cyclismo.org/tutorial/matlab/. Accessed: November 29, 2016.
Lichman, M. (2013). UCI machine learning repository. Retrieved form http://www.archive.ics.uci.edu/ml. Accessed December 10, 2016.
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.
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).
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).
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)