How many players scored more than 15 goals

Reference no: EM133681949

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

Reference no: EM133681949

Questions Cloud

What did you learn about yourself as an inclusive leader : What did you learn about yourself as an inclusive leader? How might you better develop leadership skills to be a more inclusive leader in your organization?

What happens in market for building materials due to event : An ongoing, chronic shortage of long-haul drivers is creating major issues with trucking. What happens in the market for building materials due to this event?

What is role of processing in ultimate cup flavor profile : Summary of team sensory evaluations: Why does coffee taste so different? What is the role of processing in ultimate cup flavor profile? Copper Door takeways?

Which is a tool safety tip that can help you stay safe : Workers using power tools and equipment should follow tool. Which is a tool safety tip that can help you stay safe when using power tools and other equipment?

How many players scored more than 15 goals : BMGT 1003 Financial Analysis, Georgian College - What's the most popular car manufacturer? 2 What's the most popular manufacturing country

What else can your employer do to protect you from overhead : Your employer can protect you from overhead power lines by requiring you to maintain. What else can your employer do to protect you from overhead power lines?

Which would be included specifically in job specifications : As HR Director, you oversaw a job analysis for the customer service. Which of these would be included specifically in the job specifications for the position?

Which major advantage of the skills approach would relevant : If you were working to train a group of leaders to improve, which major advantage of the skills approach would be particularly relevant to your work?

User Account

All Pages