skip to main content
10.1145/3655532.3655586acmotherconferencesArticle/Chapter ViewAbstractPublication PagesicrsaConference Proceedingsconference-collections
research-article

Dynamically Visualizing Key Performance Indicators for Informed Business Decision-Making

Published: 28 June 2024 Publication History

Abstract

This study aims to enhance the usage and optimization of Key Performance Indicators (KPIs) by addressing their underutilization and lack of proper visualization in decision-making processes. Currently, KPIs are often calculated using static scripts, leading to delays and dependency on the data analysis process. To overcome this challenge, we propose a solution that involves visualizing KPIs alongside the relevant data in a dynamic manner using Tableau dashboards. The project primarily focuses on the sales domain. Furthermore, various statistical techniques have been applied to ensure data reliability by removing outliers. The comprehensive solution developed encompasses meticulous data preprocessing, accurate KPI calculation, and dynamic visualization of both the underlying data and KPIs. By implementing this approach, business stakeholders gain access to a more interactive and intuitive platform for consuming and leveraging KPIs.

References

[1]
[1] Villazón, Cruz, et al. “Identification of Key Performance Indicators in Project-Based Organisations through the Lean Approach.” Sustainability, vol. 12, no. 15, 2020, https://doi.org/10.3390/su12155977.
[2]
[2] Eberhard, Karin. “The Effects of Visualization on Judgment and Decisionmaking: A Systematic Literature Review.” Management Review Quarterly, vol. 73, no. 1, 2023, pp. 167–214, doi.org/10.1007/s11301021002358, https://doi.org/10.1007/s11301021002358.
[3]
[3] Hyysalo, Jarkko, et al. Redefining KPIs with Information Flow Visualisation – Practitioners’ View. 18 Oct. 2018.
[4]
[4] S. Cao, Y. Zeng, S. Yang, and S. Cao, “Research on Python Data Visualization Technology,” Journal of Physics: Conference Series, vol. 1757, p. 012122, Jan. 2021.
[5]
[5] Salesforce, “Tableau Helps the World Economic Forum Shape Global, Regional and Industry Agendas,” Tableau, 2022. Available: https://www.tableau.com/solutions/customer/tableau-helps-world-economic-forum-shape-global-regional-and-industry-agendas
[6]
[6] Tableau, “What is Tableau?” Tableau, 2022. Available: https://www.tableau.com/why-tableau/what-is-tableau
[7]
[7] Tableau, “Connectivity, integration, and extensibility,” Tableau, 2022. Available: https://www.tableau.com/products/our-integrations
[8]
[8] A. MAHALINGAPPA, “Global Super Store Dataset,” www.kaggle.com, 2020. Available: https://www.kaggle.com/datasets/apoorvaappz/global-super-store-dataset
[9]
[9] M. Dahr, A. Khalaf, I. Najm, and M. Ahmed, “Implementing Sales Decision Support System Using Data Mart Based On OLAP, KPI, and Data Mining Approaches” Journal of Engineering Science and Technology, vol. 17, p. 0275, Feb. 2022.
[10]
[10] P. C. Verhoef et al., “Digital transformation: A multidisciplinary reflection and research agenda,” Journal of Business Research, vol. 122, pp. 889–901, 2021. Available: https://www.sciencedirect.com/science/article/pii/S0148296319305478
[11]
[11] J. Ostrowski and M. József, “Statistical Analysis of Machinery Variance by Python,” Acta Polytechnica Hungarica, vol. 17, pp. 151–168, Jan. 2020.
[12]
[12] Syed Muhammad Mubashir Rizvi, “Mastering data visualization: Simplifying complex data for better insights | Data Science Dojo,” datasciencedojo.com, May 2023. Available: https://datasciencedojo.com/blog/data-visualization-guide/. [Accessed: Jun. 21, 2023]

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
ICRSA '23: Proceedings of the 2023 6th International Conference on Robot Systems and Applications
September 2023
335 pages
ISBN:9798400708039
DOI:10.1145/3655532
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 28 June 2024

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. Dynamic Visualization
  2. Informative Decision-Making
  3. Key Performance Indicators

Qualifiers

  • Research-article
  • Research
  • Refereed limited

Conference

ICRSA 2023

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • 0
    Total Citations
  • 32
    Total Downloads
  • Downloads (Last 12 months)32
  • Downloads (Last 6 weeks)6
Reflects downloads up to 20 Feb 2025

Other Metrics

Citations

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

HTML Format

View this article in HTML Format.

HTML Format

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media