Recruitment Pipeline Funnel
Distribution of requisitions across standardized workflow stages
Requisition Status Distribution
Open vs. Closed vs. Cancelled breakdown
Recruiter Workload & Efficiency
Total volume and average time-to-offer per TA specialist
Candidate Sourcing Channels (Talent Origin)
Effective recruitment channels across placements
Monthly Requisition Inflow
Volume of opened requisitions by approval month
Top Business Units by Hiring Volume
Distribution across organizational directorates
Top In-Demand Requisition Roles
Roles with highest requisition count and fill statistics
| Job Title / Position | Total | Open | Hired | Avg. Time |
|---|
Data Hygiene & Quality Audit
Integrity scan for missing identifiers, dates, and unassigned fields
Cumulative Recruitment Summary Table (Kümüle Tablo)
Aggregated multi-dimensional breakdown with totals, ratios, and lead times
Aggregate By:
| Dimension Group ↕ | Total Req. ↕ | Open (Count / %) ↕ | Closed / Filled ↕ | Cancelled ↕ | Hired Placements ↕ | Offers Made ↕ | Avg. Time to Offer ↕ | Top Sourcing Channel |
|---|
Requisition Stage Pipeline
Visual Kanban representation of active and resolved requisitions
Placed Talent Directory
Directory of candidates successfully placed into roles
| Candidate Name | Assigned Position | Business Unit | Sourcing Channel | TA Specialist | Offer Date | Level | Row # |
|---|
Underlying Requisition Records
Granular table view of all 16 active fields in the dataset
| Row | PTF ID | Business Unit | Position Name | Status | Process Step | Hiring Manager | TA Specialist | Opening Date | Offer Date | Hired Candidate | Channel | Level | Category |
|---|
Data Contract & Metric Dictionary (Veri Sözleşmesi)
Definitive technical and operational specifications for dataset ingestion and KPI computations
1. Dataset Overview & Technical Specifications
This dashboard operates on a standardized, client-side recruitment dataset originating from the corporate Talent Acquisition tracking workbook. It parses and visualizes 5,000 synthetic historical and active requisition lifecycle records.
Active Sheet Name
db (or the primary populated worksheet in the workbook).
Column Structure
Total of 17 physical columns (A to Q). Column A (check_area) is explicitly ignored during ingestion and computation.
Date Encoding
Excel serial day numbers (e.g. 45272 = 2023-12-12) or standard ISO dates (YYYY-MM-DD). Normalized automatically via UTC timestamp conversion.
Offline Portability
100% serverless single-page application. SheetJS is embedded locally for secure client-side parsing with zero network dependencies.
2. Field Dictionary & Schema Mapping
Exact definitions of the 16 active columns ingested from the Excel workbook:
| Col | Field Key | Display Label | Data Type | Nullability | Description & Business Logic |
|---|---|---|---|---|---|
| A | check_area | Check Area | String | Optional | Ignored Column: Reserved for internal administrative checks. Excluded from all computations and dashboards. |
| B | ptf | PTF Requisition ID | String / Number | Mandatory | Unique Position Requisition Identifier. Bulk/mass hires use *** mask. |
| C | unit | Business Unit | String | Mandatory | Operating Directorate or Division requesting headcount (e.g. Güvenlik Operasyon, TAYA Yolcu Hizmetleri). |
| D | position_name | Position Name | String | Mandatory | Formal corporate job title of the requested role. |
| E | status | Requisition Status | String | Mandatory | Primary lifecycle state: Açık (Open), Kapatıldı (Closed / Filled), İptal Edildi (Cancelled). |
| F | process_step | Process Step | String | Mandatory | Current recruiting sub-step: Teklif Kabul, Ön Eleme, Teklif, Online & Envanter, PSM & Birim. |
| G | hiring_manager | Hiring Manager | String | Mandatory | Name of the departmental director or manager requesting the role. |
| H | responsible | TA Specialist | String | Mandatory | Talent Acquisition specialist / recruiter assigned to manage the requisition. |
| I | comment | Operational Notes | String | Optional | Free-text notes including onboarding dates, candidate progress, or special project tags. |
| J | position_start_date | Opening Date | Date / Serial | Mandatory | Date the PTF was formally approved and opened for candidate sourcing. |
| K | position_level | Position Level | String | Mandatory | Organizational grade (e.g. Uzman, Uzman Yardımcısı, Sorumlu, Şef). |
| L | level_category | Level Category | String | Mandatory | Management tier: Uzman Grubu (Professional), İlk Kademe Yönetici, Orta Kademe, Üst Kademe, C-Level. |
| M | offer_date | Offer Date | Date / Serial | Optional | Date the formal job offer was extended to the candidate. |
| N | hired_employee | Hired Candidate | String | Optional | Full name of the candidate placed into the position. Empty if position is still open or cancelled. |
| O | resource | Sourcing Channel | String | Optional | Talent channel: LinkedIn, Referans (Referral), Agency, Harici (Direct), Kariyer.net. |
| P | refferal_name | Referral Source | String | Optional | Name of internal employee or external source providing the referral. |
| Q | gender | Candidate Gender | String | Optional | Demographic tag recorded during onboarding: Male or Female. |
3. Metric Formulas & Calculation Logic
Mathematical definitions and governance rules for all executive KPIs:
| KPI Name | Calculation Formula | Measurement Unit | Rationale & Purpose |
|---|---|---|---|
| Total Requisitions | COUNT(records) matching active filters |
Integer count | Measures the total scope of hiring demand handled by the Talent Acquisition organization. |
| Open Requisitions | COUNT(status == "Açık") |
Count & % of Total | Active searches currently in flight that require recruiter attention and operational execution. |
| Closed Requisitions | COUNT(status contains "Kapatıldı") |
Count & % of Total | Successfully filled requisitions where hiring requirements have been satisfied. |
| Cancelled Requisitions | COUNT(status contains "İptal" or "listeden çıkar") |
Count & % of Total | Positions frozen, cancelled by the business unit, or rescinded prior to hire. |
| Hired Placements | COUNT(hired_employee is not empty and not starts with "#") |
Individual count | Verified placed employees who have accepted offers and are scheduled for/have started work. |
| Time to Offer (Lead Time) | (offer_date - position_start_date) in days / 7 in weeks |
Days & Weeks | Cycle time efficiency: tracks calendar duration from PTF requisition approval to formal offer extension. Outliers (<0 or >730 days) excluded. |
| SLA Risk Alert (>60 Days Open) | COUNT(status == "Açık" and (current_date - position_start_date) > 60 days) |
Count of roles | Operational risk indicator flagging open requisitions exceeding the standard 60-day SLA window. |
| Offer Acceptance Rate | (Hired Placements / Total Offers Extended) * 100 |
Percentage (%) | Candidate attraction efficiency: proportion of extended job offers that resulted in placed employees. |
4. Standardized Pipeline Funnel Mapping
Rules mapping raw operational Turkish steps and statuses into the 7 standard pipeline stages:
| Standard Stage | Primary Triggers & Matching Tokens | Business Description |
|---|---|---|
| New & Sourcing | status == "Açık" and (process_step == "Aday Arama" or no candidate yet) |
Requisition approved, recruiter actively sourcing from talent pool and job boards. |
| Initial Screening | process_step contains "Ön Eleme" |
Recruiter reviewing CVs and conducting introductory screening calls. |
| Assessment & Testing | process_step contains "Online", "Envanter", "Test", "Sınav", "Wall Street", "MMPI" |
Skills assessment, cognitive tests, English evaluations, and psychological inventories. |
| Interview Stage | process_step contains "Birim", "Mülakat", "Görüşme", "PSM", "İK" |
Interviews with Hiring Managers, Technical Committees, and HR Business Partners. |
| Offer Stage | process_step contains "Teklif", "Evrak", "Ücret", "YK Onay" (without finalized hire) |
Compensation proposal created, executive approvals gathered, formal offer extended. |
| Hired & Accepted | hired_employee is not empty OR process_step == "Teklif Kabul" OR status == "Kapatıldı" |
Candidate formally accepted offer, documents completed, onboarding initiated. |
| Archived / Cancelled | status contains "İptal", "Listeden Çıkar", "Cancel" |
Requisitions withdrawn, eliminated from headcounts, or candidates rejected. |
Recruitment Settings
Manage the analysis scope without changing the source workbook. Exclusions apply to every KPI, chart, pipeline and table on this dashboard and are stored only in this browser.
Business Unit
Move units between Included and Excluded. Excluded units disappear from the global Business Unit filter and from all analysis views.
Included0
Excluded0
Position Name
Exclude position names from the analysis scope or move them back into Included when you want them restored.
Included0
Excluded0
Load New Excel File (ise_alim_dosya.xlsx)
Update the dashboard with updated recruitment records directly in your browser
Drag & Drop ise_alim_dosya.xlsx Here
or click to browse from your computer (supports .xlsx and .xlsm up to 50MB)
Expected File Layout
The importer automatically parses the single sheet db and safely skips Column A (check_area). Headers are verified against standard recruitment keys:
[A: check_area] | B: ptf | C: unit | D: position_name | E: status | F: process_step | G: hiring_manager | H: responsible | I: comment | J: position_start_date | K: position_level | L: level_category | M: offer_date | N: hired_employee | O: resource | P: refferal_name | Q: gender