Abstract
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
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
More From: MATICS: Jurnal Ilmu Komputer dan Teknologi Informasi (Journal of Computer Science and Information Technology)
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.