Chat with us, powered by LiveChat You are a business development manager reporting to the | WriteDen

You are a business development manager reporting to the

Scenario

You are a business development manager reporting to the vice president (VP) of business development at one of the largest life sciences organizations in the Midwest.

You are working with the strategic planning team to assess the current data to make recommendations to its board of directors regarding the organization’s exit strategy. You have started creating your plan for the organizational change and selected members for the guiding coalition. Your next task is to help determine the value of the organization’s assets to the potential acquirer.

One of the core strengths of the organization lies in the value of its talent. Potential buyers in this industry want to know that the organization that they acquire is going to be able retain their valuable employees. So, the VP has asked you to analyze the human resource data in order to determine what the organization is worth. This includes taking a close look at the organization’s human resources, analyzing the attrition data, and making predictions about employee stability in case of an acquisition.

The organization has been collecting information about its employees since its inception in 1999; this information has been organized in a spreadsheet. In order to understand recent trends in your organization's workforce, you will analyze this employee data. Your analysis will look at employee attrition and retention and will be included in your report. This will provide a clear picture of your organization's workforce to help anticipate its perceived value with potential buyers.

Prompt

First, use the employee attrition data to create visuals in Tableau that capture the trends and possible reasons for retention and attrition in the organization from the course scenario. Then, write a report about the current state of human resources and attrition. Include screenshots from your visualizations to support your report. Remember to consider the employee’s employment status when visualizing and analyzing the data. The Status column in the spreadsheet indicates whether the employee is a current or former employee of the organization.

Specifically, you must address the following criteria:

  1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario.
    1. Use Tableau to visualize the demographic data such as age, sex, marital status, education, and experience, and include the corresponding screenshots in your summary. Choose the graphs or charts that are best suited to represent the demographic data.
    2. Choose at least two different graph or chart types to represent the demographic data and include the corresponding screenshots in your written summary. Explain why you have selected the specific chart types to represent your data.
  2. Attrition analysis: Analyze the given employee data to answer the following questions about attrition in the organization, including its causes and the relationship between attrition and various employment factors. Use Tableau to create a visual summary of the data and include the corresponding screenshots in your analysis. Choose the graphs or chart types that you believe are best suited to represent the required data.
    1. Identify five top reasons for attrition.
    2. For those who left the organization, how many years had it been since their last promotion?
    3. At what age does an employee typically exit the organization?
    4. After how many years of employment does someone typically leave the company?
    5. What is the connection between how many times a year a person was trained, how long they stayed at the organization, and whether they have left?
  3. Retention: Compare the attrition analysis data with your current employee details to evaluate and prevent future attrition.
    1. Using the trends from the attrition data, determine if more current employees are likely to leave. Explain your findings.
    2. What does your attrition analysis tell you about employee stability in the organization? How is it likely to affect your organization’s evaluation by a potential buyer?
  4. Actionable steps: Based on findings from your retention analysis, provide three specific actions that the organization can take to prevent employees from leaving. Provide a rationale.

Guidelines for Submission

Submit a 5- to 6-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style.

See attached additional relevant information

HR-Employee-Attrition

</t

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.



EmployeeNo. Status Age BusinessTravel Department Education EducationField Gender JobRole JobSatisfaction MaritalStatus MonthlyIncome NumCompaniesWorked PercentSalaryHike PerformanceRating TotalWorkingYears TrainingTimesLastYear WorkLifeBalance YearsAtCompany YearsInCurrentRole YearsSinceLastPromotion
1 Former 41 Travel_Rarely Sales Associate Degree Life Sciences Female Sales Executive Very Satisfied Single 5993 8 11 3 8 0 1 6 4 0
2 Current 49 Travel_Frequently Research & Development High School or Equivalent Life Sciences Male Research Scientist Somewhat Satisfied Married 5130 1 23 4 10 3 3 10 7 1
3 Former 37 Travel_Rarely Research & Development Associate Degree Other Male Laboratory Technician Satisfied Single 2090 6 15 1 7 3 3 0 0 0
4 Current 33 Travel_Frequently Research & Development Graduate Degree Life Sciences Female Research Scientist Satisfied Married 2909 1 11 3 8 3 3 8 7 3
5 Current 27 Travel_Rarely Research & Development High School or Equivalent Medical Male Laboratory Technician Somewhat Satisfied Married 3468 9 12 3 6 3 3 2 2 2
6 Current 32 Travel_Frequently Research & Development Associate Degree Life Sciences Male Laboratory Technician Very Satisfied Single 3068 0 13 3 8 2 2 7 7 3
7 Current 59 Travel_Rarely Research & Development Undergraduate Degree Medical Female Laboratory Technician Unsatisfied Married 2670 4 20 1 12 3 2 1 0 0
8 Current 30 Travel_Rarely Research & Development High School or Equivalent Life Sciences Male Laboratory Technician Satisfied Divorced 2693 1 22 4 1 2 3 1 0 0
9 Current 38 Travel_Frequently Research & Development Undergraduate Degree Life Sciences Male Manufacturing Director Satisfied Single 9526 0 21 4 10 2 3 9 7 1
10 Current 36 Travel_Rarely Research & Development Undergraduate Degree Medical Male Healthcare Representative Satisfied Married 5237 6 13 3 17 3 2 7 7 7
11 Current 35 Travel_Rarely Research & Development Undergraduate Degree Medical Male Laboratory Technician Somewhat Satisfied Married 2426 0 13 3 6 5 3 5 4 0
12 Current 29 Travel_Rarely Research & Development Associate Degree Life Sciences Female Laboratory Technician Satisfied Single 4193 0 12 3 10 3 3 9 5 0
13 Current 31 Travel_Rarely Research & Development High School or Equivalent Life Sciences Male Research Scientist Satisfied Divorced 2911 1 17 3 5 1 2 5 2 4
14 Current 34 Travel_Rarely Research & Development Associate Degree Medical Male Laboratory Technician Very Satisfied Divorced 2661 0 11 3 3 2 3 2 2 1
15 Former 28 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Laboratory Technician Satisfied Single 2028 5 14 3 6 4 3 4 2 0
16 Current 29 Travel_Rarely Research & Development Graduate Degree Life Sciences Female Manufacturing Director Unsatisfied Divorced 9980 1 11 3 10 1 3 10 9 8
17 Current 32 Travel_Rarely Research & Development Associate Degree Life Sciences Male Research Scientist Somewhat Satisfied Divorced 3298 0 12 3 7 5 2 6 2 0
18 Current 22 Nontravel Research & Development Associate Degree Medical Male Laboratory Technician Very Satisfied Divorced 2935 1 13 3 1 2 2 1 0 0
19 Current 53 Travel_Rarely Sales Graduate Degree Life Sciences Female Manager Very Satisfied Married 15427 2 16 3 31 3 3 15 8 3
20 Current 38 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Research Scientist Very Satisfied Single 3944 5 11 2 6 3 3 3 2 1
21 Current 24 Nontravel Research & Development Associate Degree Other Female Manufacturing Director Satisfied Divorced 4011 0 18 3 5 5 2 4 2 1
22 Former 36 Travel_Rarely Sales Graduate Degree Life Sciences Male Sales Representative Unsatisfied Single 3407 7 23 4 10 4 3 5 3 0
23 Current 34 Travel_Rarely Research & Development Graduate Degree Life Sciences Female Research Director Somewhat Satisfied Single 11994 0 11 1 13 4 3 12 6 2
24 Current 21 Travel_Rarely Research & Development Associate Degree Life Sciences Male Research Scientist Very Satisfied Single 1232 1 14 1 0 6 3 0 0 0
25 Former 34 Travel_Rarely Research & Development High School or Equivalent Medical Male Research Scientist Unsatisfied Single 2960 2 11 3 8 2 3 4 2 1
26 Current 53 Travel_Rarely Research & Development Undergraduate Degree Other Female Manager Satisfied Divorced 19094 4 11 3 26 3 2 14 13 4
27 Former 32 Travel_Frequently Research & Development High School or Equivalent Life Sciences Female Research Scientist Unsatisfied Single 3919 1 22 4 10 5 3 10 2 6
28 Current 42 Travel_Rarely Sales Graduate Degree Marketing Male Sales Executive Somewhat Satisfied Married 6825 0 11 3 10 2 3 9 7 4
29 Current 44 Travel_Rarely Research & Development Graduate Degree Medical Female Healthcare Representative Very Satisfied Married 10248 3 14 3 24 4 3 22 6 5
30 Current 46 Travel_Rarely Sales Graduate Degree Marketing Female Manager Unsatisfied Single 18947 3 12 3 22 2 2 2 2 2
31 Current 33 Travel_Rarely Research & Development Undergraduate Degree Medical Male Laboratory Technician Very Satisfied Single 2496 4 11 3 7 3 3 1 1 0
32 Current 44 Travel_Rarely Research & Development Graduate Degree Other Male Healthcare Representative Very Satisfied Married 6465 2 13 3 9 5 4 4 2 1
33 Current 30 Travel_Rarely Research & Development Associate Degree Medical Male Laboratory Technician Satisfied Single 2206 1 13 3 10 5 3 10 0 1
34 Former 39 Travel_Rarely Sales Undergraduate Degree Technical Degree Male Sales Representative Very Satisfied Married 2086 3 14 3 19 6 4 1 0 0
35 Former 24 Travel_Rarely Research & Development Undergraduate Degree Medical Male Research Scientist Very Satisfied Married 2293 2 16 3 6 2 2 2 0 2
36 Current 43 Travel_Rarely Research & Development Associate Degree Medical Female Research Scientist Satisfied Divorced 2645 1 12 3 6 3 2 5 3 1
37 Former 50 Travel_Rarely Sales Associate Degree Marketing Male Sales Representative Satisfied Married 2683 1 14 3 3 2 3 3 2 0
38 Current 35 Travel_Rarely Sales Undergraduate Degree Marketing Female Sales Representative Very Satisfied Married 2014 1 13 3 2 3 3 2 2 2
39 Current 36 Travel_Rarely Research & Development Graduate Degree Life Sciences Female Research Scientist Unsatisfied Married 3419 9 14 3 6 3 4 1 1 0
40 Current 33 Travel_Frequently Sales Undergraduate Degree Life Sciences Female Sales Executive Unsatisfied Married 5376 2 19 3 10 3 3 5 3 1
41 Current 35 Travel_Rarely Research & Development Associate Degree Other Male Laboratory Technician Very Satisfied Divorced 1951 1 12 1 1 3 3 1 0 0
42 Current 27 Travel_Rarely Research & Development Graduate Degree Life Sciences Female Laboratory Technician Unsatisfied Divorced 2341 1 13 3 1 6 3 1 0 0
43 Former 26 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Laboratory Technician Satisfied Single 2293 1 12 1 1 2 2 1 0 0
44 Current 27 Travel_Frequently Sales Undergraduate Degree Life Sciences Male Sales Executive Satisfied Single 8726 1 15 3 9 0 3 9 8 1
45 Current 30 Travel_Frequently Research & Development Associate Degree Medical Female Laboratory Technician Very Satisfied Single 4011 1 23 4 12 2 3 12 8 3
46 Former 41 Travel_Rarely Research & Development Undergraduate Degree Technical Degree Female Research Director Satisfied Married 19545 1 12 3 23 0 3 22 15 15
47 Current 34 Nontravel Sales Graduate Degree Marketing Male Sales Executive Satisfied Single 4568 0 20 4 10 2 3 9 5 8
48 Current 37 Travel_Rarely Research & Development Associate Degree Life Sciences Male Research Scientist Somewhat Satisfied Married 3022 4 21 2 8 1 3 1 0 0
49 Current 46 Travel_Frequently Sales Graduate Degree Marketing Male Sales Executive Very Satisfied Single 5772 4 21 4 14 4 3 9 6 0
50 Current 35 Travel_Rarely Research & Development High School or Equivalent Life Sciences Male Laboratory Technician Very Satisfied Married 2269 1 19 3 1 2 3 1 0 0
51 Former 48 Travel_Rarely Research & Development Associate Degree Life Sciences Male Laboratory Technician Satisfied Single 5381 9 13 3 23 2 3 1 0 0
52 Former 28 Travel_Rarely Research & Development Graduate Degree Technical Degree Male Laboratory Technician Satisfied Single 3441 1 13 3 2 3 2 2 2 2
53 Current 44 Travel_Rarely Sales Doctorate Marketing Female Sales Executive Unsatisfied Divorced 5454 5 21 4 9 2 2 4 3 1
54 Current 35 Nontravel Research & Development Associate Degree Medical Male Healthcare Representative Unsatisfied Married 9884 2 13 3 10 3 3 4 0 2
55 Current 26 Travel_Rarely Sales Undergraduate Degree Marketing Female Sales Executive Very Satisfied Married 4157 7 19 3 5 2 2 2 2 0
56 Current 33 Travel_Frequently Research & Development Associate Degree Life Sciences Female Research Director Very Satisfied Single 13458 1 12 1 15 1 3 15 14 8
57 Current 35 Travel_Frequently Sales Doctorate Life Sciences Male Sales Executive Unsatisfied Married 9069 1 22 4 9 3 2 9 8 1
58 Current 35 Travel_Rarely Research & Development Graduate Degree Medical Female Laboratory Technician Unsatisfied Married 4014 3 15 3 4 3 3 2 2 2
59 Current 31 Travel_Rarely Research & Development Graduate Degree Life Sciences Male Laboratory Technician Very Satisfied Divorced 5915 3 22 2 10 3 2 7 7 1
60 Current 37 Travel_Rarely Research & Development Graduate Degree Life Sciences Male Manufacturing Director Satisfied Divorced 5993 1 18 3 7 2 4 7 5 0
61 Current 32 Travel_Rarely Research & Development Undergraduate Degree Medical Male Manufacturing Director Very Satisfied Married 6162 1 22 4 9 3 3 9 8 7
62 Current 38 Travel_Frequently Research & Development Doctorate Life Sciences Female Laboratory Technician Very Satisfied Single 2406 1 11 3 10 2 3 10 3 9
63 Current 50 Travel_Rarely Research & Development Associate Degree Medical Female Research Director Satisfied Divorced 18740 5 12 3 29 2 2 17 3 13
64 Current 59 Travel_Rarely Sales Undergraduate Degree Life Sciences Female Sales Executive Unsatisfied Single 7637 7 11 3 28 3 2 21 16 7
65 Current 36 Travel_Rarely Research & Development Undergraduate Degree Technical Degree Female Healthcare Representative Satisfied Divorced 10096 1 13 3 17 2 3 17 14 12
66 Current 55 Travel_Rarely Research & Development Undergraduate Degree Medical Female Manager Satisfied Divorced 14756 2 14 3 21 2 3 5 0 0
67 Current 36 Travel_Frequently Research & Development Undergraduate Degree Life Sciences Male Manufacturing Director Somewhat Satisfied Single 6499 1 13 3 6 3 3 6 5 0
68 Current 45 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Research Scientist Unsatisfied Divorced 9724 2 17 1 25 2 3 1 0 0
69 Current 35 Travel_Frequently Research & Development Undergraduate Degree Medical Male Research Scientist Unsatisfied Married 2194 4 13 1 5 2 2 3 2 1
70 Former 36 Travel_Rarely Research & Development Undergraduate Degree Medical Male Research Scientist Satisfied Married 3388 0 17 3 2 0 2 1 0 0
71 Current 59 Travel_Frequently Sales High School or Equivalent Life Sciences Female Sales Executive Satisfied Single 5473 7 11 3 20 2 2 4 3 1
72 Current 29 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Research Scientist Somewhat Satisfied Married 2703 0 23 2 6 3 3 5 4 0
73 Current 31 Travel_Rarely Research & Development Graduate Degree Medical Male Research Scientist Somewhat Satisfied Single 2501 1 17 3 1 4 3 1 1 1
74 Current 32 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Male Research Scientist Somewhat Satisfied Married 6220 1 17 3 10 3 3 10 4 0
75 Current 36 Travel_Rarely Research & Development Undergraduate Degree Life Sciences Female Laboratory Technician Very Satisfied Married 3038 3 12 3 5 3 3 1 0 0
76 Current 31 Travel_Rarely Research & Development Graduate Degree Life Sciences Female Manufacturing Director Very Satisfied Single 4424 1 23 4 11 2 3 11 7 1
77 Current 35 Travel_Rarely Sales Graduate Degree Marketing Male Sales Executive Unsatisfied Single 4312 0 14 3 16 2 3 15 13 2
78 Current 45 Travel_Rarely Research & Development Graduate Degree Other Male Research Director Unsatisfied Married 13245 4 14 3 17 3 4 0 0 0
79 Current 37 Travel_Rarely Research & Development Graduate Degree Medical Male Research Director Satisfied Single 13664 4 13 3 16 3 4 5 2 0
80 Current 46 Travel_Rarely Human Resources Associate Degree Medical Male Human Resources Somewhat Satisfied Divorced 5021 8 22 4 16 2 3 4 2 0
81 Current 30 Travel_Rarely Research & Development High School or Equivalent Life Sciences Male Laboratory Technician Very Satisfied Married 5126 1 12 3 10 1 2 10 8 3
82 Current 35 Travel_Rarely Research & Development Undergraduate Degree Medical Male Research Scientist Satisfied Single 2859 1 18 3 6 3 3 6 4 0
83 Current 55 Travel_Rarely Sales Associate Degree Life Sciences Male Sales Executive Very Satisfied Married 10239 3 14 3 24 4 3 1 0 1