HR Pro — Employee Management System | Excel + Power BI Dashboard

Manage your entire workforce in one place with HR Pro — a complete, Arabic-first employee management system built in Excel, paired with a fully interactive Power BI dashboard. No expensive HR software, no subscriptions. Just open, configure, and manage from day one.

👥 Employee Database

• Manage up to 2,000 employee records in a single centralized database (expandable)
• Auto-generated employee ID in EMP-0001 format — or enter your own custom ID
• Full employee profile: name, gender, nationality, contact info, department, job title, branch, contract type, and salary
• Automatic service duration calculation (days and years) — always up to date
• Automatic countdown to contract end date — updated daily with TODAY()
• Document expiry tracking: ID/Iqama expiry and passport expiry with configurable alert threshold
• Employee status tracking: Active, Suspended, or Terminated

🗓️ Attendance Tracking

• Log up to 5,000 attendance records (expandable)
• Daily attendance status: Present, Absent, Leave, Remote Work, or Mission
• Clock-in and clock-out time recording
• Auto-extracted day, month, and year from the date entry for easy filtering
• Auto-populated employee name and nationality from the employee database

🏖️ Leave Management

• Track up to 2,000 leave requests (expandable)
• Auto-generated leave request number in LV-00001 format
• Supports multiple leave types: Annual, Sick, Emergency, Maternity, Paternity, Unpaid, and more
• Configurable annual entitlement per leave type
• Leave request status tracking: Pending, Approved, or Rejected
• Auto-populated employee name from the employee database

💰 Payroll Processing

• Process up to 3,000 monthly payroll records (expandable)
• Supports up to 6 allowance types per employee (Housing, Transport, Phone, Nature of Work, and more)
• Supports up to 6 deduction types per employee (GOSI, Loans, Penalties, Absences, and more)
• Automatic total allowances calculation
• Automatic total deductions calculation
• Automatic net salary calculation: Basic + Allowances − Deductions
• Auto-populated employee name from the employee database

⭐ Performance Evaluation

• Record up to 2,000 annual performance evaluations (expandable)
• Overall rating with configurable rating scale (Excellent, Very Good, Good, Acceptable, Poor)
• Score/grade field for numeric performance tracking
• Development plan field to document employee growth plans
• Auto-populated employee name from the employee database

⚙️ Setup & Configuration

• 15 fully customizable reference lists: departments, job titles, branches, nationalities, contract types, leave types, allowance types, deduction types, and more
• All dropdown lists are auto-linked — update a list once and it updates everywhere
• Configurable document expiry alert threshold (default: 30 days)
• All tables auto-expand as you add new rows — no manual formula copying needed
• Works with Excel
• Fully Arabic interface

📊 Power BI Interactive Dashboard (PBIX included)

• Fully interactive dashboard built in Power BI Desktop — included as a separate .pbix file
• Real-time KPI cards: total employees, total males and females, total attendance days, total absence days, average service duration, average performance rating, total basic salaries, total allowances, total deductions, and net payroll
• Leave summary: total leave days used, total leave days remaining, and total leave balance
• Employees by department — interactive pie chart
• Employees by nationality — bar chart with drill-down
• Employees by job title — horizontal bar chart
• Employees by branch/location — donut chart
• Employees by contract type — horizontal bar chart with percentage labels
• Employees by status (Active, Suspended, Terminated) — bar chart
• Attendance by nationality — stacked bar chart by attendance status
• Attendance by department — stacked bar chart by attendance status
• 10 interactive slicers to filter all visuals simultaneously: Employee ID, Gender, Nationality, Branch, Job Title, Department, Employee Status, Contract Type, Year, and Month
• One-click reset button to clear all filters instantly
• Fully connected to the Excel source file — refresh data with one click after updating the spreadsheet