- Matrix view or heat map showing male/female averages.
- Pie or donut chart.
- Side-by-side bar chart or stacked bar.
- Treemap or stacked bar by gender and marital status.
- Bar chart showing education field breakdown.
- Bar chart or table with monetary values.
- Line or area chart split by gender.
- Matrix or clustered bar chart.
- Tableau Dashboard File (.twbx)Complete and professionally styled dashboard
- 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
- 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: m
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)
Overall Gender Distribution
Gender by Job Role
Gender & Marital Status Breakdown
Total Employees by Education Level
Average Monthly Income by Department and Job Role
Years of Experience
Total Employees by Department and Job Title
Include the appropriate filters
Submission Requirements
You must submit:
1520 Minute Video Demonstration: Include the following in your recording:
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?
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.