Modeling data mart using ETL (extract, transform, load) webservice concept on feeder with a dashboard

  • Abstract
  • Keywords
  • References
  • PDF
  • Abstract

    College in Indonesia do reporting students, lecturers, and lecture activities data to PDDIKTI (Bahasa: Pangkalan Data Pendidikan Tinggi/ Higher Education Database). FEEDER PDDIKTI doesn’t have any measurement components such as KPI (Key Performance Indicator) which can be used for measure performance and evaluation of academic activities at college. Problem that occur there is a lot of academic data stored but when transform it to a report at the time of academic activities evaluation becomes difficult and takes a long time and requires a monitoring, evaluating and measuring tools that can be measure performance of the college. Data mart modeling using star schema bring through to analyze data from various perspectives according to the number of dimensions. Academic data within data mart sourced from FEEDER PDDIKTI after going through the ETL (Extract Transform Load) process by using web service then visualized into graphic form on the dashboard which there is a KPI inside to measure performance at college. Dashboard with KPI inside that has been built providing convenience in conducting analysis, monitoring and evaluation of academic activities with the level of user satisfaction achieved by 82%.


  • Keywords

    Data Mart; ETL; Web Service; Application; DIKTI; Star Schema.

  • References

      [1] H. Nindito, "School of Information System BINUS," 15 Desember 2016. [Online]. Available: [Accessed 20 Maret 2018].

      [2] Henderi, S. Rahayu and B. M. Prasetyo, "Dashboard Information System Berbasis Key Performance Indicator," Seminar Nasional Informatika (semnasIF) UPN, pp. D82-D87, 2012.

      [3] K. C. Laudon and J. P. Laudon, Management Information Systems - Managing The Digital Firm 13th Edition, Harlow: Pearson Education, 2014, p. G4.

      [4] C. Vercellis, Business Intelligence: Data Mining and Optimization for Decision Making, Chichester: John Wiley & Sons Ltd, 2009.

      [5] R. K. Rainer, B. Prince and C. Cegielski, Introduction to Information Systems: Supporting and Transforming Business 5th Edition, Hoboken: John Wiley & Sons, Inc, 2014.

      [6] G. W. Reynolds, Information Technology for Managers, Boston: Course Technology, 2010, p. 255.

      [7] T. M. Connolly and C. E. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management 6th Edition, Harlow: Pearson Education Limited, 2015, p. 1214.

      [8] V. Rainardi, Building a Data Warehouse with Examples in SQL Server, New York: Springer-Verlag New York, Inc, 2008, p. 1.

      [9] S. Scheps, Business Intelligence for Dummies, Indianapolis: Wiley Publishing, Inc, 2008, p. 208.

      [10] E. Turban, R. Sharda, D. Delen and D. King, Business Intelligence: A Managerial Approach 2nd Edition, New Jersey: Prentice Hall, 2010, p. 53.

      [11] R. Bouman and J. v. Dongen, Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL, Indianapolis: Wiley Publishing, Inc, 2009.

      [12] L. T. Moss and S. Atre, Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-support Applications, Canada: Addison-Wesley, 2004.

      [13] D. Parmenter, KEY PERFORMANCE INDICATORS Developing, Implementing, and Using Winning KPIs, 2nd Ed, Canada: Wiley, 2010.

      [14] M. Seify, "Importance of KPI in BI system, case study: Iranian industries," Seventh International Conference on Information Technology, p. 1245, 2010.

      [15] User Guide Feeder PDDIKTI - Sistem Informasi Manajemen Akademik Modul Pangkalan Data Perguruan Tinggi, Jakarta: PDDIKTI - Kementrian Riset, Teknologi dan Pendidikan Tinggi Republik Indonesia. Direktorat Jenderal Pendidikan Tinggi.

      [16] R. Riki, "Implementation of Information Technology Governance Based on CoBIT Framework 5. Case Study: Bureau of Information Systems & Technology-Buddhi Dharma University," Tech-E, vol. 1, no. 2, pp. 43-50, 2018.




Article ID: 17543
DOI: 10.14419/ijet.v7i4.17543

Copyright © 2012-2015 Science Publishing Corporation Inc. All rights reserved.