Strategic Opportunity Mgmt Week 3 Assignment

11/19/22, 4:39 PM MBA 699 Milestone Two Guidelines and Rubric - MBA-699-Q2927 Strategic Opportunity Mgmt 22TW2

https://learn.snhu.edu/d2l/le/content/1202966/viewContent/21559230/View 1/4

MBA 699 Milestone Two Guidelines and Rubric

Scenario

You are a business development manager repor�ng to the vice president (VP) of business development at one of the largest life

sciences organiza�ons in the Midwest.

You are working with the strategic planning team to assess the current data to make recommenda�ons to its board of directors

regarding the organiza�on’s exit strategy. You have started crea�ng your plan for the organiza�onal change and selected members

for the guiding coali�on. Your next task is to help determine the value of the organiza�on’s assets to the poten�al acquirer.

One of the core strengths of the organiza�on lies in the value of its talent. Poten�al buyers in this industry want to know that the

organiza�on 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 organiza�on is worth. This includes taking a close look at the organiza�on’s human

resources, analyzing the a�ri�on data, and making predic�ons about employee stability in case of an acquisi�on.

The organiza�on has been collec�ng informa�on about its employees since its incep�on in 1999; this informa�on has been

organized in a spreadsheet. In order to understand recent trends in your organiza�on's workforce, you will analyze this employee

data. Your analysis will look at employee a�ri�on and reten�on and will be included in your report. This will provide a clear picture

of your organiza�on's workforce to help an�cipate its perceived value with poten�al buyers.

Prompt

First, use the employee a�ri�on data to create visuals in Tableau that capture the trends and possible reasons for reten�on and

a�ri�on in the organiza�on from the course scenario. Then, write a report about the current state of human resources and a�ri�on.

Include screenshots from your visualiza�ons 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 organiza�on.

Specifically, you must address the following criteria:

1. Current employee demographics: Summarize the current employee demographics for the organiza�on from the course

scenario.

a. Use Tableau to visualize the demographic data such as age, sex, marital status, educa�on, and experience, and

include the corresponding screenshots in your summary. Choose the graphs or charts that are best suited to

represent the demographic data.

b. Choose at least two different graph or chart types to represent the demographic data and include the corresponding

screenshots in your wri�en summary. Explain why you have selected the specific chart types to represent your data.

2. A�ri�on analysis: Analyze the given employee data to answer the following ques�ons about a�ri�on in the organiza�on,

including its causes and the rela�onship between a�ri�on 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.

a. Iden�fy five top reasons for a�ri�on.

b. For those who le� the organiza�on, how many years had it been since their last promo�on?

c. At what age does an employee typically exit the organiza�on?

d. A�er how many years of employment does someone typically leave the company?

e. What is the connec�on between how many �mes a year a person was trained, how long they stayed at the



MBA-699-Q2927 Strategic Opportunity Mgmt 22TW2 TM

11/19/22, 4:39 PM MBA 699 Milestone Two Guidelines and Rubric - MBA-699-Q2927 Strategic Opportunity Mgmt 22TW2

https://learn.snhu.edu/d2l/le/content/1202966/viewContent/21559230/View 2/4

organiza�on, and whether they have le�?

3. Reten�on: Compare the a�ri�on analysis data with your current employee details to evaluate and prevent future a�ri�on.

a. Using the trends from the a�ri�on data, determine if more current employees are likely to leave. Explain your

findings.

b. What does your a�ri�on analysis tell you about employee stability in the organiza�on? How is it likely to affect your

organiza�on’s evalua�on by a poten�al buyer?

4. Ac�onable steps: Based on findings from your reten�on analysis, provide three specific ac�ons that the organiza�on can

take to prevent employees from leaving. Provide a ra�onale.

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 informa�on on cita�ons.

Criteria Proficient (100%) Needs Improvement (70%) Not Evident (0%) Value

Employee A�ri�on Analysis Report:

Current Employee Demographics

Summarizes the current employee demographics for the organiza�on from the course scenario; includes visualiza�on of the demographic data such as age, sex, marital status, and experience from Tableau; chooses two graph and chart types that best suit the data; explains the choice

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include summarizing the demographics of the current employees correctly; including all relevant and accurate visuals from Tableau; choosing and explaining at least two different graph and chart types that best reflect the data

Does not a�empt criterion 25

Employee A�ri�on Analysis Report:

A�ri�on Analysis

Analyzes the given employee data to answer all ques�ons about a�ri�on, including its causes and the rela�onship between a�ri�on and various employment factors; includes screenshots of the visual summary of a�ri�on data from Tableau

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include consistency between narra�ve and visuals; including all relevant visuals; answering all ques�ons about employee a�ri�on and its rela�onship to different factors

Does not a�empt criterion 30

Employee A�ri�on Analysis Report:

Reten�on

Explains whether more employees are likely to leave the company and why; evaluates employee stability in the company; explains how this may affect the organiza�on’s evalua�on by a poten�al buyer

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include providing a clear reason why employees may or may not leave the company; evalua�ng employee stability correctly; providing a logical explana�on of how this can affect the organiza�on’s evalua�on by a poten�al buyer

Does not a�empt criterion 20

Employee A�ri�on Analysis Report: Ac�onable Steps

Provides three specific ac�ons that the organiza�on can take to prevent employees from leaving and provides ra�onale

Shows progress toward proficiency, but with errors or omissions; areas for improvement may include providing three specific and relevant ac�ons that the organiza�on can take to prevent employees from

Does not a�empt criterion 15

Milestone Two Rubric

11/19/22, 4:39 PM MBA 699 Milestone Two Guidelines and Rubric - MBA-699-Q2927 Strategic Opportunity Mgmt 22TW2

https://learn.snhu.edu/d2l/le/content/1202966/viewContent/21559230/View 3/4

Reflect in ePortfolio Download Print

Open with docReader

prevent employees from leaving; providing clear, adequate ra�onale for each ac�on

Ar�cula�on of Response

Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstra�ng an understanding of audience and purpose

Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, nega�vely impac�ng readability

Submission has cri�cal errors in grammar, sentence structure, and spelling, preven�ng understanding of ideas

5

Cita�ons and A�ribu�ons

Uses cita�ons for ideas requiring a�ribu�on, with consistent minor errors

Uses cita�ons for ideas requiring a�ribu�on, with major errors

Does not use cita�ons for ideas requiring a�ribu�on

5

Total: 100%

11/19/22, 4:39 PM MBA 699 Milestone Two Guidelines and Rubric - MBA-699-Q2927 Strategic Opportunity Mgmt 22TW2

https://learn.snhu.edu/d2l/le/content/1202966/viewContent/21559230/View 4/4

Task: View this topic

Activity Details