Youve been hired as a workforce analyst for a growing global organization that runs dozens of cross-functional projects in IT, Construction, Marketing, and Product Development. Leadership has requested a comprehensive dashboard to analyze workforce trends across project departments using a newly consolidated dataset of 1,500 employees.
Your task is to use Excel to build an interactive workforce dashboard that offers insights into staffing trends, workforce composition, compensation, and attrition across different business units and project categories.
Dataset Provided
Youve been given a dataset named Project_Management_Workforce_Data.xlsx, containing employee records with the following variables:
|
Variable |
Description |
|
First Name |
Employees first name |
|
Last Name |
Employees last name |
|
Gender |
Gender identity of the employee (Male, Female, Non-binary) |
|
Age |
Age of the employee |
|
Department |
Type of project department (e.g., IT Projects, Construction Projects, etc.) |
|
Job Title |
Specific role in the project team (e.g., Scrum Master, Field Engineer) |
|
Business Sub-category |
Nature of the projects (e.g., Digital Transformation, Infrastructure) |
|
Hire Date |
Date the employee was hired (YYYY-MM-DD) |
|
Exit Date |
Date the employee left the organization (blank if still employed) |
|
Salary |
Annual compensation in USD |
|
Years of Experience |
Years of professional experience |
|
Employment Type |
Full-Time, Part-Time, or Contract |
Dashboard Requirements
Using Excel create an interactive workforce dashboard that include the following visual elements: The dashboard should be modeled after the example dashboard shown in the provided video.
Summary Cards
- Total Employees
- Active Employees (no Exit Date)
- Inactive Employees (with Exit Date)
- Active Employee Percentage
Top 10 Highest Paid Employees
- Use a horizontal bar chart showing name and salary
Age Distribution by Gender
- Side-by-side horizontal bars for male vs female age bands
Employee Count by Department
- Use a pie chart or donut chart
Average Years of Experience by Job Title and Gender
- Bar chart with grouped bars for male and female employees
Exit Count by Age Group and Gender
- Clustered bar chart grouped by age ranges
Exit Count by Gender and Department
- Line or column chart
Filters (Slicers) to Include
Make your dashboard interactive by adding slicers for:
- Department
- Business Sub-category
- Gender
- Employment Type
Deliverable:
You are required to submit the following:
Excel File (.xlsx) with your dashboard fully built
1520 minute video presentation (.mp4 or shareable link), which should cover:
- A brief intro to the dataset and organizational context
- Step-by-step walkthrough of how you designed the dashboard
- Rationale for each visualization
- Demonstration of how the slicers/filters work
- Final summary of insights and value for decision-makers
Requirements: whatever it says in the requirements
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.