Claim Missing Document
Check
Articles

Found 2 Documents
Search

Analisa Penjualan Barang Menggunakan Data Warehouse Pada PT. XYZ Syaputri, Tia Dwi; Zaidi, Luthfi; Ivanka Putri, Nazwa Maharani; Ivanka Putri, Zahwa Anggarini; Gunawan Hts, Dedek Indra
Jurnal Sains dan Teknologi Widyaloka (JSTekWid) Vol. 3 No. 2 (2024): JSTekWid (July 2024)
Publisher : Akademi Manajemen Informatika dan Komputer Widya Loka Medan

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54593/jstekwid.v3i2.282

Abstract

Penelitian ini mengeksplorasi implementasi gudang data di PT XYZ, perusahaan ritel fashion pria berskala nasional di Indonesia, dengan 100 outlet tersebar di seluruh negeri. Gudang data memfasilitasi integrasi dan analisis data penjualan dari berbagai sumber, memungkinkan PT XYZ untuk mengidentifikasi tren produk, performa penjualan regional, dan pola pembelian pelanggan. Temuan utama menunjukkan bahwa kaos adalah produk terlaris, menunjukkan permintaan pasar yang kuat. Analisis penjualan regional mengungkapkan Jakarta sebagai pasar yang performanya tinggi, menyarankan adanya peluang untuk strategi pemasaran yang terfokus dan optimisasi inventaris. Selain itu, pola pembelian pelanggan, seperti kecenderungan untuk membeli kemeja dan celana secara bersamaan, memberikan peluang untuk promosi bundling dan strategi diskon. Tantangan meliputi memastikan kualitas dan konsistensi data melalui proses ETL yang efektif. Secara keseluruhan, gudang data telah meningkatkan efisiensi operasional, merancang strategi pemasaran yang lebih baik, dan mendalami wawasan pelanggan bagi PT XYZ.
Peningkatan Efisiensi Operasional WAZ-8 Laundry Melalui Pelatihan Pengelolaan Data dan Keuangan Menggunakan Microsoft Excel Thanri, Yan Yang; Riza, Bob Subhan; Iriani, Juli; Subhan, Zhafira Nur; Zaidi, Luthfi
Publikasi Pengabdian Masyarakat Vol 4 No 2 (2024): PUBLIDIMAS Vol. 4 No. 2 NOVEMBER 2024
Publisher : LPPM Universitas Potensi Utama

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.22303/publidimas.v4i2.402

Abstract

Improving operational efficiency in laundry businesses greatly depends on effective data and financial management. WAZ-8 Laundry, a growing laundry business, faces challenges in managing transaction data and finances, which are still performed manually and ineffectively. Therefore, a training program on data and financial management using Microsoft Excel was organized to enhance operational efficiency and service quality provided to customers. This training aimed to equip WAZ-8 Laundry staff with the skills to manage transaction data, financial records, and operational reports effectively using Microsoft Excel. The training covered basic Excel techniques, table creation, data processing, the use of financial formulas, as well as financial report generation and data analysis for more accurate decision-making. By leveraging Excel features such as pivot tables, charts, and formulas, participants were expected to speed up the process of financial record-keeping and analysis, thereby identifying business trends and making better plans. The training employed a hands-on approach, with participants simulating data management and financial report generation in Excel. In addition, participants were also educated on the importance of accurate and structured data management to support better decision-making in laundry operations. Evaluation results indicated that most participants showed improved understanding of Excel usage, especially in financial report creation and transaction data analysis. Evaluation was conducted through pre-tests and post-tests, along with observation during the training. Post-test results showed an average score improvement of approximately 80%, reflecting better understanding of data and financial management. Participants also demonstrated improved abilities in operating Excel features such as pivot tables and financial formulas, which were previously less understood. Therefore, this training provides a significant impact on improving the operational performance of WAZ-8 Laundry, particularly in more efficient and effective data and financial management, ultimately supporting the business's growth.