The employees in your company report struggling with burnout (being overworked). You have been asked to analyze the situation and recommend solutions to reduce employee burnout. You have access to an employee survey with employee responses related to the situation.

Descriptive statistics describes a data set. It is used to summarize and organize the data into something more manageable, actionable, and ready for presentation. It can also help organize data and present a business problem in an understandable manner. You can use descriptive statistics to understand and analyze the data for your organization. The employees in your company report struggling with burnout (being overworked). You have been asked to analyze the situation and recommend solutions to reduce employee burnout. You have access to an employee survey with employee responses related to the situation. This week you will analyze the employee survey data and create bar graphs to represent the data visually. Based on your analysis, you will then create an executive summary targeted to a nontechnical audience unfamiliar with statistics. See the document Module Four Survey Response Key for the responses that were available on the survey. Prompt Part 1: Burnout Analysis – I will send these results to you and upload once done Review the Microsoft Excel file containing the Employee Survey Data Set and familiarize yourself with the survey respondents and burnout indicators. Then, follow the directions in the User Manual: Working With Tableau document to import these employee survey responses into Tableau and conduct a burnout analysis. Specifically, you must address the following rubric criteria: Part 1: Graphs. Use Tableau on the virtual desktop interface (VDI) to create bar graphs that will answer the following questions: I will send these results to you and upload once done 1. Which gender is experiencing the burnout level “Pretty wiped out almost every day” most? (Hint: Refer to columns A, E, and F in the Excel file.) 2. Which male age group is experiencing the stress level, “A little stress that would be expected with the ups and downs of life” at home the most? (Hint: Refer to columns A, B, G, and H in the Excel file.) 3. Which leadership level strongly agrees with the fact that they love what they do? (Hint: Refer to columns D, K, and L in the Excel file.) 4. Which gender with a tenure of 5+ years had the lowest number of responses for the burnout level “I feel great! Energy to spare!”?(Hint: Refer to columns A, C, E, and F in the Excel file.) Part 2: Executive Summary. Create an Executive Summary of your results addressing the following criteria: 1. Purpose and respondents: Explain the purpose of the executive summary and briefly describe the survey respondents. 2. Results: Summarize your bar graph analyses and answer the questions they represent. Add corresponding bar graphs to relevant sections of the summary to illustrate your analyses. 3. Recommendations: Based on your analysis, recommend two areas the company can focus on to reduce employee burnout. Guidelines for Submission To complete this assignment, you must submit the following: Burnout Analysis: Submit your Tableau file using the following file name format: “MBA 540_LASTNAME_FIRSTNAME_Burnout Analysis” Executive Summary: Submit a 2- to 3-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations. Criteria Exemplary (100%) Proficient (90%) Uses Tableau Uses Tableau to create four to create four bar graphs to bar graphs to Burnout Analysis: answer the answer the Bar Graphs given given questions questions with with minimal no errors errors Executive Summary: Purpose and Respondents Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner Exceeds proficiency in Executive an Summary: Results exceptionally clear, insightful, Clearly explains the purpose of the executive summary; clearly and correctly describes the respondents Clearly summarizes bar graph analyses, correctly answers all questions, and Needs Improvement (70%) Uses Tableau to create fewer than four bar graphs to answer the given questions; creates bar graphs with significant errors Shows progress toward proficiency, but with errors or omissions; areas for improvement may include clearly and correctly explaining the purpose of the executive summary or correctly describing the respondents Shows progress toward proficiency, but with errors or omissions; areas for improvement may include providing Not Evident Value (0%) Does not attempt criterion 20 Does not attempt criterion 15 Does not attempt criterion 30 Needs Not Evident Improvement Value (0%) (70%) sophisticated, adds clear and concise or creative corresponding summary of the bar manner bar graphs to graph analyses, explain answering all relevant questions, or sections of the including the correct summary bar graphs in appropriate sections of the summary Shows progress toward proficiency, Exceeds Recommends but with errors or proficiency in at least two omissions; areas for an suitable areas improvement may Executive exceptionally Does not the company include correctly Summary: clear, attempt 20 can focus on to analyzing the bar Recommendations insightful, criterion reduce graphs sophisticated, employee andrecommending or creative burnout two suitable areas manner for the company to focus on Clearly conveys Submission Exceeds meaning with has critical proficiency in correct Shows progress errors in an grammar, toward proficiency, grammar, exceptionally sentence but with errors in Articulation of sentence clear, structure, and grammar, sentence 15 Response structure, and insightful, spelling, structure, and spelling, sophisticated, demonstrating spelling, negatively preventing or creative an impacting readability understanding manner understanding of ideas of audience and purpose Total 100% Criteria Exemplary (100%) Proficient (90%) Q1: Gender Q2: Age Q3: Tenure Q4: Leadership Q5: What is your current level of burnout Level at work? (Qualitative Data) Male 30-39 5+ years Director A bit worn out at the end of the day, several days a week OptOut 40-49 Less than 1 year Director A bit worn out at the end of the day, several days a week Female 40-49 5+ years Director A bit worn out at the end of the day, several days a week Male 50+ 2-5 years Director A bit worn out at the end of the day, several days a week Male 50+ 1 year – less than 2 Director years I feel great! Energy to spare! OptOut 40-49 5+ years Director A bit worn out at the end of the day, several days a week Male 40-49 5+ years Director A bit worn out at the end of the day, several days a week Male 30-39 5+ years Director Female 40-49 5+ years Director Male 40-49 5+ years Director A bit worn out at the end of the day, several days a week Female 50+ 5+ years Director A bit worn out at the end of the day, several days a week Female 50+ 2-5 years Director A bit worn out at the end of the day, several days a week Female 50+ 2-5 years Director A bit worn out at the end of the day, several days a week Male 50+ 2-5 years Director A bit worn out at the end of the day, several days a week Female 40-49 Less than 1 year Director A bit worn out at the end of the day, several days a week Male 30-39 5+ years Director Pretty wiped out almost every day Most days I don’t know how I make it to 5:00 A bit worn out at the end of the day, several days a week Male 40-49 5+ years Director A bit worn out at the end of the day, several days a week Male 40-49 5+ years Director A bit worn out at the end of the day, several days a week Female 30-39 5+ years Director Pretty wiped out almost every day Female 40-49 5+ years Director A bit worn out at the end of the day, several days a week Male 50+ 5+ years Director A bit worn out at the end of the day, several days a week Female 40-49 5+ years Director A bit worn out at the end of the day, several days a week Female 40-49 5+ years Executive I feel great! Energy to spare! Male 40-49 5+ years Executive I feel great! Energy to spare! Female 50+ 5+ years Executive A bit worn out at the end of the day, several days a week Female 50+ 5+ years Executive Pretty wiped out almost every day Male 40-49 2-5 years Executive A bit worn out at the end of the day, several days a week Male 40-49 5+ years Executive A bit worn out at the end of the day, several days a week Male 50+ 1 year – less than 2 Executive years Pretty wiped out almost every day Male 40-49 2-5 years Executive Pretty wiped out almost every day Female 40-49 5+ years Executive A bit worn out at the end of the day, several days a week Male 30-39 Less than 1 year Executive A bit worn out at the end of the day, several days a week Female 40-49 1 year – less than 2 Executive years A bit worn out at the end of the day, several days a week Female 40-49 5+ years A bit worn out at the end of the day, several days a week Executive Female 40-49 5+ years Executive A bit worn out at the end of the day, several days a week Female 50+ 5+ years Executive Most days I don’t know how I make it to 5:00 Female 50+ 1 year – less than 2 Executive years Pretty wiped out almost every day Male 50+ 2-5 years Executive A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Individual Contributor A bit worn out at the end of the day, several days a week Male 50+ 2-5 years Individual Contributor A bit worn out at the end of the day, several days a week Female OptOut 5+ years Male 20-29 2-5 years Individual Contributor Individual Contributor A bit worn out at the end of the day, several days a week A bit worn out at the end of the day, several days a week Female 40-49 2-5 years Individual Contributor Most days I don’t know how I make it to 5:00 Female 50+ 5+ years Individual Contributor A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Individual Contributor A bit worn out at the end of the day, several days a week Male 50+ 2-5 years Individual Contributor A bit worn out at the end of the day, several days a week Female 50+ 5+ years Individual Contributor A bit worn out at the end of the day, several days a week Male 30-39 5+ years Individual Contributor A bit worn out at the end of the day, several days a week Female 40-49 5+ years Individual Contributor A bit worn out at the end of the day, several days a week Female 40-49 2-5 years Individual Contributor A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Manager A bit worn out at the end of the day, several days a week Female 30-39 1 year – less than 2 Manager years Pretty wiped out almost every day Male 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 2-5 years Manager A bit worn out at the end of the day, several days a week Female 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Male 40-49 2-5 years Manager I feel great! Energy to spare! Male 30-39 2-5 years Manager A bit worn out at the end of the day, several days a week Male 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Male 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Male 50+ 2-5 years Manager A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Manager Pretty wiped out almost every day Female 30-39 2-5 years Manager Pretty wiped out almost every day Male 50+ 2-5 years Manager A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Manager Pretty wiped out almost every day Male 40-49 1 year – less than 2 Manager years A bit worn out at the end of the day, several days a week Female OptOut 2-5 years Manager Pretty wiped out almost every day Female 50+ 5+ years Manager Pretty wiped out almost every day Male 30-39 5+ years Manager A bit worn out at the end of the day, several days a week Male 40-49 1 year – less than 2 Manager years A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager Pretty wiped out almost every day Male 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years OptOut A bit worn out at the end of the day, several days a week Male 40-49 Less than 1 year Manager A bit worn out at the end of the day, several days a week Female 30-39 2-5 years Manager I feel great! Energy to spare! Female 40-49 5+ years OptOut A bit worn out at the end of the day, several days a week Female 30-39 Less than 1 year Manager Pretty wiped out almost every day Female 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Male 40-49 OptOut Manager A bit worn out at the end of the day, several days a week Male 30-39 Less than 1 year Manager Pretty wiped out almost every day Male 50+ 2-5 years Manager I feel great! Energy to spare! Male 50+ 5+ years Manager Pretty wiped out almost every day Male 50+ Less than 1 year Manager A bit worn out at the end of the day, several days a week Male 30-39 Less than 1 year Manager A bit worn out at the end of the day, several days a week Female 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Female 40-49 2-5 years Manager Most days I don’t know how I make it to 5:00 Female 40-49 2-5 years Manager Pretty wiped out almost every day Male 40-49 2-5 years Manager A bit worn out at the end of the day, several days a week Female 40-49 5+ years Manager Pretty wiped out almost every day OptOut 40-49 2-5 years Manager A bit worn out at the end of the day, several days a week Male 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Female 40-49 1 year – less than 2 Manager years I’m not sure I can make it another day Female 30-39 5+ years Manager Pretty wiped out almost every day Male 40-49 5+ years Manager I feel great! Energy to spare! Female 30-39 5+ years Manager Pretty wiped out almost every day OptOut 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 1 year – less than 2 Manager years I feel great! Energy to spare! Male 30-39 1 year – less than 2 Manager years A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager Pretty wiped out almost every day Male 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager Pretty wiped out almost every day Female 30-39 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager A bit worn out at the end of the day, several days a week OptOut 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager Pretty wiped out almost every day Male 40-49 Less than 1 year Manager A bit worn out at the end of the day, several days a week Female 40-49 5+ years Manager A bit worn out at the end of the day, several days a week Female 30-39 OptOut Manager A bit worn out at the end of the day, several days a week Female 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Male 20-29 5+ years Manager Pretty wiped out almost every day OptOut 50+ 5+ years Manager A bit worn out at the end of the day, several days a week Male 50+ 5+ years Manager I feel great! Energy to spare! Female 30-39 5+ years Manager Pretty wiped out almost every day Female 30-39 5+ years Manager Pretty wiped out almost every day Male 50+ 1 year – less than 2 Manager years I feel great! Energy to spare! Female 40-49 5+ years Manager Pretty wiped out almost every day OptOut 40-49 5+ years Individual Contributor A bit worn out at the end of the day, several days a week Q5: What is your current level of burnout at work? (Quantitative Data) 2 2 2 2 1 2 2 4 2 2 2 2 2 2 2 3 Q6: How stressed are you at home? (Quantitative Data) Q6: How stressed are you at home? (Qualitative Data) A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life 2 2 2 2 It feels like I’m in a pressure cooker 4 A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day I feel great! No stress at all! A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life 2 2 3 1 2 3 2 3 2 2 2 2 2 3 2 2 2 1 1 2 3 2 2 3 3 2 2 2 2 A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life 2 2 2 2 3 2 2 2 3 2 2 2 2 3 2 3 2 2 2 4 3 2 2 2 2 2 4 2 2 2 2 2 2 2 2 3 A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life Pretty stressed out almost every day A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life A little stress that would be expected with the ups and downs of life 2 3 2 2 2 2 3 3 2 3 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 3 3 2 3 2 3 3 2 2 2 3 A little stress that would be expected with the ups and dow …
Purchase answer to see full attachment