A Real Time Dashboard for Asset Monitoring in Power BI: An Overview

Abstract- This paper explores the development and analysis of two methodologically aligned dashboards: the HR Analytics Dashboard and the Coffee Sales Dashboard. Both dashboards were developed to demonstrate the transformative power of data analytics. This improvs decision-making across diverse domains. The HR Analytics Dashboard focuses on workforce metrics for example attrition rates, recruitment efficiency, and employee performance etc. The Coffee Sales Dashboard focuses on sales performance, customer trends, and inventory management. This paper includes data collection methods, preprocessing techniques, analytical models, visualization strategies, insights derived, and the potential for cross-domain applications. This integrated approach highlights the versatility of data analytics tools, particularly Power BI, in managing and interpreting complex datasets.

HR Analytics, Coffee Sales Dashboard, Data Visualization, Power BI, Business Insights, Data Analytics

1. Howson, C. Successful business intelligence: Secrets to making BI a killer app., 2007, McGraw-Hill Osborne Media [Google Scholar] [Crossref]

2. Rasmussen, N. H., Bansal, M., & Chen, C. Y. Business dashboards: a visual catalog for design and deployment.,2009, John Wiley & Sons. [Google Scholar] [Crossref]

3. Pauwels K., et. al. “Dashboards as a Service : Why, What, How, and What Research Is Needed?”, Journal of Service Research 12(2),175-289, 2009 DOI:10.1177/1094670509344213 [Google Scholar] [Crossref]

4. Adamala, S. & Cidrin, L. Key Success Factors in Business Intelligence. Journal of Intelligence Studies in Business, Vol. 1(1), 2011. [Google Scholar] [Crossref]

5. Alaskar, T., & Efthimios, P. Business Intelligence Capabilities and Implementation Strategies. International Journal of Global Business, Vol. 8 (1), pp. 34- 45, 2015. [Google Scholar] [Crossref]

6. Dowding D. et.al., Dashboard for improving patient care: Review of the literature, International journals of medical Informatics, Volume 84 Issue 2, February, Pages 87-100, 2015. [Google Scholar] [Crossref]

7. Singh P., Upadhyay, R.K. & Srivastava, M., “The role of HR analytics in higher education institution”, International Journal of Engineering Sciences & Research Technology, Vol. 6, No. 7, pp. 92-100, 2017. [Google Scholar] [Crossref]

8. M.G. Bhargava, Analysis and Design of Visualization of Educational Institution Database using Power BI Tool Global Journal of Computer Science and Technology: C Software & Data Engineering Volume 1 Issue 4 Version 1.0 Year 2018 Online ISSN: 0975-4172 & Print ISSN: 0975-4350 [Google Scholar] [Crossref]

9. P. Dutta, “Business Analytics using Microsoft Power BI and AWS Redshift,” Int. J. Trend Sci. Res. Dev., vol. Volume-3, no. Issue-2, pp. 984–986, 2019, doi: 10.31142/ijtsrd21545 [Google Scholar] [Crossref]

10. M. M. Abdulla, “Using Microsoft Power BI and Data Visualization Tools to Study How Online Shopping was Affected During COVID19 Period: A Comparison in Three Countries Between 2019 and 2020,” pp. 3591–3600, 2023, doi: 10.46254/an12.20220651 [Google Scholar] [Crossref]

11. Reena, R, Ansari, M.M.K. and Jayakrishnan, S.S., “Emerging trends in human resource analytics in upcoming decade”, International Journal of Engineering Applied Sciences and Technology, Vol. 4, No. 8, pp. 260-264, 2019. [Google Scholar] [Crossref]

12. R.Matheus et. Al., Data science empowering the public: Data-driven dashboards for transparent and accountable decision-making in smart cities, Government Information Quarterly Volume 37,Issue 3, July 2020, 101284 [Google Scholar] [Crossref]

13. J. Reinking, et. Al. Synthesizing enterprise data through digital dashboards to strategically align performance: Why do operational managers use dashboards?, International Journal of Accounting Information System, Volume, 2020, 100452 [Google Scholar] [Crossref]

14. Cherukuri, H., Pandey, P., & Siddharth, E., Containerized data analytics solutions in on-premise financial services. International Journal of Research and Analytical Reviews (IJRAR), 7(3), 481-491, 2020. [Google Scholar] [Crossref]

15. H.H.D.P.J. Opatha, (2020), HR Analytics: A Literature Review and New Conceptual Model, International Journal of Scientific and Research Publications, Volume 10, Issue 6, ISSN 2250-3153, 2020. DOI:10.29322/IJSRP.10.06.2020.p10217 [Google Scholar] [Crossref]

16. Belghith, M., Ben Ammar, H., Masmoudi, F., & Elloumi, A. Data Visualization for Industry 4.0: Developing, 2021. [Google Scholar] [Crossref]

17. M. Raje Et.al., Sales Analysis And Prediction Dashboard Using Power Bi, International Research Journal of Modernization in Engineering Technology and Science Volume:03/Issue:06, e-ISSN:2582-5208, 2021. [Google Scholar] [Crossref]

18. T. Susnjak et.al., Learning analytics dashboard: a tool for providing actionable insights to learners, International Journal of Educational Technology in Higher Education, Volume 19, Article No. 12, 2022. [Google Scholar] [Crossref]

19. G. Shoaib et.al., Power Bi Dashboard for Data Analysis, International Research Journal of Engineering and Technology (IRJET), Volume: 09 Issue: 07, www.irjet.net p-ISSN: 2395-0072 e-ISSN: 2395-0056, 2022. [Google Scholar] [Crossref]

20. Psarommatis, F.; Danishvar, M.; Mousavi, A.; Kiritsis, D., Cost-Based Decision Support System: A Dynamic Cost Estimation of Key Performance Indicators in Manufacturing. IEEE Trans. Eng. Manag., 1–13, 2022. [Google Scholar] [Crossref]

21. P. R. C. Patil, A. Desai, P. Jadhav, M. Jamadar, S. Koli, and S. Shirole, “Sales analysis using power bi,” no. 04, pp. 1561–1563, 2022. [Google Scholar] [Crossref]

22. M. D. Jadhav et. Al.M. D. Jadhav et. Al., HR People Data Analytics Using Power Bi Data Visualization Tool, International Journal of Research Publication and Reviews, Vol 3, no 4, pp 3335-3338, ISSN 2582-7421, 2022. [Google Scholar] [Crossref]

23. M. S. Singh and M. L. Jadhav, “Data Analysis and Visualization of Sales Dataset using Power BI,” Int. J. Res. Appl. Sci. Eng. Technol., vol. 10, no. 6, pp. 1749–1759, 2022. [Google Scholar] [Crossref]

24. M. S. Singh and M. L. Jadhav, “Data Analysis and Visualization of Sales Dataset using Power BI,” Int. J. Res. Appl. Sci. Eng. Technol., vol. 10, no. 6, pp. 1749–1759, 2022, doi: 0.22214/ijraset.2022.44132, 2022. [Google Scholar] [Crossref]

25. J. M. Pais (2023),The evolution of dashboard in research : An VOSviewer analysis Published in: 2023 18th Iberien Conference on Information system and Technologies (CISTI) DOI: 10.23919/CISTI58278.2023.10211741 Publisher: IEEE [Google Scholar] [Crossref]

26. C. T. Goncalves, (2023), Developing Integrated Performance Dashboards Visualisations Using Power BI as a Platform special issue Artificial Intelligence (AI) for Economics and Business Management,Information 2023, 14(11), 614; https://doi.org/10.3390/info14110614 [Google Scholar] [Crossref]

27. K. K. Tirupati et.al., Leveraging Power BI for Enhanced Data Visualization and Business Intelligence September 2024, SHODH SAGAR® ISSN: 2348-5612, Vol. 10, Issue 2, Peer Reviewed & Refereed University Research Reports 10(2):676-711, 2023. DOI:10.36676/urr.v10.i2.1375 [Google Scholar] [Crossref]

28. K.V. Metre ,(2024), An Introduction to Power BI for Data Analysis, International journal of Intelligent system and application in Engineering, Vol. 12 No. 1s, ISSN 2147-6799, 2024. [Google Scholar] [Crossref]

• Wind Turbine Design for Low Wind Speed Applications: Advancing Renewable Energy Systems Through Wind Tunnel Experiments
• Fast Identification for Evidences in Crime Scene with Macroscopic Properties and Portable Techniques
• Evaluating the Impact of Hello Interval Timer on OSPF Performance for Real-Time Applications Using OPNET
• The Algorithmic Fortress: Ai-Powered Cybersecurity and Anti-Fraud in The Future of Fintech
• Accident Detection on Curved Roads Using Infrared Sensors in Hilly Regions A Case of Chadoora Tehsil, Badgam (J&K)