Management Question

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

Get fast, custom help from our academic experts, any time of day.

Place your order now for a similar assignment and have exceptional work written by our team of experts.

Secure 100% Original On Time Delivery