PERANCANGAN DASHBOARD OPERASIONAL GREEN BEAN PADA PT KOPI RAWDEE RAWAGEUDE: EVALUASI DENGAN QUIS

Fanny Salsata, . (2026) PERANCANGAN DASHBOARD OPERASIONAL GREEN BEAN PADA PT KOPI RAWDEE RAWAGEUDE: EVALUASI DENGAN QUIS. Skripsi thesis, Universitas Pembangunan Nasional Veteran Jakarta.

[img] Text
ABSTRAK.pdf

Download (250kB)
[img] Text
AWAL.pdf

Download (1MB)
[img] Text
BAB 1.pdf
Restricted to Repository UPNVJ Only

Download (313kB)
[img] Text
BAB 2.pdf
Restricted to Repository UPNVJ Only

Download (340kB)
[img] Text
BAB 3.pdf
Restricted to Repository UPNVJ Only

Download (375kB)
[img] Text
BAB 4.pdf
Restricted to Repository UPNVJ Only

Download (1MB)
[img] Text
BAB 5.pdf

Download (290kB)
[img] Text
DAFTAR PUSTAKA.pdf

Download (254kB)
[img] Text
DAFTAR RIWAYAT HIDUP.pdf
Restricted to Repository UPNVJ Only

Download (112kB)
[img] Text
LAMPIRAN.pdf
Restricted to Repository UPNVJ Only

Download (2MB)
[img] Text
HASIL PLAGIARISME.pdf
Restricted to Repository staff only

Download (8MB)
[img] Text
ARTIKEL KI.pdf
Restricted to Repository staff only

Download (564kB)

Abstract

Digital transformation requires small and medium-sized enterprises (SMEs) to manage operational data efficiently, accurately, and in a data-driven manner. PT Kopi Rawdee Rawageude, a coffee production SME, still relies on manual spreadsheets for recording green bean operations, which are prone to duplication, input errors, and delays in accessing information. This situation reduces efficiency and hinders timely decision-making. This study aims to design an operational dashboard using Microsoft Excel, incorporating Pivot Tables, Pivot Charts, Slicers, Timelines, and Power Query, by applying the User-Centered Design (UCD) approach and Rapid Prototyping method. The respondents consisted of the head of division and two roastery team members as primary users. Data were collected through observation, interviews, and the Questionnaire for User Interaction Satisfaction (QUIS). The research process involved developing prototypes, user evaluations, and iterative revisions based on feedback. The evaluation results indicate a significant improvement in user satisfaction, with the average QUIS score increasing from 4.73 in the old system to 7.92 in the new dashboard. The greatest improvements were found in screen design and general impressions, showing that the dashboard is more interactive, user-friendly, and aligned with operational needs. The implementation proved to enhance inventory recording reliability, accelerate data analysis, and support data-driven decision-making. Beyond practical benefits for the company, this study emphasizes the importance of applying UCD to design simple yet effective systems, thus serving as both an academic and practical reference for SMEs facing similar technological constraints.

Item Type: Thesis (Skripsi)
Additional Information: [Fanny Salsata: 2110312016] [Pembimbing 1: Donny Montreano] [Pembimbing 2: Santika Sari] [Penguji 1: Yulizar Widiatama] [Penguji 2: M. Rachman Waluyo]
Uncontrolled Keywords: Operational Dashboard, User-Centered Design, Pivot Table, QUIS, Usability, SMEs
Subjects: T Technology > T Technology (General)
T Technology > T Technology (General) > T201 Patents. Trademarks
Divisions: Fakultas Teknik > Program Studi Teknik Industri (S1)
Depositing User: FANNY SALSATA
Date Deposited: 09 Feb 2026 08:04
Last Modified: 09 Feb 2026 08:04
URI: http://repository.upnvj.ac.id/id/eprint/42211

Actions (login required)

View Item View Item