Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education

Authors

  • Indrabudhi Lokaadinugroho Universitas Bina Nusantara
  • Abba Suganda Girsang
  • Burhanudin Burhanudin

DOI:

https://doi.org/10.21512/emacsjournal.v3i1.6816

Keywords:

Tableau, Business intelligence, Data warehouse, Nine steps of Kimball, ETL, Pentaho Data Integration, Higher education

Abstract

This paper discusses about how to build a data warehouse (DW) in business intelligence (BI) for a typical marketing division in a university. This study uses a descriptive method that attempts to describe the object or subject under study as it is, with the aim of systematically describing the facts and characteristics of the object under study precisely. In the elaboration of the methodology, there are four phases that include the identification and source data collection phase, the analysis phase, the design phase, and then the results phase of each detail in accordance with the nine steps of Kimball’s data warehouse and the Pentaho Data Integration (PDI). The result is a tableau as a tool of BI that does not have complete ETL tools. So, the process approach in combining PDI and DW as a data source certainly makes a tableau as a BI tool more useful in presenting data thus minimizing the time needed to obtain strategic data from 2-3 weeks to 77 minutes.

References

Bassil, Y. (2012, December). A Data Warehouse Design for A Typical University Information System. Journal of Computer Science & Research (JCSCR), 1(6), 12-17. Retrieved from https://arxiv.org/ftp/arxiv/papers/1212/1212.2071.pdf

Brandão, A., Pereira, E., Esteves, M., Portela, F., Santos, M. F., Abelha, A., & Machado, J. (2016). A Benchmarking Analysis of Open-Source Business Intelligence Tools in Healthcare Environments. Information, 7(57), 1-16. doi:10.3390/info7040057

Casters, M., Bouman, R., & Dongen, J. v. (2010). Pentaho® Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration. Canada: Wiley Publishing, Inc.

Eckerson, W. W. (2006). Performance Dashboards: Measuring, Monitoring, and Managing Your Business. Hoboken, New Jersey: John Wiley & Sons, Inc.

Golfarelli, M. (2010). From User Requirements to Conceptual Design in Warehouse Design: A Survey. In L. Bellatreche, Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction (Advances in Data Warehousing and Mining (ADWM)) (pp. 1-16). USA: Information Science Reference.

Golfarelli, M., & Rizzi, S. (2009). Data Warehouse Design: Modern Principles and Methodologies. Italy: McGraw Hill.

Kakish, K., & Kraft, T. A. (2012). ETL Evolution for Real-Time Data Warehousing. 2012 Proceedings of the Conference on Information Systems Applied Research (pp. 1-12). New Orleans Louisiana, USA: EDSIG (Education Special Interest Group of the AITP) .

Kimball, R., & Caserta, J. (2004). The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning,Conforming, and Delivering Data. USA: Wiley Publishing, Inc.

Kimball, R., & Ross, M. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2nd ed.). Canada: John Wiley & Sons, Inc.

Kimball, R., & Ross, M. (2010). The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence (1st ed.). Indianapolis: Wiley Publishing, Inc.

Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Indianapolis: John Wiley & Sons, Inc.

Kimball, R., Reeves, L., Thornthwaite, W., Ross, M., & Thornwaite, W. (1998). The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. USA: John Wiley & Sons, Inc.

Muntean, M., Bologa, A.-R., Bologa, R., & Alexandra, F. (2016). Recent Researches in Educational Technologies. In N. Gavriluta, R. Raducanu, M. Iliescu, H. Costin, N. Mastorakis, V. Olej, & J. Strouhal (Ed.), 7th WSEAS / IASME International Conference on Educational Technologies (EDUTE ‘11) (pp. 118-123). Romania: WSEAS Press. Retrieved from http://www.wseas.org/multimedia/books/2011/Iasi/EDUTE.pdf

Rudy, & Miranda, E. (2015). Management Report for Marketing in Higher Education Based On Data Warehouse and Data Mining. International Journal of Multimedia and Ubiquitous Engineering, 10(4), 291-302. Retrieved from https://www.researchgate.net/publication/283126375_Management_Report_for_Marketing_in_Higher_Education_Based_On_Data_Warehouse_and_Data_Mining

Salaki, R. J., Tangkawarow, I., & Waworuntu, J. (2015). Extract transformation loading from OLTP to OLAP data using pentaho data integration. International Conference on Innovation in Engineering and Vocational Education (pp. 1-8). Bandung, Indonesia: IOP Publishing. Retrieved from https://www.researchgate.net/publication/303515839_Extract_transformation_loading_from_OLTP_to_OLAP_data_using_pentaho_data_integration

Sen, A., & Sinha, A. P. (2005, March). A Comparison of Data Warehousing Methodologies: Using a common set of attributes to determine which methodology to use in a particular data warehousing project. Communications of the ACM, 48(3), 79-84.

Silva, F. D. (2005). Data Warehousing & Business Intelligence ROI. International Journal of the Computer, the Internet and Management, 13(SP2), 1-3. Retrieved from http://www.ijcim.th.org/SpecialEditions/v13nSP2/pdf/p1.1-1.3-Data%20Warehousing.pdf

Tarnaveanu, D. (2012). Pentaho Business Analytics: a Business Intelligence Open Source Alternative. Database Systems Journal, III(3), 23-34. Retrieved from http://www.dbjournal.ro/archive/9/9_3.pdf

Waas, F., Wrembel, R., Freudenreich, T., Thiele, M., Koncilia, C., & Furtado, P. (2013, April). On-Demand ELT Architecture for Right-Time BI: Extending the Vision. International Journal of Data Warehousing and Mining (IJDWM), 9(2), 21-38. Retrieved from https://pdfs.semanticscholar.org/5fc5/f7c59f881d536da27626f309927926626fa8.pdf

Downloads

Published

2021-01-31

Issue

Section

Articles