Danielle_B87
New Member
- Joined
- Jan 11, 2016
- Messages
- 1
Hi
I am new to this forum and have a homework question.
I have a set of data in the below format (with about 700 rows and 30 columns)
I have been asked based on the data provided, what three recommendations I would make to the client to help them improve their recruitment performance on the website?
I was wondering if I could send someone ( a helpful soul) the full excel file so they could help me produce some analytical insight around the dataset.
Much appreciated
Danielle.
<tbody>
</tbody>
I am new to this forum and have a homework question.
I have a set of data in the below format (with about 700 rows and 30 columns)
I have been asked based on the data provided, what three recommendations I would make to the client to help them improve their recruitment performance on the website?
I was wondering if I could send someone ( a helpful soul) the full excel file so they could help me produce some analytical insight around the dataset.
Much appreciated
Danielle.
Job ID | Job title | Business Unit | Division | Department | Work type | Job Location | Job City | Job State | Ads on SEEK | Source opening date | Date application submitted | Date Upfront Screening | Date Hiring Manager Review | Date Interview | Date offer made | Date offer accepted | Date offer declined | Job Filled | Summary Views | Detail Views | Application Starts | Application Completes | Hiring Manager Review | Interviewed | Offer Made | Accepted | Hired | Applications vs Market | Difficulty To Source in Market |
623924 | Branch Manager | Banking - 941 | Distribution - 8940 | Personal Customers - 7931 | Permanent Full Time | Armadale | Perth | WA | 3 | 16/07/2014 | 15/08/2014 | 14/08/2014 | 26118 | 383 | 28 | 14 | 0 | 5 | 0 | 0 | 0 | 1 Fewer applications than market (bottom tercile) | 3 Moderate (middle quintile for applications) | ||||||
623928 | Auditor | Group Chief Risk Officer - 1198 | Internal Audit - 927 | Internal Audit - 1335 | Max Term Full Time | Brisbane | Brisbane | QLD | 1 | 3/07/2014 | 22/07/2014 | 28/07/2014 | 29/07/2014 | 14919 | 186 | 16 | 8 | 0 | 6 | 0 | 0 | 0 | 2 Comparable applications to market (middle tercile) | 5 Hardest to fill (highest quintile for applications) | |||||
623932 | Manager, Corporate Development | Group CFO - 110 | Group Strategy - 2130 | Corporate Strategy - 2133 | Permanent Full Time | Brisbane | Brisbane | QLD | 1 | 3/07/2014 | 19/07/2014 | 23/07/2014 | 7/08/2014 | 12/08/2014 | 14/08/2014 | 15/08/2014 | 21885 | 622 | 35 | 16 | 0 | 8 | 3 | 1 | 1 | 3 More applications than market (upper terticle) | 5 Hardest to fill (highest quintile for applications) | ||
623936 | Business Development Officer | Banking - 941 | Distribution - 8940 | Banking Intermediaries - 8450 | Permanent Full Time | Perth | Perth | WA | 1 | 2/07/2014 | 14/07/2014 | 8150 | 322 | 33 | 16 | 0 | 0 | 0 | 0 | 0 | 3 More applications than market (upper terticle) | 5 Hardest to fill (highest quintile for applications) | |||||||
623939 | HR Business Partner | Human Resources - 2221 | Bank HR - 2599 | HR Banking Case Management - 8139 | Permanent Full Time | Brisbane | Brisbane | QLD | 1 | 4/07/2014 | 18/07/2014 | 22/07/2014 | 19/08/2014 | 7/08/2014 | 19/08/2014 | 19/08/2014 | 11484 | 518 | 31 | 20 | 0 | 6 | 6 | 2 | 1 | 1 Fewer applications than market (bottom tercile) | 1 Easiest to fill (lowest quintile for applications) |
<tbody>
</tbody>