You are a data analyst working for GlobalTech Solutions, a multinational company that provides training to employees across different departments. The company’s training programs are categorized into various types, such as Technical, Soft Skills, Leadership, and Compliance. The HR department is seeking insights into how training resources are allocated, employee satisfaction with different training types, and how training costs compare across departments.
The HR team has tasked you with analyzing the training data to help them make informed decisions about future training investments and identify opportunities to improve employee satisfaction with the programs offered.
Your Objective:
Using Tableau, you are required to visualize key aspects of the training data to support the HR department’s decision-making process. Your analysis should focus on the following tasks:
Key Data Points:
Department: The department that the training was conducted for (e.g., HR, Marketing).
Training Type: The type of training offered (e.g., Technical, Soft Skills, Leadership, Compliance).
Number of Employees Trained: The number of employees who attended the training.
Training Cost (USD): The cost incurred for conducting the training.
Training Duration (Hours): The length of the training session in hours.
Employee Satisfaction Rating: The satisfaction rating provided by employees (on a scale from 1 to 5).
Frequency Distribution of Training Types:Task: Create a frequency distribution chart to show how often each Training Type (Technical, Soft Skills, Leadership, Compliance) is conducted. Present the results in a bar chart. This task should be completed using Tableau.
Reflection Question: What patterns can you identify from the frequency of each training type? How might this information influence decisions about future training investments?
Pie Chart of Departments:Task: Create a pie chart to represent the proportion of employees trained in each Department (HR, Marketing, etc.). This task should be completed using Tableau.
Reflection Question: Which departments are receiving the most training? What could be the reasons behind this allocation, and how could the company ensure a more balanced distribution if needed?
Histogram of Training Costs:Task: Visualize the distribution of Training Costs (in USD) using a histogram. This will help the HR team understand the variance in spending on different training programs. This task should be completed using Tableau.
Reflection Question: What does the distribution of training costs reveal? Are there any outliers or significant variations that should be addressed by management?
Box and Whisker Chart – Comparing Training Hours by Department:Task: Use a Box and Whisker Chart to compare Training Duration (Hours) across different Departments. This will help analyze variations in training time across the departments. This task should be completed using Tableau.
Reflection Question: How do the training hours vary by department? What insights can be drawn about departmental efficiency or commitment to training?
Crosstabulation of Training Cost, Training Duration, and Employee Satisfaction Ratings:Task: Develop a crosstab that analyzes the relationships between Training Costs, Training Duration (Hours), and Employee Satisfaction Ratings. This task should be completed using Tableau.
Reflection Question: Is there a correlation between training cost, duration, and employee satisfaction? How could this information inform the company’s strategy for allocating resources to future training programs?
Submission Requirements:
All visualizations should be created using Tableau.
Export the visualizations as a PDF report and submit them as part of your final submission.
Executive Summary: Write a brief (500-word) report summarizing key insights from your visualizations, including recommendations for optimizing training investments and improving employee satisfaction based on the data.