MBA 699 Milestone Two

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.

Struggling to find relevant content? Order a custom essay on
MBA 699 Milestone Two
Let our experts save you the hassle
Order Now

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.
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.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Nurse
Great work! Thank you for the quality you put in each assignment.
Customer 452707, February 4th, 2022
Philosophy
excellent job i will be coming back for any future papers if I have too.
Customer 452611, October 11th, 2021
IT, Web
Don did an excellent job!!!
Customer 452885, January 25th, 2023
Nursing
Thank you!
Customer 452707, June 29th, 2022
Psychology
The paper is well written and professional. I highly recommend
Customer 452485, August 22nd, 2021
Management
Great job
Customer 452643, October 31st, 2021
Business and administrative studies
GREAT
Customer 452813, June 20th, 2022
Nursing
Excellent work!! Thanks again!
Customer 452707, October 14th, 2022
Philosophy
i got the paper a bit late but it is good quality will for sure come back and use this website.
Customer 452611, September 9th, 2021
Other
Thank you for a well written paper!!!
Customer 452557, January 19th, 2022
Human Resources Management (HRM)
Great Work!
Customer 452767, November 18th, 2022
Social Work and Human Services
Thank you
Customer 452559, July 2nd, 2021
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
error: Content is protected !!

Save More. Score Better. Use coupon code SPECIAL for a 15%discount