<![CDATA[This study presents the design of a data warehouse to support analysis of product trends and popular brands in e-commerce sales. The system integrates sales data from multiple sources through the ETL (Extract, Transform, Load) process and applies a star schema model. Using multidimensional analysis (OLAP), insights on monthly trends, brand performance, and product sales variations over time were generated. The results show that the designed data warehouse effectively supports operational decision-making and marketing strategies. Keywords: data warehouse, e-commerce, OLAP, ETL, star schema Abstrak Penelitian ini membahas perancangan data warehouse untuk mendukung analisis tren produk dan brand populer pada penjualan e-commerce. Sistem dirancang untuk mengintegrasikan data penjualan dari berbagai sumber (pelanggan, produk, transaksi), melalui proses ETL (Extract, Transform, Load), lalu dianalisis menggunakan model star schema. Analisis data menggunakan visi multidimensi (Online Analytical Processing) menghasilkan insight tren per bulan, performa brand, serta variasi penjualan produk dalam periode tertentu. Hasil rancangan ini menunjukkan bahwa data warehouse mampu mendukung keputusan operasional dan strategi pemasaran. Kata kunci: data warehouse, e-commerce, OLAP, ETL, star schema]]>
Copyrights © 2026
