Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution

Riska Indarwati ; Herti Yani ; Beny ; Beny
International Journal of Information Technology an... 📅 2025 Vol 7, No 2 🔗 DOI: 10.24246/ijiteb.722025.21-26
Abstract
Optimization of US Candy's product distribution was conducted through sales data analysis and visualization. The main challenges identified include less strategic factory locations and high logistics costs. This research used a quantitative approach. The purpose of this analysis is to analyze the distribution pattern. Data visualization was conducted using Power BI to show the results of the analysis that New York is the highest selling city with total sales of $10,945.89, with the leading product being Wonka Bar - Scrumdiddlyumptious ($2,718). The consistent increase in sales trend in the fourth quarter of each year, triggered by celebrations such as Halloween, special promotions, and holidays can be utilized to develop future marketing and product inventory strategies. A distribution optimization strategy is recommended to minimize logistics costs and delivery time, by moving distribution to the Wicked Choccy's factory with a distance of 8237.2 km. Marketing strategies such as discounting best-selling products and bundling system for low-selling products are proposed to improve market competitiveness. The resulting interactive dashboard implementation is expected to assist the company in making more accurate and efficient data-based decisions.
Keywords
Data Analysis; Data Visualization; Power BI; Distribution; Logistic Efficiency
How to Cite

Riska Indarwati, et al. (2025). Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution. International Journal of Information Technology and Business (IJITEB), 7(2). https://doi.org/10.24246/ijiteb.722025.21-26

Riska Indarwati; Herti Yani; Beny, Beny, "Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution," International Journal of Information Technology and Business (IJITEB), vol. 7, no. 2, 2025.

Riska Indarwati; Herti Yani; Beny, Beny. "Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution." International Journal of Information Technology and Business (IJITEB), vol. 7, no. 2, 2025.

Riska Indarwati; Herti Yani; Beny, Beny. "Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution." International Journal of Information Technology and Business (IJITEB) 7, no. 2 (2025).

Riska Indarwati, et al. (2025) 'Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution', International Journal of Information Technology and Business (IJITEB), 7(2). doi: 10.24246/ijiteb.722025.21-26.

Riska Indarwati; Herti Yani; Beny, Beny. Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution. International Journal of Information Technology and Business (IJITEB). 2025;7(2).

Artikel Terkait

Resilience of Deep Q-Network (DQN) Agent in Mitigating Ethereum Trading Risks Under Bearish Market Conditions

Adha, Fajri; Widiastuti, Tiwuk; Selvian Djahi, Bertha

An Adaptive AI-Driven Copywriting Framework: Design, Implementation, and Evaluation of a Web-Based GPT-Integrated Content Generation System

Daru, April Firman; Christanto, Febrian Wahyu; Prathivi, Rastri; Prasetyo, Dimas; Firdaus, Eryan Ahmad

Multi-Objective Reinforcement Learning for Supply Chain Optimization in Indonesia’s Free Nutritious Meal Program

Yanto, Budi; Saragih, Rusmin; Lubis, Adyanata; Elyandri Prasiwiningrum; Wahyuny, Romy

Modeling Factors Affecting Vocational School Students’ Perceived Ease of Use of Educational Technology

Hafid, Masruri; Krismiyati, Krismiyati; Diana, Andrushia

Determination of Maintenance Priority Based on Analytical Hierarchy Process for Magnetic Resonance Imaging

Nurdono Nurdono; Muhamad Haddin

Customer Loyalty Analysis Using RFM Model and K-Means Clustering for Marketing Strategy Optimization

Sahertian, Vigo Yano; Yessica Nataliani
Tren Sitasi Jurnal