DRKDS HRMS Dashboard - User Manual

Module Overview

The DRKDS HRMS Dashboard provides comprehensive HR analytics and business intelligence with real-time data aggregation, drill-down capabilities, and custom report builder.

Executive Dashboard

Organization overview
Key HR metrics at a glance
Trend analysis
Alert notifications

Workforce Analytics

Headcount analysis
Demographics analysis
Turnover metrics
Tenure analysis

Operational Analytics

Attendance patterns
Leave utilization
Payroll insights
Training effectiveness

Custom Reports

Report builder
Scheduled reports
Export capabilities
Data visualization

Executive Dashboard

Key Metrics Overview

1,247

Total Employees

98.2%

Attendance Rate

2.1%

Monthly Attrition

78

eNPS Score

Dashboard Widgets

Widget	Data Shown	Update Frequency
Headcount Summary	Total, New, Exits, Net Change	Real-time
Attendance Today	Present, Absent, On Leave, WFH	Real-time
Pending Approvals	Leave, Expense, Training requests	Real-time
Upcoming Events	Birthdays, Anniversaries, Holidays	Daily
Document Expiry	Expiring visas, contracts, documents	Daily
Recruitment Pipeline	Open positions, Candidates in pipeline	Real-time

Accessing Dashboard

Navigate to: HRMS → Dashboard

Default view shows organization-level metrics
Filter by Department, Branch, or Date Range
Click any widget to drill down into details
Customize widget layout per user preference

Workforce Analytics

Headcount Analysis

Metric	Definition	Formula
Total Headcount	Current active employees	Count of active employees
New Hires	Joined in period	Count by join date
Exits	Left in period	Count by exit date
Net Change	Growth/Reduction	New Hires - Exits

Demographics Analysis

Age Distribution: Under 25, 25-35, 35-45, 45-55, 55+
Gender Ratio: Male, Female, Others
Education Level: Graduate, Post-Graduate, Diploma, PhD
Experience Bands: Fresher, 1-3 years, 3-5 years, 5-10 years, 10+ years

Turnover Metrics

Metric	Formula	Industry Benchmark
Monthly Attrition	(Exits / Avg Headcount) × 100	< 2%
Annual Attrition	Cumulative monthly	< 15%
Voluntary Turnover	Resignations only	< 12%
First Year Attrition	Exits within 1 year of joining	< 20%

Attendance Analytics

Key Attendance KPIs

KPI	Definition	Target
Attendance Rate	Present days / Working days	> 95%
On-Time Arrival	On-time / Total attendance	> 90%
Average Working Hours	Total hours / Present days	8-9 hours
Overtime Percentage	OT hours / Total hours	< 10%
Absenteeism Rate	Absent days / Working days	< 3%

Trend Analysis

Day-wise attendance patterns
Month-wise trends
Department comparison
Shift-wise analysis

Payroll Analytics

Compensation Metrics

Metric	Definition
Total Payroll Cost	Gross salary + Employer contributions
Average Salary	Total salary / Headcount
Cost per Employee	Total HR cost / Headcount
Salary to Revenue Ratio	Total payroll / Company revenue
Payroll Variance	Current vs Previous month change

Distribution Analysis

Department-wise payroll cost
Grade-wise salary distribution
Component-wise breakdown (Basic, HRA, etc.)
Statutory contribution summary (PF, ESI, PT)

KPI Management

Defining KPIs

Navigate to: HRMS → Dashboard → KPI Configuration

Click "Create KPI"
Enter KPI Name
Select Category (Workforce/Attendance/Payroll/etc.)
Define Calculation Formula
Set Target Value
Configure Alert Thresholds (Green/Yellow/Red)
Set Update Frequency
Activate KPI

Sample HR KPIs

KPI	Category	Target	Alert Threshold
Time to Fill	Recruitment	45 days	>60 days = Red
Offer Acceptance Rate	Recruitment	80%	<70% = Red
Training Completion	Learning	90%	<80% = Yellow
Employee Satisfaction	Engagement	4.0/5	<3.5 = Red
Leave Utilization	Leave	70%	<50% = Yellow

Report Builder

Creating Custom Report

Navigate to HRMS → Dashboard → Report Builder
Click "New Report"
Enter Report Name
Select Data Source (Employees, Attendance, Payroll, etc.)
Add Columns to include
Configure Filters
Add Grouping if needed
Choose Visualization (Table, Chart, Pivot)
Save and run report

Scheduling Reports

Setting	Options
Frequency	Daily, Weekly, Monthly, Quarterly
Day/Time	Specific day and time
Recipients	Email addresses
Format	Excel, PDF, CSV

Pre-built Reports

Report	Description
Headcount Report	Department-wise employee count
Attrition Analysis	Monthly exits with reasons
Salary Register	Monthly payroll summary
Leave Balance	Employee-wise leave status
Attendance Summary	Monthly attendance metrics
Training Status	Training completion rates

Daily Operations Guide

HR Analyst Tasks

Review daily dashboard alerts
Generate ad-hoc reports as requested
Update KPI targets quarterly
Validate data accuracy
Present insights to management

Report Distribution Schedule

Report	Frequency	Recipients
Daily Attendance	Daily 10 AM	Department Heads
Weekly HR Summary	Monday 9 AM	HR Team, Management
Monthly Payroll Report	5th of month	Finance, CFO
Quarterly HR Review	1st week of quarter	Board, CXOs

Data Refresh: Dashboard data refreshes every 15 minutes. For real-time data, click the refresh icon on any widget.