Data Analytics for Decision-Making in Evaluating the Top-Performing Product and Developing Sales Forecasting Model in an Oil Service Company
Journal Title: International Journal of Current Science Research and Review - Year 2024, Vol 7, Issue 02
Abstract
This study addresses the strategic challenges faced by a company specialising in the manufacture of oil and gas equipment. Following organisational restructuring, which involved the dissolution of one business unit and the creation of another, the company is navigating complexities in product focus and manpower allocation within the Asia-Pacific region. The research problem centres on identifying the top-performing product, determining potential countries for establishing a support base facility based on sales performance, and developing a method for forecasting future sales. The research involved retrieving and pre-processing historical sales data, then performing a thorough descriptive and predictive analysis. The data was partitioned into training and testing sets to facilitate predictive analytics. Several predictive models were developed and tested, including neural networks, linear regression, gradient-boosted trees, random forests, and ARIMA methods. Tableau Public was utilised for descriptive analytics, whereas RapidMiner Studio was employed for predictive analytics. The study’s results, derived through both descriptive and predictive analytic methods, reveal critical insights. The Blowout Preventer (BOP) emerged as the top-performing product in the Asia-Pacific region. In terms of establishing support base facilities, Malaysia was identified as the ideal location for the BOP, while Indonesia was found suitable for the Manifold product group. Furthermore, the Random Forest model was determined to be the most effective for forecasting future sales. These findings provide strategic guidance for the company in product focus, regional expansion, and resource allocation, contributing significantly to the company’s decision-making process in a competitive industry.
Authors and Affiliations
Ronggo Saputro, Santi Novani,
Keywords
Related Articles
- EP ID EP730643
- DOI 10.47191/ijcsrr/V7-i2-14
- Views 41
- Downloads 0
Circular Economy Transformation in Chemical Industry: Integrating CRM and AI for Sustainable Growth
This white paper explores the pivotal role of Customer Relationship Management (CRM) in the digital transformation journey of the chemical industry. As customer expectations continue to evolve and competition intensifies...
Oil Palm Expansion: Aspects and Gender Roles in Rural Oil Palm Farm Households
This paper comprehends that commercialization in Indonesia, especially in the plantation sector, has increased every year. In this paper, the focus of this research is on oil palm plantations which are expected to increa...
The Motivations of Non-English Major Students: A Case Study at a Private University in Ho Chi Minh City
Motivation is considered as attitudes toward the teacher, students, coursework, curriculum-related activities, and all other elements of the state in which a language is taught. This definition of motivation in language...
Community Conflict Resolution Model in Climate Central Sulawesi Investment
This study is based on the view that Central Sulawesi is a region with increasingly rapid development of the Investment Climate. Not only positive impacts that always occur but also negative impacts. The presence of the...
A Green approach of Ag and Au Nanoparticles, Properties and its Applications: A Review
The emergence of nanotechnology has transformed antimicrobial and cancer treatment methodologies employed by clinicians. Conventional approaches, such as, radiotherapy, hormonal therapy and chemotherapy, now have a conte...