Scribd
Upload
2 views3 pages

1. Case Study - Visualization Using Tableau

The document outlines a case study on HR analytics using a dataset containing employee information, aiming to create an interactive Tableau dashboard. Key analytical objectives include analyzing employee headcount by job role, gender distribution, age demographics, compensation averages, and leave balance. The dashboard will feature interactive elements such as filters and drill-downs to facilitate data exploration and insights presentation.

Uploaded by

Yash Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views3 pages

1. Case Study - Visualization Using Tableau

The document outlines a case study on HR analytics using a dataset containing employee information, aiming to create an interactive Tableau dashboard. Key analytical objectives include analyzing employee headcount by job role, gender distribution, age demographics, compensation averages, and leave balance. The dashboard will feature interactive elements such as filters and drill-downs to facilitate data exploration and insights presentation.

Uploaded by

Yash Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

HR Analytics

Case Study - 1
Presenting information on a Dashboard using a visualization tool like Tableau

About the dataset: HR data for a company with basic information. 11 fields and 161 rows

Perform an initial exploratory analysis of the given dataset to understand its structure, quality, and
key characteristics. Based on the insights obtained, design and present an interactive Tableau
dashboard that addresses the following analytical objectives:

1. Analyse employee headcount by job role to understand workforce distribution

2. Visualize gender-wise employee distribution across the organization

3. Examine age distribution to assess workforce demographics

4. Identify which job roles offer the highest average compensation

5. Highlight top-earning employees within each job role

6. Analyse the relationship between employee qualifications and salary levels

7. Track headcount trends over time to monitor hiring and attrition patterns

8. Enable filtering of employees using a starting letter (wildcard) search for easy lookup

9. Assess leave balance distribution to monitor utilization and workforce availability

10. Enable chart interaction between – Job Title and Top Performers , Gender analysis

The dashboard will be interactive, supporting filters and drill-downs, and will present insights
through charts, tables for quick interpretation.
Sample Dashboard

Sample Story

Hint: Apply following features on the charts


1. Job Title Analysis
Analysis – Add mark labels
Edit axis and hide header
Change color of the bar

2. Gender Analysis
Add a pie chart

3. Age Analysis
Drop Age to the columns, and count to rows and change the chart to histogram
Add table calculation – Calculation type – percent of total, Compute using – table down

4. Avg Salary by Job Roles


Quick Table Calculation – Avg Salary
Right click on Salary(measure) and change the default property

5. Top Earner – Add context filter.


A context filter is applied first to the dataset and creates a temporary subset of data.
All other filters (dimension, measure, top N, table calcs) are then applied on top of this
subset.

6. Qualification Vs Salary
Box plot – Add emp id to level of detail to plot the box plot

7. Headcount trend over time / Staff growth


Quick table calculation – Use running total for cumulative value

8. Enable filtering on employee name


Add a name filter , show the filter and use the filter type – Wild char match
Use wild char : a*, *a, *a*, *verma

9. Leave Balance Analysis


Create calculated field :
Staff with more than 20 days leave = if [Leave Balance] > 20 then 1 else 0 END

10. Dashboard:
Remove titles
Format – Dashboard, Shading
Edit Dashboard actions to enable chart interaction between various charts

You might also like