Excel Human Resources Dashboard
$10-30 USD
Paid on delivery
I want to track all the changes in our headcount:
* All the dates employees were hired, which position they were hired for, and which team they belonged to
* All the dates employees were promoted, including the new positions (and the team)
* All the dates employees resigned / left the company
For example:
Employee 1 was hired as accountant on 01.01.2016, in the accounting team
Employee 2 was hired as purchaser on 03.04.2016, in the operations team
Employee 1 was promoted to senior accountant on 01.07.2016, in the accounting team
Employee 1 was promoted to Accounting manager on 01.12.2016, in the accounting team
Employee 2 was promoted to purchasing manager on 31.12.2016, in the operations team
Employee 1 left the company on 31.12.2018
Employee 2 left the company on 31.12.2018
...
...
The first part is not that difficult, but I am struggling with the second part:
Based on the data above, I want to create:
* a dashboard (with a date filter) with charts showing the headcount over time (monthly/quarterly charts) , the headcount per position over time (monthly/quarterly charts), the headcount per team over time (monthly/quarterly charts),
* a "single employee" report, showing all the details about a specific employee (Date hired, promotions (including dates and positions), date left)
* a "position" report, showing a list of all the employees that were in a specific position on a given date.
* a "New hire" report, showing a list of all the employees that were hired in a specific time period, together with the position they were hired for.
* a "Promotion" report, showing a list of all the employees that were promoted in a specific time period (together with the dates and their old & new positions)
* a "leavers" report, showing a list of all the employees that left the company in a specific time period (together with the date and their position when they left the company)
NOTE: It is important that data is entered in an easy way, and that the dashboard contains filters which can easily be applied.
Project ID: #18535800
About the project
Awarded to:
Hi sir/madam I would like to offer you my services and i hope i can deliver what you need with the best quality as i have previously done such kind of jobs. Hope to hear from you soon.
18 freelancers are bidding on average $43 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Hello Sir Im excel VBA and formula Expert :) i can do make dashboard for see new employer and how many employer that already left from your company please ping me for discuss more and im able to discuss now Thank More
we can discuss budget in inbox. I am mphill in computer science having seven years of experience in Excel dashboard designing. I can deliver you dynamic dashboard. I can also add filter. I already designed many Ex More
I have more than 5 years of experience in data management, preparing dashboards and MS Office automation. you can have a look at my profile for completed projects. You can get your work done with me with highest quali More
Hey. I have a great experience in MS Excel qnd word. I can do this for you. After reading your requirements i'm sure i can do this with full of your requirements and your work will be on time with full requirements. Fo More
A pleasant day... i can try to be my best to do such project. I am looking forward to working with you. Thank you.
Good day. I would really love to be part of this job. I hope i can apply my experience in doing this job. Looking forward, Charmaine
I am a highly motivated person, well organized, detail oriented individual, love multitasking, trustworthy and diligent, hoping to work with you soon.
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just se More
Dear Sir/Madam, Thank you for your project. I am Ms.Htet. I really glad to apply to this position. I think I can do well about this project. If you support format file. It will be convenient for both of us. I hope More
feliz dia, yo trabajé para una empresa mexicana a la cual le hize este tipo de trabajo , de igual forma en mi empleo anterior donde manejaba 100 empleados tambien realice el mismo trabajo ademas que llevaba las cuentas More
Head of human resources of a company with 2500 employees, I have extensive experience in reports of this type, I guarantee satisfaction with the final product
