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 54
- Downloads 0
Eco-Innovation and Non-Eco-Innovation in Shaping Financial Performance: The Moderating Role of Online Consumer Reviews from Indonesian Cosmetic Industry
This study examines the relationship between eco-innovation, non-eco-innovation, online consumer reviews, and financial performance within the Indonesian context. Data from Indonesian companies were analyzed using quanti...
Tax Aggressiveness in Indonesia: Insights From CSR, Financial Dynamics, and Governance
This study explores the impact of CSR, leverage, profitability, and independent commissioners on tax aggressiveness in 45 food and beverage companies on the Indonesian Stock Exchange from 2013 to 2017. The analysis, usin...
Design and Development of Overcurrent Protection Relay Inverse Definite Minimum Time Type Based on Arduino Uno
An overcurrent protection relay is an essential component in electrical system to protect devices from damage due to excessive current. The Inverse Definite Minimum Time (IDMT) type has a trip time that depends on the ma...
Utilization of Buton Granular Asphalt (BGA) as Asphalt and Filler Content Substitution Material - in Asphalt Concrete Mixture- Wearing Course
Roads are one of the infrastructure that is urgently needed in improving the accessibility of an area and has a crucial role as a connecting infrastructure that facilitates the transportation of people and goods. This ro...
Research Trends in Islamic-Based Mathematics Education: Global Studies and Academic Collaboration Networks
This study analyzes global trends and collaboration in mathematics education research during the 2014–2024 period using a bibliometric approach. The findings indicate a significant increase in the number of publications,...