Improving the Quality of Service: ETL Implementation on Data Warehouse at Pharmacy Industry

Fardhila Zahra Dwi Wardhani, Jansen Wiratama

Abstract


Pharmacy services are an important part of society and play an irreplaceable role. Availability of medicines is a key factor that needs to be considered in health services. Parapharma, as a company engaged in the supply of medicines, realizes the importance of monitoring and analyzing data to optimize medicine availability. In the ongoing process, monitoring and analyzing data related to pharmacy availability has yet to run optimally because the amount of data is quite large. The monitoring and data analysis process is still carried out conventionally, so decision-making and management of pharmacy availability still need to be optimized. Therefore, through this research, Data Warehouse and Online Analytical Processing (OLAP) will be implemented to support the decision-making process in managing pharmacy availability. The Extract, Transform, and Load (ETL) process integrates data from different sources into a data warehouse. The data is then processed and transformed so that it can be used for further analysis. By implementing a data warehouse and ETL, Parapharma can have fast and efficient access to important information contained in the data. OLAP technology, especially using Mondrian tools, is a means for companies to extract information from data warehouses with the help of interactive visualization. Various visualizations, such as information about laboratories providing the most popular pharmacy brands, the most in-demand types of pharmacys, and the average price per form of pharmacy, can provide significant insight into company strategic decisions. This research resulted in applying data warehouse and OLAP so that Parapharma can obtain accurate and detailed information regarding pharmacy demand and market trends. These research results allow companies to make the right decisions to manage pharmacy production to meet pharmacy needs efficiently. The use of data warehouse and OLAP also positively impacts improving the quality of service to the community.

Full Text:

PDF

References


F. Yusuf, A. Farmasi, Y. Tenaga, P. Arjuna, and T. Samosir, “STUDI PERBANDINGAN OBAT GENERIK DAN OBAT DENGAN NAMA DAGANG,” J. FARMANESIA, vol. 3, no. 1, pp. 5–10, Nov. 2016, Accessed: Dec. 17, 2022. [Online]. Available: http://114.7.97.221/index.php/2/article/view/21

A. Chan, D. Syamsul, M. Farmasi Fakultas Farmasi dan Kesehatan, I. Kesehatan Helvetia, and D. Farmasi Fakultas Farmasi dan Kesehatan, “Gambaran Persepsi Masyarakat Tentang Obat Generik dan Obat Merek Dagang di Daerah Pasar Lam Ateuk Aceh Besar,” J. Dunia Farm., vol. 3, no. 2, pp. 91–99, Oct. 2019, Accessed: Dec. 17, 2022. [Online]. Available: http://ejournal.helvetia.ac.id/index.php/jdf/article/view/4478

A. A. Yulianto, “Extract Transform Load (ETL) Process in Distributed Database Academic Data Warehouse,” Aptikom J. Comput. Sci. Inf. Technol., vol. 4, no. 2, pp. 61–68, Jul. 2019, doi: 10.11591/APTIKOM.J.CSIT.36.

M. C. Ramadhan, J. Wiratama, and A. A. Permana, “A Prototype Model on Development Of Web-Based Decision Support System For Employee Performance Assessments With Simple Additive,” vol. 10, no. 1, pp. 25–32, 2023, doi: 10.30656/jsii.v10i1.6137.

F. Imanuel and F. Tobing, “Implementation of Simple Additive Weighting on Decision Support System for Accoustic Guitar with Web-Based (Study Case: Chaniago Sport)”, Ultima InfoSys : Jurnal Ilmu Sistem Informasi, vol. 13, no. 2, pp. 100-109, Jan. 2023.

S. Suryasari, J. Wiratama, and R. Desanti, “The Development of Web-based Sales Reporting Information Systems using Rapid Application Development Method”, Ultima InfoSys : Jurnal Ilmu Sistem Informasi, vol. 13, no. 2, pp. 110-116, Jan. 2023.

I. A. Najm et al., “OLAP Mining with Educational Data Mart to Predict Students’ Performance,” Informatica, vol. 46, no. 5, pp. 11–19, Mar. 2022, doi: 10.31449/INF.V46I5.3853.

Oracle, “What is Online Transaction Processing (OLTP) | Oracle,” Oracle. https://www.oracle.com/database/what-is-oltp/ (accessed Dec. 18, 2022).

H. Sulistiani, S. Setiawansyah, and D. Darwis, “Penerapan Metode Agile untuk Pengembangan Online Analytical Processing (OLAP) pada Data Penjualan (Studi Kasus: CV Adilia Lestari),” J. CoreIT, vol. 1, no. 1, pp. 1–1, 2020, Accessed: Dec. 18, 2022. [Online]. Available: https://garuda.kemdikbud.go.id/documents/detail/2018816

R. B. Allen, “Metadata for Social Science Datasets Related papers,” in Rich Search and Discovery for Research Datasets: Building the Next Generation of Scholarly Infrastructure, 2020.

Y.-J. Chen et al., “A Comparative Analysis of Extract, Transformation and Loading (ETL) Process,” IOP Conf. Ser. Mater. Sci. Eng., vol. 306, no. 1, p. 012066, Feb. 2018, doi: 10.1088/1757-899X/306/1/012066.

Y. Indarta, D. Irfan, M. Muksir, W. Simatupang, and F. Ranuharja, “Analisis dan Perancangan Database Menggunakan Model Konseptual Data Warehouse Sistem Manajemen Transaksi Toko Online Haransaf,” EDUKATIF J. ILMU Pendidik., vol. 3, no. 6, pp. 1–20, Sep. 2021, doi: 10.31004/EDUKATIF.V3I6.1477.

P. Aritonang, M. Johan, and I. Prasetiawan, “Aspect-Based Sentiment Analysis on Application Review using Convolutional Neural Network”, Ultima InfoSys : Jurnal Ilmu Sistem Informasi, vol. 13, no. 1, pp. 54-61, Aug. 2022.

K. Nagorny, S. Scholze, A. W. Colombo and J. B. Oliveira, "A DIN Spec 91345 RAMI 4.0 Compliant Data Pipelining Model: An Approach to Support Data Understanding and Data Acquisition in Smart Manufacturing Environments," in IEEE Access, vol. 8, pp. 223114-223129, 2020, doi: 10.1109/ACCESS.2020.3045111.

D. Hammouche, M. Loukam, K. Atif and K. W. Hidouci, "Fuzzy MDX queries for taking into account the ambiguity in querying the baccalaureate data warehouse," 2017 4th International Conference on Control, Decision and Information Technologies (CoDIT), Barcelona, Spain, 2017, pp. 0179-0183, doi: 10.1109/CoDIT.2017.8102587.




DOI: https://doi.org/10.33365/jtk.v18i1.3211

Refbacks

  • There are currently no refbacks.


Copyright (c) 2024 Fardhila Zahra Dwi Wardhani, Jansen Wiratama

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Jurnal Tekno Kompak
Published by Universitas Teknokrat Indonesia
Organized by Program Studi D3 Sistem Informasi Akuntansi - Universitas Teknokrat Indonesia
Jl. Zainal Abidin Pagaralam, No.9-11, Labuhanratu, Bandarlampung, Indonesia
Telepon : 0721 70 20 22
W : http://ejurnal.teknokrat.ac.id/index.php/teknokompak
E  : teknokompak@teknokrat.ac.id.

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Jumlah Pengunjung : View Tekno Kompak StatsCounter

Flag Counter