Operational Data Analysis and Visualization of PT XYZ Using Business Intelligence Approach with Microsoft Power BI

M. Frizky Feri Setiawan; Yekti Condro Winursito

doi:10.59934/jaiea.v4i2.722

Authors

M. Frizky Feri Setiawan Universitas Pembangunan Nasional "Veteran" Jawa Timur
Yekti Condro Winursito Universitas Pembangunan Nasional "Veteran" Jawa Timur

DOI:

https://doi.org/10.59934/jaiea.v4i2.722

Keywords:

Business Intelligence, Data Visualization, Microsoft Power BI, Operational Data

Abstract

The study aims to analyze and visualize operational data at PT XYZ, a furniture manufacturing company, utilizing Business Intelligence methods with Microsoft Power BI. A systematic approach was employed, encompassing data import, transformation, cleaning, and visualization, to develop an interactive dashboard that enhances decision-making. Key findings indicate that certain production sections consistently met or exceeded their targets, while others revealed opportunities for improvement. Insights into service wage distribution, standard time requirements, and target realizations were derived from the dashboard. The research identified sections with high service wages and highlighted areas with elevated standard times, suggesting a need for efficiency enhancements. Recommendations include focusing on underperforming sections and optimizing operations to reduce service wages. The study concludes that the developed dashboard supports data-driven decision-making, ultimately contributing to improved operational performance within the companys.

Downloads

Download data is not yet available.

References

M. I. Salman, and R. W. P. Pamungkas, "Business Intelligence Analysis of Electronic Sales Data 2014 - 2017," Nusantara Journal of Multidisciplinary Science., vol. 1, no. 12, pp. 712-722, 2024.

A. Purnama, and I. N. Y. A. Wijaya, and I. B. K. Sudiatmika, "Application Of Business Intelligence To Analyze Sales Data Using Power BI," JINTEKS (Jurnal Informatika Teknologi dan Sains)., vol. 4, no. 2, pp. 118-123, 2022.

R. Akbar, and D. Rasyiddah, and M. Anrisya, and N. F. Julyazti, and S. Syaputri, "Implementation of Power Business Intelligence Applications In Analyzing Work Priorities in Indonesia," JEPIN (Jurnal Edukasi dan Penelitian Informatika)., vol. 4, no. 1, pp. 54-49, 2018.

N. P. J. Purwantini, and I. N. Y. A. Wijaya, and K. Q. Fredlina, "Implementation Of Business Intelligence To Determine Sales Trends," SMART TECHNO (Smart Technology, Informatic, and Technopreneurship)., vol. 2, no. 2, pp. 73-87, 2020.

Sinuhaji, F. G., Sibarani, H. J., & Pakpahan, V. M. (2024). MSMEs and the Role of Technology in Achieving Business Sustainability. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 4(1), 588–593. https://doi.org/10.59934/jaiea.v4i1.724

Suhardi, S., Ichsan, N., Priyandaru, H. ., & Ikhwanul Ihsan, F. (2024). Comprehensive Analysis of Ethical Marketing Strategies and Customer Engagement in TikTok Business. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 3(3), 760–765. https://doi.org/10.59934/jaiea.v3i3.509

Lubis, R. K., A M H Pardede, & Husnul Khair. (2023). Digital Signature Security Analysis By Applying The Elgamal Algorithm And The Idea Method. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 3(1), 373–382. https://doi.org/10.59934/jaiea.v3i1.336

Andini, N. A. M., Dellia, P., Ferdiansyah, Abd. Ghaffar, & Rohimah, S. (2024). Analysis of User Satisfaction with the Dana Application Using the Technology Acceptance Model (TAM) Method. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 3(3), 824–828. https://doi.org/10.59934/jaiea.v3i3.519

Andreas, A. G., Prita Dellia, Rahma, S. R., Nurqomariah, J., Soleha, R., & Sentiawati, I. (2024). Analysis of User Experience (UX) in the Use of the TikTok Shop Application with the HEART Metrics Method. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 3(3), 820–823. https://doi.org/10.59934/jaiea.v3i3.520

Rozan, M. A., Dellia, P., Soleha, Hamdani, Puspita, C. A., & Zakariya, R. A. (2024). Analysis of User Satisfaction with The Implementation of The Shopee Application Using the TAM Method. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 3(3), 829–833. https://doi.org/10.59934/jaiea.v3i3.521

Rizky Ulyani, Suhartini, & Nur Aini H. (2024). User Experience Analysis on the DANA Application Using the User Experience Questionnaire (UEQ) Method. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 4(1), 252–256. https://doi.org/10.59934/jaiea.v4i1.617