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.
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.
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 dynamic dashboards, and Reports.
I can create the complete HR dashboard with all part you have explained in specifications, in Excel or Power bi whatever you like.
You can send me your data and project details I will complete one part for free and will send you, after checking my you can decide to award me.
I have completed many similar projects before, you can check some of my previous works here.
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Waiting for your reply, Please send me a message to discuss further.
Thanks
$100 USD w 1 dzień
4,8 (59 opinii)
5,7
5,7
18 freelancerzy składają oferty o średniej wysokości $43 USD dla tej pracy
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.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
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 you
Galih
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 I’m the person you’re looking for?
Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job.
Do you want me to start working on the sample?
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 Excel dashboards designing.
I can deliver you samples before starting the work.
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 quality at lowest price.
I accept payment only after you are completely satisfied with the work.
looking forward to work with you
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. For further details contact me l.
"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 send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response.
Best Regards."
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 Analysis, Statistics, R programming, tableau, excel, python, c++
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 we can do business toghter.
BR,
Htet
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 por cobrar de todas las cajeras y el principio de orden es practicamente igual.
soy nueva en freelance pero se que podria lograr lo que desea.
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