Shilpana Anjelika
Program Studi Informatika, Fakultas Teknik, Universitas Majalengka

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

PEMBUATAN DASHBOARD PENJUALAN LAYANAN BENGKEL BERBASIS GOOGLE LOOKER STUDIO PADA BENGKEL RESMI SUZUKI KADIPATEN Shilpana Anjelika
SEMINAR TEKNOLOGI MAJALENGKA (STIMA) Vol 10 (2026)
Publisher : Universitas Majalengka

Show Abstract | Download Original | Original Source | Check in Google Scholar

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.