Analysis-of-the-Business-Operation-of-Autoprosales

A Comprehensive Appreciation and Analysis of the company data, Relevant justifications, assumptions, and Recommendations.

PROJECT BRIEF

As a data analytics firm, you have been approached by a reputable multinational company to perform an analysis of their business operations. The company is currently undergoing an audit in preparation for investment from a global hedge fund and they need to prepare information to present to the hedge fund managers to ensure a successful investment round.

In the process of the analysis, the company will also want to find out strategies they can employ to show the hedge fund they can overcome any shortcomings found during the audit. As part of your efforts to solve the organisation’s problem I am to demonstrate a very good appreciation of the data, the relevant justifications and assumptions required as well as the conditions at which the relationship being examined will stand.

PROCESSES UNDERTAKEN TO ASSIST IN THE SUCCESFUL INVESTMENT

1. A brief review of industry and firm selection, including competitive analysis.
2. Employed the descriptive analysis methodology to ascertain the company's key performance indicators.
3. Created a dashboard that displays the KPIs mentioned in pointer 2 and made sure the right slicers are attached to make it interactive.
4. Chose any of the KPIs mentioned in pointer 2 above and created a 5-quaters forecasting model by considering different approaches and suggesting a suitable approach along with explanations.
5. Used the performance indicators listed in pointer 2 as a guide, determined the nature of the relationships between the indicators, and built a reliable model to determine the associations between the variables chosen. Gave reasons for choosing these particular variables. Discussed the many restrictions discovered in the model.
6. As part of measures to improve the revenue base of the company under consideration, I constructed an association analysis for the company’s products.
7. In the writeup,I highlighted, with justification which associations will improve revenue and recommended ways the company can improve sales by capitalizing on those associations.
8. An evaluation of sentiments that customers have of the company’s products/services based on reviews should be constructed.
9. In the write-up, I highlight, with justifications, the relevant sentiments of the products and recommended how the company can capitalize on those to improve sales.
10. In the write-up, I justified the conditions I employed in my analysis and told the managers which conditions lead to increased sales.

FILES IN THIS REPOSITORY

1. A written report to be presented to the directors of the company.
2. An Excel workbook showcasing the visualized data.
3. An Excel workbook showing the projections and regressions done.
4. A Google colab notebook with the codes used for the sentimen and association analysis
5. All the datasets used for the analysis.