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

Assemble nursing care interventions for clients with behavioral or cognitive

  Assemble nursing care interventions for clients with behavioral or cognitive disorders. Scenario Lauren has been diagnosed with Social Anxiety Disorder and experiences obsessive thoughts that result in compulsive behaviors. This has a major impact on her life and day to day functioning. Instructions View the videos segments 1, 2,

READ THESE INSTRUCTION FIRST The instructions ask you to critique

   READ THESE INSTRUCTION FIRST The instructions ask you to critique an argument. Critiquing an argument means the following. The focus should not be on whether the conclusion of the argument is correct. Rather, the focus should be on whether the reasons given in the argument are correct and whether

This is a class dicussion, i dont need a full

This is a class dicussion, i dont need a full page. to be honet i this i need 5 sentences   With the popularity of so many types of media, there are many more outlets for composers than ever before. Within film alone, composers can find avenues of exploration in almost

How to make the Project, The project is due week

How to make the Project, The project is due week 6th, 1-  Select a disease related to your course, 2-  Search for 3 sources discussing this disease, one from on-line sources, one from a book, and other from any journal or Magazine,   Some online Web sites, https://my.clevelandclinic.org/health/diseases https://www.mayoclinic.org/diseases-conditions Library

Strategic, Operational, and Tactical Intelligence

 Strategic, Operational, and Tactical Intelligence Prior to beginning work on this discussion, please complete the assigned readings and access and review the required websites. During this discussion, you will examine the contributory roles of strategic, operational, and tactical intelligence in the prevention, mitigation, and recovery from domestic hostilities, threats, hazards

As outlined in the first two chapters of BSZ, economics

 As outlined in the first two chapters of BSZ, economics focuses on the choices that people make. In the simplest of terms, we can consider a choice to be rational if and when the benefits of that choice are at least as great as its costs (or, conversely, if the

Exercise The threaded discussion will provide the student with the

The threaded discussion will provide the student with the opportunity to explore different topics, share what he/she is learning with classmates, and gain clarity about the content. This assignment reflects student centered independent learning. The student will:• Apply critical thinking through participation of selected topics• Engage in thoughtful discourse with

PORTFOLIO PROJECT / HoneyBOT

 Description Hands-On Project – HoneyBOT® HoneyBOT® is a simple honeypot for beginners to use. Honeypots can give you a good idea of how many people are probing your machine for weaknesses. Without a honeypot, you may not be able to tell if anyone is scanning your machine. In this example,

System Implementation Paper

Develop a system implementation process that can be applied to any complex information system that the healthcare organization intends to adopt. Include how these systems are selected, evaluate who needs to be on the implementation team and why. Identify the roles needed for the completion of a successful project. Provide

Prompt: This is a continued writing assignment of Company Profile

  Prompt: This is a continued writing assignment of Company Profile project, complete the Company Profile – Section 4 – Summary & Recommendations.   Section 4. Summary & Recommendations (no more than 5 full content pages, excluding graphs/tables)   Recommendations must reflect your industry and organizational analysis. Provide a set of

Document Analysis

Document Analysis (5% – c. 500 words) Primary sources are writings that were produced by individuals or groups at the time of the historical events or issues that they deal with. A number of such documents have been placed on Blackboard, organized by course unit. This assignment requires you to

In consideration of Sara’s privacy and in an effort to

 In consideration of Sara’s privacy and in an effort to educate members of the organization of the possible outbreak, what strategies/steps should the Department of Human Resources (HR) do to ensure health information is provided to all stakeholders? Explain each strategy and offer concrete information to support your viewpoint. Explain

Suppose that a researcher is interested in estimating the mean

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

In reviewing the QSEN competencies, which competency do you feel

 In reviewing the QSEN competencies, which competency do you feel is most important? (There is no right or wrong answer here.) Give specific examples of how you have applied this competency to your current nursing practice with respect to patient safety. How will you apply this competency to your nursing

Thinking about the organization you have chosen to focus on,

   Thinking about the organization you have chosen to focus on, discuss how leadership influences organizational culture overall, and, specifically, as it relates to inclusion of diverse people. Explain why it is important for leaders to be inclusive of diverse people and cultures, and any personal experience you have with

For this assignment, please submit a draft of your final

For this assignment, please submit a draft of your final paper. Recall that your final paper should contain the following sections: An introduction (with a clear thesis) Literature Review Background information on your company and industry Analysis (that is, applying one of our three models to your company or industry)

Substantive response to peer, further the conversation, ask a question

Substantive response to peer, further the conversation, ask a question APA format Cite 1 peer-review reference 175-200 words Respond to the following:   Joshua Bridges 6:24 PM The country that fascinates me the most on the list is Russia. Russian culture is much like the U.S., in the aspect that