В работе

Excel Human Resources Dashboard

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.

Квалификация: Ввод данных, Обработка данных, Excel, Трудовые ресурсы

Показать больше dynamic dashboard template in excel, recruitment dashboard excel template, how to make hr dashboard in excel, hr dashboard ppt, sample hr report to board, headcount report template, best hr dashboards, what is an excel dashboard, human resources model, sop human resources, steve manard human resources management, human resources strategic management, sites opportunities bid projects human resources, certificate courses human resources india, management human resources, human resources program coding, human resource dashboard, hospital human resources email, selling human resources, excel online marketing dashboard

О работодателе:
( 5 отзыв(-а, -ов) ) Sandnes, Norway

ID проекта: #18535800

Поручен:

KhalilAcca

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.

$20 USD за 1 день
(1 отзыв)
0.0
aimefx

Hi, I am expert in Excel, Access VBA, MySQL, Google Sheet, and Power BI. I can database and can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dyn Больше

$100 USD за 1 день
(59 отзывов(-а))
5.7

18 фрилансеров(-а) в среднем готовы выполнить эту работу за $43

schoudhary1553

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. Больше

$100 USD за 2 дней(-я)
(302 отзывов(-а))
7.8
prameswara

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 Больше

$30 USD за 1 день
(343 отзывов(-а))
7.0
dvcontact

Hi, If you are looking for an Expert in Data Entry, Data Processing, Excel to create dashboard that will be used in tracking changes in employment of your headcount, I am the most suitable candidate. Why am I so sure Больше

$30 USD за 1 день
(41 отзывов(-а))
5.9
usmanhassan123

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 Больше

$30 USD за 1 день
(57 отзывов(-а))
6.0
bhupendrayadav

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 Больше

$28 USD за 1 день
(17 отзывов(-а))
4.0
Bilalchoudary

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 Больше

$12 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
shavernet1

A pleasant day... i can try to be my best to do such project. I am looking forward to working with you. Thank you.

$25 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
bluewatercruisep

Dear Sir / Madam, Thanking very much your job opportunity. I had 20 years experience , date entry , data processing in excel and human resources as well. I had [login to view URL] degree and CIMA (UK) intermediate qualification Больше

$30 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
cgallevo

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

$35 USD за 1 день
(0 отзывов(-а))
0.0
iammeberlyr

I am a highly motivated person, well organized, detail oriented individual, love multitasking, trustworthy and diligent, hoping to work with you soon.

$20 USD за 1 день
(0 отзывов(-а))
0.0
webscraper24

"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 Больше

$100 USD за 2 дней(-я)
(2 отзывов(-а))
0.0
kazi9

Hi, I am a UOW Graduate on computer science with Big Data as major. I have done similar project before on a taxi driver data for rome. I would love to help you with this project. Relevant Skills and Experience Data An Больше

$25 USD за 1 день
(0 отзывов(-а))
0.0
htethtetwathan

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 Больше

$15 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
HenryH20

I am an expert data entry specialist with years of experience in data entry using excel for a japanese manufacturing firm to be shown on monthly board [login to view URL] it easy for you is my motto. Relevant Skills and E Больше

$25 USD за 1 день
(0 отзывов(-а))
0.0
ascaniomila

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 Больше

$35 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
roquepalacios

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

$111 USD за 10 дней(-я)
(0 отзывов(-а))
0.0