Employment Statistics Dashboard Visual Analysis of Employment Trends
- Name: Nidhi Agarwal
- Course: Data Visualisation
Introduction
This project presents a visual analysis of employment-related data over multiple years.
Objectives
- Analyze employment trends
- Understand gender participation
- Study job demand and infrastructure
- Build a visual dashboard
What We Will Do
In this program, we will:
- Load required libraries and dataset
- Explore dataset structure
- Clean and preprocess data
- Perform analysis on key variables
- Visualize using ggplot2
- Combine plots into a dashboard
Load Dataset
Load the necessary datasets
Dataset Exploration
We explored the dataset using:
year no_of_employment_exchage no_of_persons_registered_in_000
1 2009 57 421
2 2010 57 477
3 2011 57 537
4 2012 48 540
5 2013 (A) 48 424
6 NA NA
persons_on_live_registers_at_the_end_of_the_year_all_persons_in_000
1 1940
2 1954
3 2002
4 2069
5 2066
6 NA
persons_on_live_registers_at_the_end_of_the_year_educated_person_in_000
1 1555
2 1521
3 1405
4 1677
5 1751
6 NA
persons_given_employment_total_in_000
1 5
2 9
3 7
4 12
5 5
6 NA
persons_given_employment_females_in_number
1 277
2 287
3 350
4 643
5 154
6 NA
persons_given_employment_scheduled_castes_in_number
1 425
2 1115
3 1487
4 1056
5 242
6 NA
persons_given_employment_scheduled_tribes_in_number
1 656
2 988
3 1632
4 1178
5 176
6 NA
'data.frame': 8 obs. of 9 variables:
$ year : chr "2009" "2010" "2011" "2012" ...
$ no_of_employment_exchage : int 57 57 57 48 48 NA NA NA
$ no_of_persons_registered_in_000 : int 421 477 537 540 424 NA NA NA
$ persons_on_live_registers_at_the_end_of_the_year_all_persons_in_000 : int 1940 1954 2002 2069 2066 NA NA NA
$ persons_on_live_registers_at_the_end_of_the_year_educated_person_in_000: int 1555 1521 1405 1677 1751 NA NA NA
$ persons_given_employment_total_in_000 : int 5 9 7 12 5 NA NA NA
$ persons_given_employment_females_in_number : int 277 287 350 643 154 NA NA NA
$ persons_given_employment_scheduled_castes_in_number : int 425 1115 1487 1056 242 NA NA NA
$ persons_given_employment_scheduled_tribes_in_number : int 656 988 1632 1178 176 NA NA NA
year no_of_employment_exchage no_of_persons_registered_in_000
Length:8 Min. :48.0 Min. :421.0
Class :character 1st Qu.:48.0 1st Qu.:424.0
Mode :character Median :57.0 Median :477.0
Mean :53.4 Mean :479.8
3rd Qu.:57.0 3rd Qu.:537.0
Max. :57.0 Max. :540.0
NA's :3 NA's :3
persons_on_live_registers_at_the_end_of_the_year_all_persons_in_000
Min. :1940
1st Qu.:1954
Median :2002
Mean :2006
3rd Qu.:2066
Max. :2069
NA's :3
persons_on_live_registers_at_the_end_of_the_year_educated_person_in_000
Min. :1405
1st Qu.:1521
Median :1555
Mean :1582
3rd Qu.:1677
Max. :1751
NA's :3
persons_given_employment_total_in_000
Min. : 5.0
1st Qu.: 5.0
Median : 7.0
Mean : 7.6
3rd Qu.: 9.0
Max. :12.0
NA's :3
persons_given_employment_females_in_number
Min. :154.0
1st Qu.:277.0
Median :287.0
Mean :342.2
3rd Qu.:350.0
Max. :643.0
NA's :3
persons_given_employment_scheduled_castes_in_number
Min. : 242
1st Qu.: 425
Median :1056
Mean : 865
3rd Qu.:1115
Max. :1487
NA's :3
persons_given_employment_scheduled_tribes_in_number
Min. : 176
1st Qu.: 656
Median : 988
Mean : 926
3rd Qu.:1178
Max. :1632
NA's :3
Key Checks
- Number of rows and columns
- Column names
- Data types
- Summary statistics
Data Cleaning
To ensure accurate analysis:
Why?
- Removes missing values
- Improves data reliability
- Prevents incorrect visualizations
Key Variables Analyzed
- Employment for Scheduled Castes
- Female Employment
- Number of Persons Registered
- Employment Exchanges
Plot 1 – Total Employment
Insight
- Shows employment trend over time
- Upward trend = improvement
- Dips = possible economic issues
Plot 2 – Female Employment
Interpretation: Female Employment
- The bar chart highlights yearly female employment levels.
- Increasing bar heights suggest improved gender inclusion.
- Variations across years may indicate policy impact or social factors affecting women’s employment.
Plot 3 – Persons Registered
Interpretation: Registrations
- This plot reflects job demand trends.
- Increasing registrations suggest higher job-seeking population.
- If employment doesn’t match this growth, it may indicate unemployment pressure.
Plot 4 – Employment Exchanges
Interpretation: Employment Exchanges
- This shows infrastructure supporting employment services.
- Growth indicates government expansion of job facilitation systems.
- Stable or declining trends may suggest limited infrastructure development.
Dashboard Creation
![]()
Purpose
- Combine all insights in one view
- Easy comparison of trends
Dashboard Styling
![]()
Conclusion
The analysis shows positive employment growth but highlights:
- Need for better gender inclusion
- Need to match job demand with supply
- Importance of expanding employment infrastructure
