SEMINAR TEKNOLOGI MAJALENGKA (STIMA)
Vol 10 (2026)

PEMBUATAN DASHBOARD PENJUALAN LAYANAN BENGKEL BERBASIS GOOGLE LOOKER STUDIO PADA BENGKEL RESMI SUZUKI KADIPATEN

Shilpana Anjelika (Program Studi Informatika, Fakultas Teknik, Universitas Majalengka)



Article Info

Publish Date
01 Oct 2026

Abstract

The increasing volume of operational data in automotive after-sales services creates a need for faster and more informative performance monitoring. Suzuki Kadipaten Official Workshop previously relied on spreadsheet-based manual reporting, which required repeated calculations and made it difficult for management to monitor service sales, customer characteristics, booking behavior, and geographical distribution in an integrated manner. This study aims to develop an interactive service sales dashboard using Google Looker Studio and Google Sheets as a lightweight data source. The research adopts an applied information-system development approach based on the System Development Life Cycle (SDLC), consisting of planning, requirements analysis, design, implementation, testing, and maintenance. Data were collected through observation, interviews, and literature study. An Extract, Transform, and Load (ETL) process was applied to clean, standardize, and prepare transaction data before visualization. The resulting dashboard presents key performance indicators, sales trends, service and vehicle categories, booking behavior, promotional utilization, and customer geographical distribution. Functional testing using black-box scenarios indicates that the dashboard components respond according to the specified requirements. The developed dashboard provides a more structured and interactive means of monitoring workshop performance and can support management in evaluating service sales and formulating data-informed operational and marketing decisions.

Copyrights © 2026






Journal Info

Abbrev

stima

Publisher

Subject

Computer Science & IT Control & Systems Engineering Industrial & Manufacturing Engineering Mechanical Engineering Transportation

Description

Prosiding SEMINAR TEKNOLOGI MAJALENGKA (STIMA) adalah publikasi ilmiah yang memuat hasil-hasil penelitian orisinal dan terkini dari para akademisi, peneliti, dan praktisi di berbagai bidang teknik dan manajemen. Prosiding ini memiliki sifat multidisiplin, berfokus pada integrasi ilmu pengetahuan ...