Management Question

You are a Project Manager for Elevate Hospitality Group, a leading operator of luxury hotels, resorts, and eco-lodges across the country. The executive leadership team has requested a data-driven Tableau dashboard to support workforce planning and performance optimization across various hospitality departments.

Youve received a dataset containing detailed information on 1,500 employees spanning departments such as Front Desk, Food & Beverage, Guest Relations, Housekeeping, and Facilities. Your goal is to analyze this data, identify trends, and present a professional dashboard that highlights staffing patterns, attrition risks, compensation insights, and performance indicators across the organization.

This dashboard will inform key decisions on recruitment, training, scheduling, and resource allocation for upcoming seasonal projects.

Use the dataset titled Hospitality_Tourism_Workforce_Data_Final__.xlsx, which includes the following fields:

First Name / Last Name	Employee identity (can be anonymized)
Gender	Male, Female, Non-binary
Age	Employees age
Department	Department (e.g., Front Desk, Housekeeping)
Job Title	Specific hospitality role
Business Sub-category	Hotel type (e.g., Luxury Resort, Eco Lodge)
Hire Date / Exit Date	Start and end dates of employment
Attrition	Yes/No (whether the employee left)
Shift Type	Morning, Evening, Night, or Rotational
Performance Rating	Score from 1 (Low) to 5 (Excellent)
Marital Status	Single, Married, Divorced, etc.
Distance From Home	Commute distance in miles
Salary	Actual annual salary
Years of Experience	Total years in the workforce
Employment Type	Full-Time, Part-Time, Seasonal
Education Level	Highest degree completed
Average Income	Industry benchmark income based on role

Dashboard Development Requirements (in Tableau)

Design an interactive dashboard that mirrors the layout and storytelling style of the sample video shared below. Your dashboard should include:

Average Age by Department and Job Role (by Gender)

Matrix view or heat map showing male/female averages.

Overall Gender Distribution

Pie or donut chart.

Gender by Job Role

Side-by-side bar chart or stacked bar.

Gender & Marital Status Breakdown

Treemap or stacked bar by gender and marital status.

Total Employees by Education Level

Bar chart showing education field breakdown.

Average Monthly Income by Department and Job Role

Bar chart or table with monetary values.

Years of Experience

Line or area chart split by gender.

Total Employees by Department and Job Title

Matrix or clustered bar chart.

Include the appropriate filters

Submission Requirements

You must submit:

Tableau Dashboard File (.twbx)Complete and professionally styled dashboard

1520 Minute Video Demonstration: Include the following in your recording:

Introduction to the project and dataset
Walkthrough of the full dashboard
Insights on attrition, pay, performance, and department needs
Demonstration of dashboard filters and interactivity

What Is Tableau?

Tableau is a stand-alone data visualization software that has gained tremendous popularity for its attractive output, versatility, and ease of use. Tableau is designed to allow users with little technical experience to develop attractive visualizations interactively and to drill down the data for business insights. Users can easily switch between different visualizations to select the most compelling graphs for their storytelling. In addition, Tableau allows users to create interactive dashboards, which can display real-time data, to support business decision making.

Note on Accessing Tableau for Your Assignment

For this assignment, you can use Tableau Public, a free and user-friendly platform to create and share interactive data visualizations.

What is Tableau Public? Tableau Public is a free platform that allows you to explore, design, and publicly share your data visualizations (also known as vizzes). You can create vizzes directly through the web authoring tool or by downloading the Tableau Desktop Public Edition at no cost.

If you already have Tableau Desktop Professional Edition, you can still publish your work to Tableau Public for free.

Why use Tableau Public?

Its free and accessible
It provides millions of public visualizations to explore and learn from
It helps you build your data skills
You can create an online portfolio of your work
Youll be part of a global data community that shares, collaborates, and grows together
To get started, visit:

Requirements: whatever it says on the requirements

WRITE MY PAPER

Comments

Leave a Reply Cancel reply