HMC CASE STUDY Prepared for: Prof. Adi Prananto Organization Name: PWAV Analytics PHYU PHYU TWIN - 104096236 WASIF ALI - 103147162 ALANA MYATT - 103614352 VANESSA CHUA - 103492257 22/10/2022 1
Executive Summary Huskie Motor Company (HMC) is a relatively new player in the automobile manufacturing industry, with production and sales sites spreading over South America, North America, and Europe. This report analyzes critical data from HMC's database by using Tableau software to produce valuable insights about threats and opportunities in the business model. Further insights are revealed through the processing of HMC's big data by comparing visualizations from all sectors for a holistic view of HMC's performance. Four categories of analytics are manipulated to create four interactive dashboards that may be used by different levels of management to assist in their overall strategy and monitor their operations in both the short run and the long run. Categories include Overall Performance Analysis, Financial Analysis, Operational Analysis, and Forecasting. Some recommendations are made at the conclusion of the report, and these should be investigated thoroughly before making any strategic decisions that would heavily impact the business. 2
Table of Contents Executive Summary 2 Introduction 4 Overview of HMC & the Automobile Industry. 5 Dataset 6 Insights 7 Overall Performance Analysis 7 Financial Analysis. 11 Operational Analysis 15 Forecasting 20 Recommendations 23 Other Critical Issues 23 Conclusion 24 Reference List 25 Appendix 26 3