Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribedimage text in transcribedimage text in transcribed
  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.
image text in transcribedimage text in transcribedimage text in transcribed
MBA 699 Er X @ MBA 699 M X Course Her X @ MBA 699 M x certificate x Order Conf X V X B Module On X @ Module Twc X MBA 699 M X Life Science X + C a learn.snhu.edu/content/enforced/948883-MBA-699-X3610-OL-TRAD-GR.22TW3/Course%20Documents/MBA%20699%20Organizational%20Chart.pdf?_&d2|SessionVal=hkQA2JHP9njMz3jRGvEgm... Q E Life Sciences Firm 1 / 1 90% + Organization chart MBA 699 Life Sciences Organization Mirjam Nilsson President Augusta Bergqvist Omar Mattsson Flora Berggren Elaine Hartwick John Martensson lan Hansson VP Business Development Manufacturing Director VP Worldwide Sales Acting Director Research Director VP Human Resources You! Angelica Astrom Chris Botting April Hansson Patrick Heaton Stan Raffety Business Development Supply Chain Strategies Sales Executive Marketing Manager Research Lab Manager Human Resources Manager Manager Juanita Gonzalez Nidal Eidwa Leslie Krupp Mei Zheng Business Development Middle Eastern Operations Sales Rep Research Lab Manager Manager lan Smith Joanne Lawrence North American Operations Research Lab Manager PDF MBA 699 Organiza....pdf PDF MBA 699 Organiza...pdf PDF MBA 699 Employe....pdf Show all X 4:51 PM O EPIC w Rain coming 1/9/2022Module On X B Module Twc X B MBA 699 M X Life Science X MBA 699 Er X B MBA 699 M X Course Her X @ MBA 699 M x certificate x Order Confi X + V X - > C a learn.snhu.edu/content/enforced/948883-MBA-699-X3610-OL-TRAD-GR.22TW3/Course%20Documents/MBA%20699%20Employee%20Personas.pdf?_&d21SessionVal=hkQA2JHP9njMz3jRGvEgmU... @ MBA 699 Employee Personas.pdf 1 / 3 68% + 1 Name Job Role Characterization Past Span of Time a Job Years Experience Control the Satisfaction Since With M&A Organizati n Last MBA 699 Employee Personas on (Years) (1=low Promoti =high) on The first step in putting together the kind of team that can direct a change effort is to find Omar Manufacturi Highly successful Omar came to Manages 12 n/a the right members. Characteristics of effective guiding coalition members are: ng Director director, the firm manufacturin A combination of management and leadership skills to develop both plans and vision responsible for through an plants Position power ning up the acquisition comprising Expertise (discipline, work experience, decision-making ability) company's supply and has been 580 hourly Credibility (good reputation with the firm, in the industry, or both) chain in the Middle pleased with workers East. Although he how the The VP of the life sciences organization you are working for has identified the following ometimes "rubs integration employees who might be suitable for inclusion in the guiding coalition eople the wrong has gone so way," he has proven far. effective. Name Job Role Characterization Past Span of Time at Job Years John Research John is responsible A member of Oversees the 22 15 Experience Control the Satisfactio Since Director Last for the scientific the firm's company's With M&A Organizati n research behind the founding research labs on (Years) (1=low Promoti 4=high) on company's flagship team, he has in three oncology drug, and seen more countries, a Business Extremely Juanita has Individual n/a "doesn't stop until mergers fail including Developmen intelligent, never been contributor the job is done." than succeed. more than t Manager motivated, and involved in a (niece of one 100 scientists (your productive, she has merger or an of the firm's Leslie Sales Rep During her tenure Leslie has Individual counterpart) been struggling acquisition, owners) with the firm, Leslie been through contributor lately with but she has consistently met more change managing her time worked at a her sales targets, in her career and commitments firm during its exceeding her than most since returning from complete quotas every sales reps. maternity leave. reorganization quarter. She has been told that she Stan Human Often characterized Formerly Individual could "sell ice cubes Resources as "a complacent involved in a contributor to Eskimos." Manager member of human workforce Elaine Acting Although she has a Elaine is a Manages 18 10 resources," Stan is deployment Director reputation for being strong leader senior usually the point of change difficult to work when it comes managers contact who is initiative, he with, Elaine is to adapting to (direct assigned to has familiarity known for changing reports) company-wide with what appreciating situations. committees. works (and complementary doesn't work) strengths in others in a guiding and is often called coalition. "a true visionary." S B3 N 9 EPIC w 4:51 PM O 25 P Rain coming 1/9/2022Module On X B Module Twc X B MBA 699 M X Life Science X MBA 699 Er x MBA 699 M X Course Her X @ MBA 699 M x certificate x Order Confi X + V X -> C a learn.snhu.edu/content/enforced/948883-MBA-699-X3610-OL-TRAD-GR.22TW3/Course%20Documents/MBA%20699%20Employee%20Personas.pdf?_&d21SessionVal=hkQA2JHP9njMz3jRGvEgmU... @ MBA 699 Employee Personas.pdf 3 / 3 - 68% + Name Job Role Characterization Past Span of Time at Job Years Experience Control the Satisfaction Since With M&A Organizati n Last on (Years) (1=low, Promoti 4=high) on Chris Sales Known for Chris led the Oversees 10 Executive "micromanaging," integration of more than Chris has a realistic two prior 150 sales sense of his acquisitions reps around weaknesses and while at the world limitations another company. O EPIC - W P 4:52 PM 25 Rain coming 1/9/2022

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Andersons Business Law and the Legal Environment

Authors: David P. Twomey, Marianne M. Jennings, Stephanie M Greene

23rd edition

1305575083, 978-1305856516, 1305856511, 978-0357689868, 978-1305575080

More Books

Students also viewed these Law questions

Question

Self-confidence

Answered: 1 week ago

Question

The number of people commenting on the statement

Answered: 1 week ago