Assignment Prompt & Instructions
[>Management homework help](https://www.sweetstudy.com/fields/business-finance-management)
**Background:** SWAPNJEET Financial Services is a large financial institution with a diverse workforce. The company faces challenges with employee retention, as the attrition rate has been increasing over the past few years. The Human Resources (HR) department is tasked with analyzing employee data to identify trends and factors contributing to attrition. They aim to use this analysis to develop strategies for improving employee retention and job satisfaction. **Objectives:**
1. **Understand Employee Demographics and Attrition:** Identify which demographics (age, gender, department, etc.) are most affected by attrition.
2. **Evaluate Job Satisfaction:** Assess how job satisfaction varies across different job roles and departments.
3. **Develop Data-Driven Strategies:** Use the insights from the analysis to propose actionable strategies to reduce attrition and improve employee satisfaction.
You are given a dataset that includes various attributes of employees such as age, gender, department, job role, education level, years of experience, performance rating, work-life balance, annual salary, training hours, job involvement, job satisfaction, and attrition status. You are task to create an interactive and dynamic HR analytics dashboard using the provided dataset. **The dashboard should be** **modeled after the example dashboard shown in the provided video.** The key metrics and visualizations should include:
01. **Employee Count:** Total number of employees.
02. **Attrition Count:** Total number of employees who have left.
03. **Attrition Rate:** Percentage of employees who have left.
04. **Active Employees:** Number of current employees.
05. **Department-wise Attrition:** Pie chart showing attrition by department.
06. **Number of Employees by Age Group:** Bar chart showing the distribution of employees across different age groups.
07. **Attrition by Gender:** Bar chart showing attrition by gender.
08. **Education Field-wise Attrition:** Bar chart showing attrition by education field.
09. **Attrition Rate by Gender for Different Age Groups:** Donut charts showing attrition rates by gender for different age groups.
10. **Job Satisfaction Rating:** Heatmap or table showing job satisfaction ratings by job role.
11. **Others:** Any other visuals or analysis you find appealing to add
Ensure the dashboard is interactive and allows filtering by various dimensions such as department, gender, and education level. **You must use Excel to create the dashboard.Ensure that your submitted files include a sheet demonstrating the thoroughness of your analysis.Any dashboard generated using AI will be marked zero.Instructions**
1. **Prepare Your Data:**
– Clean and structure your data for analysis.
2. **Create Visualizations:**
– Employee Count: Use a card or KPI visualization.
– Attrition Count and Rate: Calculate using formulas or calculated fields.
– Department-wise Attrition: Create a pie chart.
– Number of Employees by Age Group: Create a bar chart.
– Attrition by Gender: Create a bar chart.
– Education Field-wise Attrition: Create a bar chart.
– Attrition Rate by Gender for Different Age Groups: Create donut charts.
– Job Satisfaction Rating: Create a heatmap or table.
– Any other visuals or analysis you find appeal to add
3. **Assemble Your Dashboard:**
– Arrange the visualizations in a clear and logical layout.
– Add titles, labels, and legends.
4. **Add Interactivity:**
– Implement filters and slicers to allow users to interact with the data.
5. **Review and Adjust:**
– Ensure the dashboard is user-friendly and provides clear insights.
– Adjust the layout and visualizations as needed.
6. **Presentation**:
– Prepare a brief report or presentation summarizing the findings.
– Highlight key metrics and insights from the dashboard.
– Include a 20 – 25 minute presentation video where you walk through the workings of the dashboard and a brief summary of the analysis. The presentation should cover:
– **Overview of the Dashboard**: Introduce the key metrics and visualizations included.
– **Data Sources and Preparation**: Explain the data cleaning and preparation steps and highlight key aspects of your analysis.
– **Detailed Walkthrough**: Go through each visualization, explaining what it shows and why it is important.
– **Key Insights and Observations**: Summarize the main findings and insights from the data.
– **Technical Aspects**: Briefly discuss any technical challenges or interesting techniques used in creating the dashboard.
**Submission:** Submit the Excel file containing the final dashboard, along with a sheet demonstrating the thoroughness of your analysis. Include a report or presentation with your analysis and insights. Additionally, submit the recorded presentation video file. **Any dashboard generated using AI will be marked zero. Evaluation Criteria:**
– Accuracy of data cleaning and preparation.
– Completeness and clarity of visualizations.
– Creativity and effectiveness of the dashboard design.
– Depth of analysis and quality of insights.
– Overall presentation and communication, including the effectiveness of the recorded presentation video.
**How to Design Beautiful Background for Dashboard |** [**#tableau**](https://www.youtube.com/hashtag/tableau) [**#excel**](https://www.youtube.com/hashtag/excel) [**#powerbi**](https://www.youtube.com/hashtag/powerbi) [**@datatutorials1**](https://www.youtube.com/@datatutorials1) https://youtu.be/IOzvRueiYi8
**Excel Dashboard from start to end (Part 1) | HR Analytics Dashboard | Start to End Design**
https://youtu.be/4WUzvr9jxGc
**Excel Dashboard from start to end (Part 2) | HR Analytics Dashboard | Start to End Design** [**#excel**](https://www.youtube.com/hashtag/excel)
https://youtu.be/j3YhwyliwsY
– [\
\
SWAPNJEET_HRDataforAnalysis1.xlsx](https://www.sweetstudy.com/files/swapnjeet-hrdataforanalysis1-xlsx "SWAPNJEET_HRDataforAnalysis1.xlsx")
– 2 years ago