A Real Time Dashboard for Asset Monitoring in Power BI: An Overview
Article Sidebar
Main Article Content
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.
Downloads
References
Howson, C. Successful business intelligence: Secrets to making BI a killer app., 2007, McGraw-Hill Osborne Media
Rasmussen, N. H., Bansal, M., & Chen, C. Y. Business dashboards: a visual catalog for design and deployment.,2009, John Wiley & Sons.
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
Adamala, S. & Cidrin, L. Key Success Factors in Business Intelligence. Journal of Intelligence Studies in Business, Vol. 1(1), 2011.
Alaskar, T., & Efthimios, P. Business Intelligence Capabilities and Implementation Strategies. International Journal of Global Business, Vol. 8 (1), pp. 34- 45, 2015.
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.
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.
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
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
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
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.
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
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
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.
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
Belghith, M., Ben Ammar, H., Masmoudi, F., & Elloumi, A. Data Visualization for Industry 4.0: Developing, 2021.
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.
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.
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.
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.
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.
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.
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.
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.
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
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
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
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.
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.