Essay Available:
Pages:
5 pages/≈1375 words
Sources:
3
Style:
APA
Subject:
Management
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 24.3
Topic:
MBA 699 (3-1)
Essay Instructions:
MBA 699 Milestone Two Guidelines and Rubric
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:
Current employee demographics: Summarize the current employee demographics for the organization from the course scenario.
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.
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.
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.
Identify five top reasons for attrition.
For those who left the organization, how many years had it been since their last promotion?
At what age does an employee typically exit the organization?
After how many years of employment does someone typically leave the company?
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?
Retention: Compare the attrition analysis data with your current employee details to evaluate and prevent future attrition.
Using the trends from the attrition data, determine if more current employees are likely to leave. Explain your findings.
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?
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.
What to Submit
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.
Essay Sample Content Preview:
MBA 699 (3-1)
Student’s Name
Institution Affiliation
Course Name
Instructor
Date
MBA 699 (3-1)
Current Employee Demographics
Figure 1: Age
Figure 1 is an area graph. The choice of the graph is to provide clarity on the count of employees in each category. In addition, the graph in Figure 1 includes categories of employees through age bins. The bins enable clarity on the age distribution across different age groups. Further, each bin has a length of 5 years to enable a fair distribution across all ages.
Figure 2: Gender
For Figure 2, the choice is a bar chart. Justification for the choice of the bar chart is the few numbers of items under visualization. Only 2 items are on display; hence the bar chart allows for simplicity in comparison. The choice of color is also based on the need for effectiveness in creating a visual contrast. The order of items is on the basis of smallest to largest for effectiveness in attaining a visual impression.
Figure 3: Marital status
Figure 3 features a pie chart. The items under the image are few; hence, simplicity in visual comparison is present. In addition, each employee falls under either of the categories. Therefore, comprehensiveness is present to cover each item. The choice of colors is for visual effectiveness. High contrast from the colors is present, enabling viewers to discern the count in each of the 3 segments.
Figure 4: Education levels
The display for Figure 4 comprises bubble charts. The use of the tool for presentation creates a visually appealing image. Further, the bubble chart has a special advantage in comparing different data sets in a single chart. The size of each bubble corresponds to the quantity of the respective item (Qin et al., 2019). The use of different colors enables clarity in establishing the quantities of each item.
Figure 5: Experience
Figure 5 is a bar chart. The rationale behind using the bar chart is that it provides data summaries in a concise manner (Qin et al., 2019). Figure 5 presents data on three aspects that demonstrate the scope of working experience. The data captures the years that an employee has served in the current role, the duration worked for the company, and the total working years. The data combines three variables and concisely presents the findings.
Attrition Analysis
According to Subhashini & Gopinath (2020), one cause of employee attrition is a need for career growth opportunities. The absence of channels to advance an employee's career frustrates an employee. When an organization lacks career growth opportunities, employees seek alternatives and lose interest in their current jobs. To counter attrition, the work by Subhashini & Gopinath (2020) advances the idea organizations must adopt a culture of continuous learning and offer career pathways. The techniques enhance employee engagement and motivation, reducing attrition rates. The next section visualizes data to establish attrition rates in line with the variables under consideration.
Figure 6: Attrition and years since last promotion
Based on Figure 6, attrition is directly proportional to an employee's duration for a promotion. However, the positive relationship between the duration since the last promotion and attrition is positive up to a certain point. The curve takes a sharp turn that demonstrates a negative association. T...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now: