Zarqan, Ince Ahmad
Unknown Affiliation

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

Found 1 Documents
Search
Journal : Journal of Data Mining and Information Systems

Developing Business Intelligence Dashboard for Sales KPI Monitoring in Advertising Agency: A Human-Centered Design Approach Zarqan, Ince Ahmad; Nugraha, Dimas Yudistira; Sitompul, Ganda Tua; Nababan, Adli Abdillah
JDMIS: Journal of Data Mining and Information Systems Vol. 4 No. 1 (2026): February 2026
Publisher : Yayasan Pendidikan Penelitian Pengabdian Algero

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54259/jdmis.v4i1.6596

Abstract

Digital advertising agencies in South Jakarta face significant challenges in monitoring sales performance due to data fragmentation across multiple platforms such as CRM, spreadsheets, and digital advertising tools. Conventional manual reporting processes lead to data latency, high error rates, and delayed strategic decision-making. This study aims to develop a Business Intelligence (BI) dashboard to monitor Sales Key Performance Indicators (KPIs) in real-time, utilizing a Human-Centered Design (HCD) approach to ensure high usability and adoption. The research methodology follows the ISO 9241-210 standard for HCD, encompassing four iterative phases: understanding the context of use, specifying user requirements, producing design solutions, and evaluating designs. The system was developed using Google Looker Studio with a data warehouse architecture integrating Google BigQuery. Testing was conducted involving 15 internal stakeholders using the System Usability Scale (SUS) and User Experience Questionnaire (UEQ). The results demonstrated a SUS score of 82.5 (Excellent) and positive benchmarks in efficiency and perspicuity metrics. The implementation of the dashboard reduced reporting time by 60% and improved data accessibility for executive decision-making. This study contributes to the literature by demonstrating how HCD principles can bridge the gap between technical BI capabilities and end-user cognitive needs in the creative industry context.