Engineering and Technology
| Open Access |
DOI: Visual Analytics in U.S. Retail: A Data-driven Business Intelligence Framework for Mapping the Retail KPI Matrix
Kazi Obaidur Rahman , MBA (Business Analytics), Gannon University, Erie, Pennsylvania, USA. Achhia Khanam , MBA in Accounting & Business Analytics, Maharishi International University, Fairfield, Iowa Songeta Dhar , DBA (Doctor of Business Administration), Westcliff University, Los Angeles, California, USA. Mehedi Hasan , MBA(Accounting), American International University, Bangladesh. Amir Hamza Akash , MSc. (Statistics & Analytics), University of Arkansas, Fayetteville, Arkansas, USA. Md Ashiqur Rahman Khan , Executive MBA (Management), University of Dhaka, Dhaka, Bangladesh. Shamina Sharmin Jishan , MBS (Accounting), National University, Dhaka, Bangladesh. Fairuz Sadaf Aishwarya , MBA in MIS, International American University, Los Angeles, California, USA.Abstract
Visual analytics approach in mapping the KPIs (Key Performance Indicators) of US retail landscape has become indispensable. Since the US retail has become more dynamic and competitive, intensified by rapidly evolving e-commerce and changing consumer behaviors, retailers tend to rely on this real-time data-driven decision-making approach to remain competitive. Business Intelligence (BI) applications play significant roles in optimizing retail KPI mapping with visual analytics through interactive dashboards, charts, graphs, and KPI matrix.
This research paper proposes a robust framework for visual analytics in optimizing the U.S. retail KPI matrix by integrating the Business Intelligence (BI) tools. This framework supports stakeholders with valuable insights from high-velocity data streams for taking data-driven strategic decisions to stay competitive. In this article, we demonstrate how visual analytics supports stakeholders in decision-making process, enhances interpretability, and maximize outcomes by applying BI application.
The key findings include a set of KPI matrix for a typical U.S. retail entity, interactive dashboards based on this KPIs for visualizing the entity’s operational, financial, and other business performance for taking strategic decision. Here, we integrated business intelligence tools like power BI in developing interactive dashboards, analyzing and visualizing KPIs for enhancing operational efficiency. We believe, this paper will contribute to the growing needs of academic literature on business intelligence applications in U.S. retail analytics. Besides, it enables retail investors and stakeholders to visualize the key business insights, business performance, prospects and opportunities.
Keywords
Retail KPI metrics, Business Intelligence, Visual Analytics, Retail Analytics, U.S. Retail.
References
Rahman, K. O., Islam, M. S., Rezvi, R. I., Hasan, M., Khanam, A., Nasrullah, F., ... & Akash, A. H. (2025). AI-Driven Next-Gen US Retail: An Empirical Study on Optimizing Supply Chains by leveraging Artificial Intelligence, Business Intelligence, and Machine Learning. Journal of Computer Science and Technology Studies, 7(1), 258-264. https://doi.org/10.32996/jcsts.2025.7.1.19x
Few, S., & Perlich, C. (2018). Data Visualization for Business Intelligence. Analytics Press.
Huang, Z., & Benyoucef, M. (2017). From e-commerce to social commerce: A close look at design features. Electronic Commerce Research and Applications, 12(4), 246–259. https://doi.org/10.1016/j.elerap.2013.03.004
Rahman, K. O., Akash, A. H., Hasan, M., Nasrullah, F., & Khanam, A. (2025). Navigating business intelligence: Analyzing and visualizing KPIs of US gas stations with C-store by applying MIS, BI tools charts, graphs, interactive dashboards. Edelweiss Applied Science and Technology, 9(8), 1354-1367. https://doi.org/10.55214/2576-8484.v9i8.9610
Rahman, K. O., Dhar, S., Rahman, S., Khanam, A., Nasrullah, F., Hasan, M., ... & Khan, M. A. R. (2025). Data-Driven Automation: How Robotics and BI Reshape Retail Supply Chains in the United States. Journal of Computer Science and Technology Studies, 7(9), 482-488. https://doi.org/10.32996/jcsts.2025.7.9.55
Rahman, K. O., Aishwarya, F. S., Khanam, A., Akash, A. H., Dhar, S., Nasrullah, F., & Khan, M. A. R. (2025). BI-Driven Accounting Analytics in US Healthcare: Enhancing Financial Transparency and Decision-making Support. Emerging Frontiers Library for The American Journal of Engineering and Technology, 7(10), 130-138. https://doi.org/10.37547/tajet/Volume07Issue10-16
Qualtrics, How to calculate customer lifetime value (CLV) by Adam Bunker, APR 20, 2021. https://www.qualtrics.com/en-gb/articles/customer-experience/
yotpo., Ecommerce Repeat Customer Rate: Track, Calculate & Improve, by Amit Bachbut, September 29, 2025. Repeat Customer Rate: Track, Calculate & Improve It
Experience Benchmarks, 28 Top Consumer NPS Benchmarks: A 2025 Guide by Ian Luck, https://customergauge.com/benchmarks/blog/consumer-nps-benchmarks#:~:text=What%20is%20a%20Net%20Promoter,did%20you%20value%20most/least?
FOURKITES, 8 Critical Supply Chain KPIs and Metrics to Track, https://www.fourkites.com/blogs/8-critical-supply-chain-kpis/#kpi-5
Download and View Statistics
Copyright License
Copyright (c) 2026 Kazi Obaidur Rahman, Achhia Khanam , Songeta Dhar, Mehedi Hasan, Amir Hamza Akash, Md Ashiqur Rahman Khan, Shamina Sharmin Jishan, Fairuz Sadaf Aishwarya
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors retain the copyright of their manuscripts, and all Open Access articles are disseminated under the terms of the Creative Commons Attribution License 4.0 (CC-BY), which licenses unrestricted use, distribution, and reproduction in any medium, provided that the original work is appropriately cited. The use of general descriptive names, trade names, trademarks, and so forth in this publication, even if not specifically identified, does not imply that these names are not protected by the relevant laws and regulations.