HR Analytics & Workforce Dashboard

ECOSIRE builds a proper Frappe app — installed on your bench as a versioned app, not a pile of manual customizations — that adds an HR Analytics module with a purpose-built Workspace and Dashboard. We model the metrics you actually govern by: headcount and attrition trend charts, payroll cost and overtime spend, attendance and absenteeism heatmaps, a hiring funnel with time-to-fill, and tenure and diversity breakdowns. Aggregation runs in whitelisted server-side methods (frappe.whitelist()) using parameterized frappe.db queries and QueryReport definitions, so the heavy math happens in Postgres/MariaDB and the dashboard stays fast. Where a metric must stay current, a scheduler_events hook (daily/hourly) refreshes a summary DocType so the executive board loads instantly instead of recomputing on every open.

Technically, the app is wired the ERPNext way. hooks.py doc events on Employee, Attendance and Salary Slip keep derived figures — active headcount, separations, overtime hours — consistent as records change, so an attrition number is never a stale snapshot. Client Scripts add the interactive filters (date range, company, department, branch, employment type) on the dashboard pages, and the underlying data is also exposed through the Frappe REST API and whitelisted methods so your Power BI, Metabase or Google Looker Studio instance can pull the same governed numbers. Access is enforced through ERPNext's own Role Profiles and permission model plus User Permissions — an HR Manager sees the whole organization, a department head sees only their cost centre, and sensitive salary aggregates are gated to finance roles. Charts render with Frappe's native chart library so the experience is consistent with the rest of your desk.

Because this is build-to-order, nothing is guessed. We start from your definitions — how you count a "separation," which pay components are "overtime," how you group diversity and tenure bands, your fiscal calendar — and build to that scope. Delivery is typically 2 to 4 weeks from confirmed scope. You receive the installable app source for your ERPNext version (v15 or v16), UAT on a staging bench with a rollback plan, deployment to production, technical and user documentation, a training session, and a post-go-live support window. The git repository is handed over to you, so the app is yours to keep, extend, or maintain independently.