Claim Missing Document
Check
Articles

Dimensional Data Design for Event Feedback Data Warehouse Fattah, Ahmad Maulana Malik; Ridwan, Taufik; Sulistiyowati, Nina
JISA(Jurnal Informatika dan Sains) Vol 6, No 1 (2023): JISA(Jurnal Informatika dan Sains)
Publisher : Universitas Trilogi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31326/jisa.v6i1.1648

Abstract

Data is an important asset and a fundamental requirement for building valuable information for organizations. Association of Information Systems Students of Unsika (Himsika) as a university organization provides many events to develop student’s academic and professional skills. A post-event evaluation through a feedback survey was conducted and stored in Google Sheets spreadsheet format. However, the current analysis process using spreadsheets lacks standardization, making it difficult to compare satisfaction rates over time and between events. Additionally, the lack of standardization leads to semi-structured data on spreadsheets, with varying question formats and meanings. To address these limitations, implementing a centralized data warehouse is proposed as a solution. The data warehouse would provide a structured and standardized approach to analyzing event feedback, enabling better comparisons and evaluation of management quality within Himsika. The research aims to design a data warehouse that supports multidimensional analysis. As a way to simplify and optimize analytical queries, the data structure is standardized in the data warehouse. The Four-step Dimensional Design method is applied in designing dimensional modeling on the data warehouse, consisting of four stages including selecting the business process, declaring the grain, identifying the dimensions, and identifying the facts. The design process resulted in 4 dimensions of events, dim_instances, dim_degree_programs, and dim_professions, and a fact table called fact_rates_by_responses. Overall, the proposed data warehouse and dimensional modeling approach aim to enhance the analysis and evaluation of Himsika’s events.
ANALISIS POLA PEMBELIAN KOMBINASI PRODUK PADA UMKM YOUNAHIJAB.ID DI SHOPEE MENGGUNAKAN ALGORITMA APRIORI (STUDI KASUS: YOUNAHIJAB.ID) Solihah, Frisca Dwi Imroatus; Hannie, Hannie; Ma'sum, Aziz; Ridwan, Taufik; Sulistiyowati, Nina
JUSTIN (Jurnal Sistem dan Teknologi Informasi) Vol 14, No 1 (2026)
Publisher : Jurusan Informatika Universitas Tanjungpura

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.26418/justin.v14i1.94749

Abstract

Persaingan yang semakin ketat di platform e-commerce seperti Shopee menuntut pelaku UMKM untuk mengembangkan strategi pemasaran berbasis data agar tetap kompetitif. Younahijab.id merupakan salah satu UMKM di bidang fashion muslimah yang mengalami penurunan penjualan pada tahun 2024. Kondisi ini menyebabkan penurunan omzet dan penumpukan stok produk yang tidak terjual. Oleh karena itu, penelitian ini bertujuan untuk menganalisis pola pembelian konsumen menggunakan pendekatan data mining guna merumuskan strategi bundling produk yang efektif sesuai kebiasaan belanja pelanggan. Metode yang digunakan adalah Association Rule Mining dengan algoritma Apriori serta menerapkan tahapan Knowledge Discovery in Database (KDD), yang mencakup data selection, data cleaning, data transformation, data mining, dan evaluation. Data yang digunakan berasal dari 11.055 transaksi penjualan Younahijab.id di Shopee selama Januari hingga Desember 2024. Hasil penelitian ini memberikan rekomendasi strategi bisnis bundling produk berdasarkan pola 1-itemset dan 2-itemset, dengan total sebanyak 24 frequent itemsets. Dengan parameter minimum support sebesar 3%, confidence 30%, dan lift 2,0, ditemukan tiga aturan asosiasi utama, yaitu aturan antara produk P0015 dan P0004 dengan nilai confidence sebesar 55,67% dan lift 2,78, serta asosiasi terkuat antara produk P0008 dan P0006 dengan nilai confidence 76,43% dan lift 2,67. Penelitian ini diharapkan dapat meningkatkan efektivitas promosi, mempercepat perputaran stok, dan mendorong peningkatan penjualan Younahijab.id di Shopee.