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 20
- Downloads 0
Exploring Pragmatics: Uncovering the Layers of Language and Meaning
The dynamic interaction of pragmatics, semantics, and culture in language understanding and communication is examined in this narrative review. The review emphasizes how pragmatics and semantics provide complementary vie...
The Effect of Capital Adequacy, Non-Performing Financing, Efficiency, And Liquidity on Financial Performance in Sharia Commercial Banks in Indonesia
This study aims to examine the effect of capital adequacy, non-performing financing, efficiency, and liquidity on the level of financial performance at Islamic Commercial Banks in Indonesia. This study is a population st...
The Effect of Corporate Social Responsibility Disclosure, Dividend Policy on Earning Management with Audit Quality as Moderation Variable in Listed Manufacturing Companies in Indonesian Stock Exchange (2018-2022)
This research aims to test and prove empirically the effect of independent variables, namely corporate social responsibility disclosure, dividend policy on the dependent variable is earnings management and audit quality...
Examining the Distributional Characteristics of Daily Returns of Nifty 50: Normality Assessment and Implications
This paper investigates the distributional characteristics of daily returns of the Nifty 50 index, a benchmark index comprising 50 large-cap stocks traded on the National Stock Exchange of India. Utilizing historical dat...
Dermatitis Secondary to Exposure to Nickel and Fragrance at Workplace: A Case Report
Allergic contact dermatitis may be caused by exposure to chemicals. The skin usually develops type IV sensitivity where the initial sensitization may occur a few days but it may take years to develop in low grade exposur...