Developing a Business Intelligence Dashboard of Liquid Material at a Toy Manufacturing Company using a System Development Life Cycle (SDLC) Model
Abstract views: 260
,
PDF downloads: 158
Abstract
Fashion doll manufacturers place a substantial emphasis on maintaining aesthetic appeal. One of the most important aspects of preserving a fashion doll's attractive appearance is using liquids to keep the hair in place despite countless shocks and bumps during the distribution process. According to a recent observation on liquid material control at one of the largest toy manufacturing companies worldwide, the process and database had shortcomings that might be fixed by developing a business intelligence dashboard using the SDLC methodology. The SDLC approach was adopted as the improvement methodology. According to the initial observation, improvement can be made by designing a system architecture that includes input data until data visualization. The form was created in Microsoft Forms and integrated into Microsoft Excel, Microsoft Power Automate, and Microsoft Power BI. After being implemented, this enhancement successfully reduced deficiencies and waste. According to the testing findings, all the capabilities perform as the users and stakeholders desired, satisfying all user requirements. Consequently, the organization applies business intelligence to the other departmental areas to visualize the data.
References
S. Maguire, "Towards a 'business-led' approach to information systems development," Inf. Manag. Comput. Secur., vol. 8, no. 5, pp. 230–238, 2000, doi: 10.1108/09685220010353187.
H. J. Watson et al., "BI Training Solutions : As Close as Your Conference Room," Bus. Intell. J., vol. 15, no. 2, pp. 1–57, 2010.
M. H. Abdallah, "A quality assurance model for an information system development life cycle," Int. J. Qual. Reliab. Manag., vol. 13, no. 7, pp. 23–35, 1996, doi: 10.1108/02656719610367560.
K. Gowthami and M. R. P. Kumar, "Study on Business Intelligence Tools for Enterprise Dashboard Development," Int. Res. J. Eng. Technol., vol. 4, no. 4, pp. 2987–2992, 2017, [Online]. Available: https://www.irjet.net/archives/V4/i4/IRJET-V4I4721.pdf
A. Bany Mohammad, M. Al-Okaily, M. Al-Majali, and R. Masa'deh, "Business Intelligence and Analytics (BIA) Usage in the Banking Industry Sector: An Application of the TOE Framework," J. Open Innov. Technol. Mark. Complex., vol. 8, no. 4, p. 189, 2022, doi: 10.3390/joitmc8040189.
M. Golfarelli, S. Rizzi, and I. Cella, "Beyond data warehousing: What's next in business intelligence?," Dol. Proc. ACM Int. Work. Data Warehous. Ol., pp. 1–6, 2004.
S. Rouhani, S. Asgari, and S. Vahid Mirhosseini, "Review Study: Business Intelligence Concepts and Approaches," Am. J. Sci. Res. ISSN, vol. 1450, no. 50, pp. 62–75, 2012, [Online]. Available: http://www.eurojournals.com/ajsr.htm
M. Nakayama, Ö. Isik, N. Sutcliffe, and S. Olbrich, "Grassroots Business Intelligence as an Enabler of Change Management: A Case Study at a Large Global Manufacturing Firm," Complex Syst. Informatics Model. Q., vol. 2020, no. 23, pp. 1–11, 2020, doi: 10.7250/csimq.2020-23.01.
E. M. B. M. Yusof and A. R. M. Yusof, "The Study on the Application of Business Intelligence in Manufacturing," Int. J. Bus. Intell. Res., vol. 4, no. 1, pp. 43–51, 2013, doi: 10.4018/jbir.2013010104.
J. Wang, A. H. Omar, F. M. Alotaibi, Y. I. Daradkeh, and S. A. Althubiti, "Business intelligence ability to enhance organizational performance and performance evaluation capabilities by improving data mining systems for competitive advantage," Inf. Process. Manag., vol. 59, no. 6, p. 103075, 2022, doi: https://doi.org/10.1016/j.ipm.2022.103075.
Y. RIAHI, "Business Intelligence: A Strategy for Business Development," Int. J. Econ. Manag. Stud., vol. 4, no. 9, pp. 1–5, 2017, doi: 10.14445/23939125/ijems-v4i9p101.
C. Olszak and E. Ziemba, "Business Intelligence as a Key to Management of an Enterprise," Proc. 2003 InSITE Conf., no. June, 2003, doi: 10.28945/2672.
D. Barone, E. Yu, J. Won, L. Jiang, and J. Mylopoulos, "Enterprise modeling for business intelligence," Lect. Notes Bus. Inf. Process., vol. 68 LNBIP, pp. 31–45, 2010, doi: 10.1007/978-3-642-16782-9_3.
Y. Y. Lim and A. P. Teoh, "Realizing the strategic impact of business intelligence utilization," Strateg. Dir., vol. 36, no. 4, pp. 7–9, 2020, doi: 10.1108/SD-09-2019-0184.
H. J. Christanto and Y. A. Singgalen, "Analysis and Design of Student Guidance Information System through Software Development Life Cycle (SDLC) dan Waterfall Model," J. Inf. Syst. Informatics, vol. 5, no. 1, pp. 259–270, 2023, doi: 10.51519/journalisi.v5i1.443.
G. Gurung, R. Shah, and D. P. Jaiswal, "Software Development Life Cycle Models-A Comparative Study," Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol., no. July 2020, pp. 30–37, 2020, doi: 10.32628/cseit206410.
H. Taherdoost, "Data Collection Methods and Tools for Research ; A Step-by-Step Guide to Choose Data Collection Technique for Academic and Business Research Projects Hamed Taherdoost To cite this version : HAL Id : hal-03741847 Data Collection Methods and Tools for Resea," Int. J. Acad. Res. Manag., vol. 10, no. 1, pp. 10–38, 2021.
C. Venter and R. Goede, "A critical systems approach to business intelligence system development," Proc. 59th Annu. Meet. Int. Soc. Syst. Sci., no. August 2015, 2015.
S. M. Lee and B. O. Kim, "Developing the information systems architecture for world-class organizations," Manag. Decis., vol. 34, no. 2, pp. 46–52, 1996, doi: 10.1108/00251749610110328.
J. Kharade and M. G. Joshi, "Analyzing and Visualizing in Power Bi," no. August, 2022, [Online]. Available: www.contextures.com
M. G. Bhargava, K. T. P. S. Kiran, and D. R. Rao, "Analysis and design of visualization of educational institution database using power BI tool | global journal of computer science and technology," Glob. J. Comput. Sci. Technol., vol. 18, no. 4, 2018, [Online]. Available: https://computerresearch.org/index.php/computer/article/view/1776
S. Widjaja and T. Mauritsius, "The Development of Performance Dashboard Visualization with Power BI as Platform," Int. J. Mech. Eng. Technol., vol. 10, no. 5, pp. 235–249, 2019, [Online]. Available: http://www.iaeme.com/ijmet/issues.asp?JType=IJMET&VType=10&IType=5http://www.iaeme.com/IJMET/issues.asp?JType=IJMET&VType=10&IType=5
A. Bansal and A. K. Upadhyay, "Microsoft Power BI," Int. J. Soft Comput. Eng., no. 3, pp. 2231–2307, 2017.
Copyright (c) 2023 Anastasia Lidya Maukar, Muhammad Afra Irwansyah
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with Inform: Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi agree to the following terms:
-
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
-
Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
-
Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
