Reference no: EM133681949
Financial Analysis
Question 1: You are the data analyst of a luxury car dealership. You were assigned with the following tasks:
1 What's the most popular car manufacturer?
2 What's the most popular manufacturing country (Refer to "Manufacturing country" sheet)?
3 What's the least popular color for cars?
4 What's the average price per owner?
MAKE SURE TO VISUALIZE THE DATA IN A ONE PAGE SUMMARY
Question 2: You were asked to assist your IT department with migrating information from the old employee system to the new system which was recently implemented.
As the systems databases are different, some details in the new system are missing, and you're required to complete them, as much as possible.
Fill the missing fields in the following worksheet, based on the instructions below:
A Extract the First and Last Name of each employee based on the email address, which is in the following format:
B Retrieve the cities where each employee lives from the old system. In case a certain employee isn't found in the old database, it means that he's a new hire, and therefore the default is London.
C Retrieve the hire date of the employees. In case the hire date is missing, it means that the employee was hired on January 5, 2020.
D If an employee was hired before 2019, it means he's an experienced employee. Otherwise, return "No experience"
E Your company had outstanding financial results in 2020, so the CEO decided to raise the payroll of all the employees in the company, in the following rates:
Employees hired in 2020 - 3% Raise
Employees hired in 2019 - 5% Raise
Employees hired in 2018 or before - 10% Raise
Fill the percentages in the "Payroll Raise %" column accordingly.
Question 3:
Below is the table of 1998-1999 Top Scores in the Premier League:
Complete the following table:
Retrieve the birthday for the following players from the data in "Birthdays" worksheet and complete the table:
How many players scored more than 15 goals?
Question 4:
Using the Data set from Q4
1 Interpret the data
2 Create visuals and explanations of the data
3 Describe relationships you see with the information
4 Present a one page summary of your findings
Attachment:- Financial Analysis.rar