Replacing manual HR registers with one dashboard for a Patna steel manufacturer. A real-time HR dashboard with data visualisation, designed as Employee Experience Designer at Neelkamal Steels.
Neelkamal Steels, a steel manufacturer in Patna, tracked HR work in manual registers. I designed a real-time HR dashboard with data visualisation to bring that work into one place.
HR spent most of its time chasing and fixing data by hand instead of acting on it.
Neelkamal’s head office runs sales, scrap and sponge iron procurement, dispatch logistics and accounts. Most staff are permanent salaried employees, and many travel across Bihar to meet dealers and visit sites. Before this project:
Slow approvals, payroll errors, and frustrated field staff waiting for reimbursements.
I was the only product designer on the project. I designed the dashboard in Adobe XD and Figma, working closely with the engineers and the HR manager.
I followed a lean, Double Diamond-style process, sized to an eight-week project.
Contextual inquiry with HR during a payroll week, interviews with staff, and a review of existing registers and spreadsheets.
Turned findings into key insights and design goals, and agreed priorities with the HR manager.
Low-fidelity wireframes in Adobe XD, reviewed with the HR manager, then high-fidelity UI and a clickable prototype in Figma.
Two rounds of usability testing with HR on the prototype, with a design change between rounds.
Worked with the engineers through build, using a shared style guide.
I started by sitting with the HR team to watch how a normal month actually ran, from first punch to payroll.
One view of attendance, leave, claims and payroll status
Gathering data from many sources before every cutoff
Fast way to approve or fix records
Calling managers to confirm who was on a field visit
Team headcount, attendance and performance
No visibility without asking HR
Correct attendance and quick reimbursement
Marked absent while working; claims stuck for weeks
The biggest time sink was not missing data but exceptions that the system could not explain.
I organised the tool into modules that follow HR’s monthly cycle, with one home screen pulling the urgent items from each.
The KPI cards answer “how is today going?”; the panels below answer “what do I need to do?”, ordered by urgency.
Each employee’s status is worked out by combining three sources, which HR used to match by hand.
| Punch | OD approved | Leave approved | Status shown |
|---|---|---|---|
| Yes, on time | — | — | Present |
| Yes, after 09:30 | — | — | Late |
| No | Yes | — | On Field Duty |
| No | — | Yes | Leave |
| No | No | No | Absent |
A missing or wrong punch is fixed through a regularisation request, raised by the manager and approved by HR in the queue.
Six decisions shaped the dashboard, each tied to a problem from research.
Sales and logistics staff visiting dealers in places like Hajipur or Bihta showed up as absent.
I added a third attendance status, On Field Duty (OD), shown as its own coloured chip next to Present and Absent. The employee’s manager raises an OD request with the location, purpose and return date, and an OD tracker lists who is out, where, and when they are due back.
HR stopped chasing false absences, and field staff stopped being penalised for doing their jobs.

Fixing a missed punch meant a paper request, a call to the manager and a manual edit.
Managers raise correction requests for their team members, and these land in one queue showing the reason (e.g. “Forgot to punch out, left for a dealer visit”). HR approves or rejects from the row.

Old TA/DA claims were buried under new ones.
The home screen shows pending claims sorted by how long they have waited. Claims older than 5 days are highlighted so they are cleared first.

HR only discovered blockers in the last days before payroll.
A countdown shows days left to cutoff, with counts of what still blocks it. Sales managers who hit their monthly tonnage target are flagged for incentive processing automatically.
Shown on the office overview at the top of this page.
Vacancies were tracked in emails and spreadsheets, so HR and department heads had no shared view of which roles were open or how far hiring had got.
A Recruitment module shows each open role with its department, stage (Screening, Interview, Offer), number of candidates and days open, plus upcoming interviews. An “Open positions” card on the home screen keeps hiring visible next to daily HR work.

Birthdays, work anniversaries and office events were tracked informally and easy to miss.
A “This week” panel on the home screen lists upcoming birthdays, work anniversaries and office events, such as the Diwali puja, so HR can plan wishes and announcements ahead of time.
Shown on the office overview at the top of this page.
I built a lightweight style guide on Material Design principles, so the engineers could build every screen from the same set of colours, type and components.
Every status has a fixed colour and a text label, so colour is never the only signal.

Task completion rose from 80% to 100%, and the HR team reported 15% annual cost savings.
I ran two rounds of usability testing with HR: task completion rose from 80% in the first round to 100% after one design change.
I sat with a member of the HR team in front of the Figma prototype and gave them real tasks from their working day, for example:
I watched where they hesitated or clicked the wrong thing, and noted whether each task was completed without help.
Result: an 80% task completion rate across all tasks.
What failed: the task “Which claim should you approve first?” The HR user picked the claim at the top of the list, the newest one, instead of the one that had waited longest. In the prototype, claims were listed in the order they were submitted, and nothing marked the overdue ones, so nothing pointed to the oldest claim.
This turned the claims panel from a list into a to-do order: the claim HR should approve first is now always at the top.
After the changes, I ran the same tasks again with HR. Task completion rose from 80% to 100%, and the claims task was completed correctly first time.
The dashboard replaced manual registers and spreadsheets as HR’s daily starting point, and gave management one reliable view of the office workforce.
In Phase 1, managers raised OD and correction requests for their teams. Phase 2 moves that work to employees themselves.
For every staff member: own attendance, raise OD and regularisation requests, apply for leave, submit claims and track their status, download payslips. Solves: HR enters requests on staff’s behalf, and staff can’t see where their requests are stuck.
Errors found only after payroll runs.
Disputes over targets and payouts.
Approvals and missed punches forgotten.
Owners can’t see cost per department.
Not all staff comfortable in English.
The HR team asked for a way to track field duty in our first interviews. Watching a payroll week showed me how much time the problem really cost, which made it the clear priority.
Most of HR’s effort went to the small share of records that didn’t fit; designing for those had the biggest impact.
Local holidays, steel-industry roles and simple language made the tool feel built for Neelkamal, not adapted from a template.
I would measure baseline times before launch, so the impact could be shown in hours saved as well as cost.