Br Hombing, Nova Magdalena
Unknown Affiliation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

Perancangan Data Warehouse Untuk Mendukung Keputusan Strategi Pemasaran Dalam Penjualan Br Hombing, Nova Magdalena; Simanjuntak, Welmi; Wijaya, Andri
Journal Of Informatics And Busisnes Vol. 3 No. 3 (2025): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v3i3.3855

Abstract

Operational sales data is often fragmented, impeding management from developing data driven marketing strategies. This research aims to conceptually design a data warehouse to support sales marketing strategy decision making. The method utilizes a descriptive-conceptual approach employing the Kimball’s Nine-Step methodology on the Superstore Sales Data (2025) dataset from Kaggle. The resulting design is a Star Schema, which integrates historical data (customer, product, region, and time). Via the ETL (Extract, Transform, Load). The derived multidimensional analysis yields critical insights: Furniture products are the primary profit drivers, the Home Office segment demonstrates superior profitability, and the Q4 seasonal pattern (October-December) is the consistent sales speak. This data warehouse model proves effective in providing structured, actionable insights for marketing profit optimization.