Designing Customer Analytics Dashboard in Smart Device Retail Using Power BI
Abstract
The adoption of data analytics has led to a paradigm shift in business decision-making, moving from intuition-based to data-driven strategies. Specifically in customer analytics, metrics such as Net Promoter Score (NPS), Customer Satisfaction Score (CSS), and Repeat Purchase Rate (RPR) are widely used to formulate customer retention strategies. Although dashboard applications like Microsoft Power BI support the visualization of these metrics, existing designs lack integrated filtering capabilities based on demographic characteristics such as gender and age group. This study aims to propose a Power BI dashboard application design that integrates NPS, CSS, and RPR with demographic filters to effectively convey customer loyalty, satisfaction, and advocacy. The research methodology includes four stages which are Power BI understanding, data acquisition, data pre-processing, and metric modeling. The dataset was collected by using an online questionnaire in January 2025 (N = 542). It must be validated and transformed before being modeled by using DAX. The proposed dashboard design offers an interactive interface, allowing users to explore insights through chart elements such as bars and pie slices. This design enhances user experience and supports intuitive analysis, making it a valuable tool for smart device retailers and manufacturers to make data-driven decisions. Additionally, the dashboard is adaptable to other business contexts with similar analytical needs. For real-world implementation, the inclusion of Key Performance Indicators (KPIs) for each metric is recommended to ensure that insights are actionable and aligned with business objectives.
Downloads
References
Adebunmi Okechukwu Adewusi, Ugochukwu Ikechukwu Okoli, Ejuma Adaga, Temidayo Olorunsogo, Onyeka Franca Asuzu, and Donald Obinna Daraojimba, “Business Intelligence in the Era of Big Data: A Review of Analytical Tools and Competitive Advantage,” Computer Science & IT Research Journal, vol. 5, no. 2, pp. 415–431, Feb. 2024, doi: 10.51594/csitrj.v5i2.791.
R. Mostaghel, P. Oghazi, V. Parida, and V. Sohrabpour, “Digitalization driven retail business model innovation: Evaluation of past and avenues for future research trends,” J Bus Res, vol. 146, pp. 134–145, Jul. 2022, doi: 10.1016/j.jbusres.2022.03.072.
M. H. Sazu and S. A. Jahan, “How Big Data Analytics Impacts the Retail Management on the European and American Markets?,” CECCAR Business Review, vol. 3, no. 6, pp. 62–72, Jun. 2022, doi: 10.37945/cbr.2022.06.07.
I. Anica-Popa, L. Anica-Popa, C. Rădulescu, and M. Vrîncianu, “The Integration of Artificial Intelligence in Retail: Benefits, Challenges and a Dedicated Conceptual Framework,” Amfiteatru Economic, vol. 23, no. 56, pp. 122–122, 2021, doi: 10.24818/EA/2021/56/120.
R. I. Araf, “A Systematic Review of Data-Driven Insights in Retail: Transforming Consumer Behavior and Market Trend,” Innovatech Engineering Journal, vol. 1, no. 01, pp. 46–55, Nov. 2024, doi: 10.70937/itej.v1i01.6.
M. M. Mohammed, N. A. Mohamed, A. A. Adam, S. S. Ahmed, and F. A. Saeed, “Current Directions and Future Research Priorities of Customer Data Analysis,” Journal of Information Systems and Informatics, vol. 2, no. 2, 2020, doi: 10.33557/journalisi.v2i2.75.
A. Zia, “Discovering the linear relationship of service quality, satisfaction, attitude and loyalty for banks in Albaha, Saudi Arabia,” PSU Research Review, vol. 6, no. 2, pp. 90–104, Aug. 2022, doi: 10.1108/PRR-07-2020-0023.
G. Agag et al., “Understanding the link between customer feedback metrics and firm performance,” Journal of Retailing and Consumer Services, vol. 73, p. 103301, Jul. 2023, doi: 10.1016/j.jretconser.2023.103301.
A. Baquero, “Net Promoter Score (NPS) and Customer Satisfaction: Relationship and Efficient Management,” Sustainability, vol. 14, no. 4, p. 2011, Feb. 2022, doi: 10.3390/su14042011.
J. S. Chauhan, “Brand Loyalty and Its Impact on Repeat Purchase Behaviour of Customers: A Cross-Sectional Study in the FMCG Context,” PsychologyandEducation, vol. 55, no. 1, Jun. 2023, doi: 10.48047/pne.2018.55.1.83.
M. Frizky Feri Setiawan and Y. Condro Winursito, “Operational Data Analysis and Visualization of PT XYZ Using Business Intelligence Approach with Microsoft Power BI,” Journal of Artificial Intelligence and Engineering Applications, vol. 4, no. 2, pp. 2808–4519, 2025, doi: 10.59934/jaiea.v4i2.722.
A. Mishra, “The Role of Data Visualization Tools in Real-Time Reporting: Comparing Tableau, Power BI, and Qlik Sense,” International Journal on Science and Technology (IJSAT) IJSAT20031370, vol. 11, no. 3, 2020, doi: 10.5281/zenodo.14788624.
T. Y. Puspitasari, O. Rohaeni, and E. Harahap, “Aplikasi Power BI pada Perhitungan Iuran Normal dan Kewajiban Aktuaria Menggunakan Metode Accrued Benefit,” Bandung Conference Series: Mathematics, vol. 3, no. 2, pp. 176–183, Aug. 2023, doi: 10.29313/bcsm.v3i2.9211.
Sri Bekti Handayani Ningsih, Iyat Ratna Komala, Leni Nurhayati, and Maya Suhayati, “Visualisasi Data Kependudukan Menggunakan Power Business Intelligence (Studi Kasus Kelurahan Sukamiskin Kecamatan Arcamanik Kota Bandung),” Jurnal Penelitian Sistem Informasi (JPSI), vol. 3, no. 1, pp. 25–39, Jan. 2025, doi: 10.54066/jpsi.v3i1.2944.
Y. Kuo, T. Hu, and S. Yang, “Effects of inertia and satisfaction in female online shoppers on repeat‐purchase intention,” Managing Service Quality: An International Journal, vol. 23, no. 3, pp. 168–187, May 2013, doi: 10.1108/09604521311312219.
S. L. Sondoh Jr., L. Ming Fook, G. H. Tanakinjal, and W. Ling Chai, “Perceived Value and Customer Satisfaction of Smartphone Brand among Youth: The Moderating Effect of Gender,” Malaysian Journal of Business and Economics (MJBE), vol. 7, no. 1, p. 39, Dec. 2020, doi: 10.51200/mjbe.vi.2564.
V. Naneva and K. Stefanova, “Optimization techniques for business intelligence reports,” in Applications of Mathematics in Engineering and Economics (AMEE’20), Sofia: AIP Publishing, Mar. 2021, p. 070010. doi: 10.1063/5.0042199.
V. Naneva and K. Stefanova, “Programming with DAX,” in Applications of Mathematics in Engineering and Economics (AMEE’21), Sofia: AIP Publishing, Sep. 2022, pp. 1–7. doi: 10.1063/5.0102162.
V. Biagi, R. Patriarca, and G. Di Gravio, “Business Intelligence for IT Governance of a Technology Company,” Data (Basel), vol. 7, no. 1, p. 2, Dec. 2021, doi: 10.3390/data7010002.
N. Ali and O. S. Shabn, “Customer lifetime value (CLV) insights for strategic marketing success and its impact on organizational financial performance,” Cogent Business & Management, vol. 11, no. 1, Dec. 2024, doi: 10.1080/23311975.2024.2361321.
K. Kanchanapoom and J. Chongwatpol, “Integrated customer lifetime value (CLV) and customer migration model to improve customer segmentation,” Journal of Marketing Analytics, vol. 11, no. 2, pp. 172–185, Jun. 2023, doi: 10.1057/s41270-022-00158-7.
V. O. Geteloma et al., “Enhanced data augmentation for predicting consumer churn rate with monetization and retention strategies: a pilot study,” Applied Engineering and Technology, vol. 3, no. 1, pp. 35–51, Apr. 2024, doi: 10.31763/aet.v3i1.1408.
C. Kim, J. Kim, G. Jeong, and J. Park, “Estimate Customer Churn Rate with the Review-Feedback Process : Empirical Study with Text Mining, Econometrics, and Quai-Experiment Methodologies,” Information Systems Review, vol. 23, no. 3, pp. 159–175, Aug. 2021, doi: 10.14329/isr.2021.23.3.159.
J. F. Gaitán-Guerrero, J. Luis López Ruiz, M. Espinilla, and C. Martínez-Cruz, “Toward an Interpretable Continuous Glucose Monitoring Data Modeling,” IEEE Internet Things J, vol. 11, no. 19, pp. 31080–31094, Oct. 2024, doi: 10.1109/JIOT.2024.3419260.
R. AlSaad et al., “Multimodal Large Language Models in Health Care: Applications, Challenges, and Future Outlook,” J Med Internet Res, vol. 26, p. e59505, Sep. 2024, doi: 10.2196/59505.
Abstract views: 1410 times
Download PDF: 502 times
Copyright (c) 2025 Journal of Information Systems and Informatics
This work is licensed under a Creative Commons Attribution 4.0 International License.
- I certify that I have read, understand and agreed to the Journal of Information Systems and Informatics (Journal-ISI) submission guidelines, policies and submission declaration. Submission already using the provided template.
- I certify that all authors have approved the publication of this and there is no conflict of interest.
- I confirm that the manuscript is the authors' original work and the manuscript has not received prior publication and is not under consideration for publication elsewhere and has not been previously published.
- I confirm that all authors listed on the title page have contributed significantly to the work, have read the manuscript, attest to the validity and legitimacy of the data and its interpretation, and agree to its submission.
- I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
- I declare that I shall not submit the paper for publication in any other Journal or Magazine till the decision is made by journal editors.
- If the paper is finally accepted by the journal for publication, I confirm that I will either publish the paper immediately or withdraw it according to withdrawal policies
- I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)
