Developing Business Intelligence Dashboard for Sales KPI Monitoring in Advertising Agency: A Human-Centered Design Approach
DOI:
https://doi.org/10.54259/jdmis.v4i1.6596Keywords:
Business Intelligence, Dashboard, Human-Centered Design, Sales KPI, Data Visualization, KPI Penjualan, Agensi PeriklananAbstract
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.
Downloads
References
H. Chen, R. H. L. Chiang, and V. C. Storey, “Business Intelligence and Analytics: From Big Data to Big Impact,” MIS Quarterly, vol. 36, no. 4, pp. 1165–1188, 2012.
W. Yeoh and A. Popovič, “Extending the understanding of critical success factors for implementing business intelligence systems,” Journal of the Association for Information Science and Technology, vol. 67, no. 1, pp. 134–147, 2016.
R. Sharda, D. Delen, and E. Turban, Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 4th ed. Pearson, 2018.
S. Chaudhuri, U. Dayal, and V. Narasayya, “An overview of business intelligence technology,” Communications of the ACM, vol. 54, no. 8, pp. 88–98, 2011. [
T. H. Davenport, “Competing on Analytics,” Harvard Business Review, vol. 84, no. 1, pp. 98–107, 2006.
E. Turban, D. Delen, and R. Sharda, Decision Support and Business Intelligence Systems, 9th ed. Prentice Hall, 2011.
B. Wixom and H. Watson, “The BI-based organization,” International Journal of Business Intelligence Research, vol. 1, no. 1, pp. 13–28, 2010.
D. Arnott and G. Pervan, “A critical analysis of decision support systems research,” Journal of Information Technology, vol. 20, no. 2, pp. 67–87, 2005.
D. A. Norman, The Design of Everyday Things. Basic Books, 2013.
ISO, “ISO 9241-210:2019 Ergonomics of human-system interaction — Part 210: Human-centred design for interactive systems,” International Organization for Standardization, 2019.
T. Jokela, N. Iivari, J. Matero, and M. Karukka, “The standard of user-centered design and the standard definition of usability: Analyzing ISO 13407 against ISO 9241-11,” Proceedings of the Latin American Conference on Human-Computer Interaction, pp. 53–60, 2003.
K. Vredenburg, J.-Y. Mao, P. W. Smith, and T. Carey, “A survey of user-centered design practice,” Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, pp. 471–478, 2002.
J. Lazar, J. H. Feng, and H. Hochheiser, Research Methods in Human-Computer Interaction, 2nd ed. Morgan Kaufmann, 2017.
A. Cooper, R. Reimann, D. Cronin, and C. Noessel, About Face: The Essentials of Interaction Design, 4th ed. Wiley, 2014.
R. Kimball and M. Ross, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd ed. Wiley, 2013.
B. Buxton, Sketching User Experiences: Getting the Design Right and the Right Design. Morgan Kaufmann, 2007.
S. Few, Information Dashboard Design: The Effective Visual Communication of Data. O'Reilly Media, 2006.
E. R. Tufte, The Visual Display of Quantitative Information, 2nd ed. Graphics Press, 2001.
J. Brooke, “SUS: A 'Quick and Dirty' Usability Scale,” in Usability Evaluation in Industry, P. W. Jordan et al., Eds. Taylor & Francis, 1996, pp. 189–194.
B. Laugwitz, T. Held, and M. Schrepp, “Construction and Evaluation of a User Experience Questionnaire,” HCI and Usability for Education and Work, pp. 63–76, 2008.
W. H. Inmon, Building the Data Warehouse, 4th ed. Wiley, 2005.
H. Watson and B. Wixom, “The Current State of Business Intelligence,” Computer, vol. 40, no. 9, pp. 96–99, 2007.
A. Pappas and L. Pappas, “The Role of Business Intelligence in Sales Performance,” Journal of Sales and Marketing Management, vol. 5, no. 2, pp. 45-56, 2021.
M. Golfarelli, S. Rizzi, and I. Cella, “Beyond data warehousing: what's next in business intelligence?,” Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, pp. 1–6, 2004.
A. Bangor, P. T. Kortum, and J. T. Miller, “An Empirical Evaluation of the System Usability Scale,” International Journal of Human-Computer Interaction, vol. 24, no. 6, pp. 574–594, 2008.
M. Schrepp, A. Hinderks, and J. Thomaschewski, “Applying the User Experience Questionnaire (UEQ) in Different Evaluation Scenarios,” International Journal of Interactive Multimedia and Artificial Intelligence, vol. 2, no. 4, pp. 9–14, 2014.
N. Maisel, L. Patrick, and A. Harris, “Mobile Business Intelligence: A Review,” International Journal of Business Information Systems, vol. 35, no. 1, pp. 112-128, 2020.
J. Nielsen, Usability Engineering. Morgan Kaufmann, 1993.
B. Rouhani, M. N. Mahrin, F. Nikpay, and P. Nikfard, “A systematic literature review on business intelligence and analytics in small and medium-sized enterprises,” International Journal of Business Intelligence Research, vol. 7, no. 1, pp. 38–60, 2016.
A. Popovič, R. Hackney, P. S. Coelho, and J. Jaklič, “Towards business intelligence systems success: Effects of maturity and culture on analytical decision making,” Decision Support Systems, vol. 54, no. 1, pp. 729–739, 2012.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Ince Ahmad Zarqan, Dimas Yudistira Nugraha, Ganda Tua Sitompul, Adli Abdillah Nababan
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
