Power BI and SQL Server Dashboard Data for Monitor Transportation Presence Employees at PT PON Gresik

Angga Debby Frayudha, Hamzah Agung


Employee presence is a crucial aspect in office management. It reflects the way employees work in a company and can impact their productivity. A high level of productivity can indicate achievement of company targets. However, this attendance data is often large and has not been processed. To turn it into valuable information, Business Intelligence (BI) software is needed that is able to visualize employee attendance and transportation data. This research aims to create a dashboard that shows employee attendance data, including entry hours and attendance status, as well as transportation data such as expenditure for each type of vehicle and travel destination code. Microsoft Power BI was used for data visualization, while Microsoft SQL Server Management Studio was used to create the database. Data is collected and processed so that it can become a source of information. The research results include a daily attendance dashboard with peak attendance at 08.00 and 21.00. The trip dashboard shows the highest fare with travel code "7AA0112" exceeding Rp. 12,000,000.00 from PT. PON Gresik. Travel information shows transportation use in Jakarta, Bandung and Surabaya with the largest total fare in Jakarta reaching Rp. 97,761,000.00

Full Text:



Akbar, RS (2017). Implementation of Business Intelligence to Analyze Child Birth Data at the Ani Padang Clinic using the Tableau Public Application. 2. Darman, R. (2018). Polbeng Inovtek Journal. Analysis of Rice Plant Data in Indonesia Using Power Bi. 3. Kadir, A. (2002). Database Concepts and Practical Guidelines. 4. Putra, FM (2016). Business Intelligence Dashboard Application as a Monitoring Tool and Decision Making Material for Sales and Account Receivables. MULTINETICS. 5. Siagian, SP (2009). Tips for Increasing Work Productivity. 6. Zaky Nur Husni, IM (2014). Implementation of Business Intelligence in XYZ Bank Report Management. Science Journalist and Senni POMITS. 7. Yumni, S. Z., & Widowati, W. (2021). Implementation of Microsoft Power BI in Monitoring Employee Attendance and Transportation. Journal of Science and Science Education, 4(1), 1–8. 8. Adam Jorgensen, Jorge Segarra, Patrick Leblanc, Jose Chinchilla, Aaron Nelson, Microsoft SQL Server 2012 Bible, Ed. Johs Wiley & Sons, Inc., 2012, Indianapolis, Indiana - USA, ISBN: 978-1-118-10687-7 9. Leonard Lobel, Andrew Brust, Programming Microsoft SQL Server 2012, Ed. Microsoft Press, 2012, ISBN-13: 978-0735658226

DOI: https://doi.org/10.18860/mat.v16i1.24149


  • There are currently no refbacks.

Copyright (c) 2024 Angga Debby Frayudha

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

The journal is indexed by :

Dimensions Sinta CrossRef GoogleScholar
Index Copernicus Moraref Portal Garuda



Editorial Office:
Informatics Engineering Department
Faculty of Science and Technology
Universitas Islam Negeri Maulana Malik Ibrahim Malang
Jalan Gajayana 50 Malang, Jawa Timur, Indonesia 65144
Email: matics@uin-malang.ac.id

Creative Commons License
This work is licensed under a CC-BY-NC-SA 4.0.
© All rights reserved 2015. MATICS , ISSN : 1978-161X | e-ISSN :  2477-2550