Claim Missing Document
Check
Articles

Found 3 Documents
Search
Journal : INTECOMS: Journal of Information Technology and Computer Science

DESIGNING A DATA MART FOR OPTIMIZING CLOTHING SALES AT C STORE Limbor, Ellen Gabriel; Beng, Jap Tji; Arisandi, Desi; Tiatri, Sri; Nurkholiza, Rahmiyana; Salsabila, Tasya Mulia; Dinatha, Vienchenzia Oeyta Dwitama
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/7k3f3443

Abstract

Data plays a crucial role in supporting strategic decision-making, particularly in the retail sector like C Store. To enhance sales performance and understand purchasing trends, an effective system such as a data mart is needed. This study aims to design a data mart that can be used to analyze sales data at C Store to support data-driven decision-making. The methodology used is the nine-step Kimball approach in data mart design. The ETL (Extract, Transform, Load) process is used to manage sales transaction data collected from the period of 2021 to 2024. The result of this study is a data mart with a star schema, consisting of fact and dimension tables, enabling the analysis of sales performance based on product categories and time. The implementation of this data mart is expected to assist C Store in managing data efficiently, supporting strategic decision-making, and improving business operational effectiveness. Keywords: Data Mart, Kimball's Nine-Step Process, Clothing Sales.
DATA MART DESIGN FOR Y CLOTHING STORE SALES Wijaya, Angeline Carolina; Beng, Jap Tji; Arisandi, Desi; Tiatri, Sri; Dinatha, Vienchenzia Oeyta Dwitama; Nurkholiza, Rahmiyana; Sefira, Fasia Meta
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/qr7rg481

Abstract

The data mart design for Y Clothing store aims to integrate scattered sales data to simplify analysis and speed up business decision making. Using the Kimball Nine-Step method and ETL process, sales transaction data from 2019 to 2023 is managed in a star schema. As a result, these data marts enable faster and more accurate analysis, identifying customer purchasing patterns, sales trends and promotional effectiveness. Implementation of this data mart increased inventory management efficiency by 15% and reduced sales report generation time from hours to minutes. However, challenges such as significant resource allocation for initial implementation and a learning curve for employees slowed down the maximum benefit gain somewhat. However, overall, these data marts contribute greatly to improved business decisions and more effective sales strategies. Keywords: Data Mart, Y Clothing Store, Kimball Nine-Step Method, ETL Process, Star Schema.
DESIGNING A DATA WAREHOUSE FOR AIRLINE TICKET SALES AT PT ABC Qadriah, Sekar Aurannisa Ramdhani; Beng, Jap Tji; Arisandi, Desi; Nagm, Fouad; Salsabila, Tasya Mulia; Zahro, Tiara; Dinatha, Vienchenzia Oeyta Dwitama
INTECOMS: Journal of Information Technology and Computer Science Vol. 8 No. 5 (2025): INTECOMS: Journal of Information Technology and Computer Science
Publisher : Institut Penelitian Matematika, Komputer, Keperawatan, Pendidikan dan Ekonomi (IPM2KPE)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31539/hfhqv835

Abstract

The high demand for airline ticket purchases in Indonesia and ticket sales being one of the important assets for companies in the aviation industry. PT ABC requires a system that can effectively manage this data to support business analysis and strategic decision-making. This research aims to design a data warehouse that can integrate airline ticket sales data, enabling more efficient data storage, processing, and analysis. The approach used in the design of this data warehouse is the star schema, which consists of one main fact table and several dimension tables. The fact table contains ticket sales transaction data, while the dimension tables include information about time, flight routes, airlines, and customers. This research provides a primary contribution in the form of a data warehouse design that integrates airline ticket sales data, enabling faster and more accurate analysis. The resulting business impact includes increased operational efficiency, more accurate data-driven decision-making, and the ability to monitor sales trends in real-time through interactive dashboards. With this data warehouse, PT ABC can reduce data analysis time and improve the accuracy of sales trend predictions. Keywords: Data warehouse, Star Schema, PT ABC plane ticket sales, Business Intelligence.