Problem
Need to prepare Business Report with Jupyter Notebook file
Analysts are required to explore data and reflect on the insights. Clear writing skill is an integral part of a good report. Note that the explanations must be such that readers with minimum knowledge of analytics is able to grasp the insight.
Austo Motor Company is a leading car manufacturer specializing in SUV, Sedan, and Hatchback models. In its recent board meeting, concerns were raised by the members on the efficiency of the marketing campaign currently being used. The board decides to rope in an analytics professional to improve the existing campaign.
You as an analyst have been tasked with performing a thorough analysis of the data and coming up with insights to improve the marketing campaign.
The instructions below are given to help you complete the project -
A. What is the important technical information about the dataset that a database administrator would be interested in? (Hint: Information about the size of the dataset and the nature of the variables)
B. Take a critical look at the data and conduct a preliminary analysis of the variables. Perform a quality check of the data so that the variables are consistent. Are there any discrepancies present in the data?
C. Explore all the features of the data separately by using appropriate visualizations and draw insights that can be utilized by the business.
D. Understanding the relationships among the variables in the dataset is crucial for every analytical project. Perform analysis on the data fields to gain deeper insights. Comment on your understanding of the data.
E. Employees working on the existing marketing campaign have made the following remarks. Based on the data and your analysis state whether you agree or disagree with their observations. Justify your answer Based on the data available. (a) Steve Roger says "Men prefer SUV by a large margin, compared to the women" (b) Ned Stark believes that a salaried person is more likely to buy a Sedan. (c) Sheldon Cooper does not believe any of them; he claims that a salaried male is an easier target for a SUV sale over a Sedan Sale.
F. From the given data, comment on the amount spent on purchasing automobiles across the following categories. Comment on how a Business can utilize the results from this exercise. Give justification along with presenting metrics/charts used for arriving at the conclusions. Give justification along with presenting metrics/charts used for arriving at the conclusions. (a) Gender (b) Personal_loan
G. From the current data set comment if having a working partner leads to purchase of a higher priced car.
H. The main objective of this analysis is to devise an improved marketing strategy to send targeted information to different groups of potential buyers present in the data. For the current analysis use Gender and Marital_status - fields to arrive at groups with similar purchase history.
I. Framing An Analytics Problem, Analyse the dataset and list down the top 5 important variables, along with the business justifications.
J. Quality of Business Report (Refer to the Evaluation Guidelines for Business report checklist. Marks in this criteria are at the moderator's discretion)