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
Keywords:Tableau, Business intelligence, Data warehouse, Nine steps of Kimball, ETL, Pentaho Data Integration, Higher education
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.
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
Copyright (c) 2021 Indrabudhi Lokaadinugroho, Abba Suganda Girsang, Burhanudin
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: Creative Commons Attribution-Share Alike (CC BY-SA)