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 43
- Downloads 0
Nature’s Healing Touch: Exploring the Therapeutic Benefits of Ecotherapy and Ecopsychology in Cancer Supportive Care
Cancer care demands holistic strategies to address the intricate challenges faced by individuals during their journey. This narrative review explores the emerging field of ecotherapy and ecopsychology, encompassing natur...
Strategy for Embracing Digital Technology at XYZ Life Insurance Company
In the last two decades, insurance markets in industrialised countries have undergone significant transformation due to deregulation, increased competition and globalisation. This evolution has also impacted emerging mar...
Establishing the program to predict Shirt Sizes with Fuzzy Logic
This paper presents a program for prediction shirt size with a fuzzy logic technique. The Mamdani model is applied to a MISO fuzzy system with two inputs and one output. Neck girth and sleeve length are chosen as the pri...
Strategic plan for OmniScripts Deployments and Activation in Vlocity Packages
Vlocity Package deployment involves careful consideration of core concepts, OmniScripts, Vlocity architecture and a clear plan to the CICD pipelines and workflows. Vlocity packages have many essential tools to offer for...
Accreditation and Quality Assurance in World-Leading Universities
Accreditation and quality assurance mechanisms play a critical role in ensuring the standards of higher education globally. In world-leading universities, these processes ensure that academic programs meet established cr...