You are a business development manager reporting to the vice

 

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. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Step 1: Read: Review Case Problem 3: TourisTopia Travel Download

Step 1: Read: Review Case Problem 3: TourisTopia Travel Download Case Problem 3: TourisTopia Travelfrom Chapter 13 in the ebook. Step 2: Do: Run the ANOVA: Two-Factor with Replication statistics for the Data File TourisTopia (Chapter 13) using the video How to Add Excel’s Data Analysis ToolPak (Links to an external site.)

tep 1 Plan your speech. Select an occasion or situation

 tep 1 Plan your speech. Select an occasion or situation for your ceremonial speech. Step 2 Review the process of thesis development. Review the information in Lesson 2 of the course about creating a specific purpose statement and thesis, deriving a question based on the thesis, and using the question to

Review The Power of Good Design and select three of

Review The Power of Good Design and select three of the ten principles noted for good design. Next in R, utilize these three principles in a problem that you will solve. First note the problem to solve, the dataset (where the information was pulled from), and what methods you are

PESTLE Analysis on Raymond James Case

PESTLE Analysis on Raymond James Case Paper details Please do a PESTLE Analysis to Raymond James Case (Political, Economic, Social, Technological, Legal, Environmental factors) that affecting recruiting millennials financial advisors. Please be advised that the central problem of the case which need to be solved is shortage of candidates (financial

44. For each of the following situations, you are asked

44. For each of the following situations, you are asked which of two objects or substances has the higher energy. Explain your answer with reference to the capacity of each to do work and say whether the energy that distinguishes them is kinetic energy or potential energy. a. (1) A

The final portfolio project is a three-part activity. You will

 The final portfolio project is a three-part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 sources cited). Start your

Students will be given 3 different child profiles and select

Students will be given 3 different child profiles and select one to complete. The student will read the profile and answer the questions listed below for one scenario. The student should research via professional journals, books, textbooks, and web pages for different recommendations and information to assist you in answering

Discussion Nursing Assignment Help

Assignment 1: Discussion Questions Select one of the two questions from the discussion questions listed below. Be sure to respond to the question using the lessons and vocabulary found in the reading. Justify your answers using examples and reasoning. Support your answers with examples and research and cite your research

Research a current conflict or negotiation in progress from the

Research a current conflict or negotiation in progress from the last six months—for example, peace talks in the Middle East, a corporate merger, or a labor dispute. APA is a must 6-7 page Briefly describe the selected negotiation. Examine the issues versus the interests of the parties involved. Determine how

Motivation Theories

 write as a discussion post style. (Book pages attached) The text discussed many aspects of motivation and the application of motivation theories.  discuss the following question(s): Organizations are using telecommuting/working remotely on an increasing basis over the last 20 years. As with all things, this work structure has it benefits

Management Theories

1. Analyze and evaluate the contributions of management theories (2 pages) – a. Scientific management b. Administrative Management c. Human Relations & Behavioural Management d. Management Science e. Organizational Environment Theory (open systems & contingency theory) 2. Evaluate the above management theories as to their applicability in the UAE/GCC context

For this assignment, you will watch Dr Martin Luther King’s

For this assignment, you will watch Dr Martin Luther King’s I Have a Dream (Links to an external site.) speech and a speech by Alicia Garza of the Black Lives Matter movement (Links to an external site.) and answer questions listed below. Pay special attention to the following aspects in the two

You have been requested to create a write-up for those

  You have been requested to create a write-up for those who are going abroad to help them with their transition. Review the presentation you completed in the previous Module 02 Lab. What training differentiators would you need to add or alter to address travel abroad? What are some other

G.M. Turns to the Chinese to Help Sales in India

  G.M. Turns to the Chinese to Help Sales in India The New York Times TALEGAON, INDIA — General Motors began initial production of its first Chinese-designed car for the Indian market this week, a major step for the U.S. automaker as it tries to grow in a market where

How did the Indian Goods and Services Tax (GST) impact the Meerut

The essay is for the purpose of the International Baccalaureate Extended Essay. The essay should be divided into the following sub categories of impact of GST on revenue, impact of GST profit, impact of GST employment, impact of GST on sales, impact of GST on consumer confidence, impact of GST

SMUM Ethics And Using Law In Decision Making Discussion Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating college assignments and evaluating student performance, my primary goal is to facilitate learning and help students develop a deep understanding of medical concepts. Through lectures, examinations, and assignments, I aim to provide comprehensive instruction and valuable feedback for their

Instructions: You should consider organizing the research paper as follows:

 Instructions:  You should consider organizing the research paper as follows:  • Introduction  • Relevance of the topic (for managing organizational change)  • Main Objective/ Key Question Addressed  • Discussion  • Conclusions    By researching the relevant literature, academic and non-academic resources, this study aims to address the following questions:  1.