Based on the data above, I want to an interactive dashboard in excel that can be updated automatically (with a date filter) and drop down boxes where with charts and widgets showing the type of staff movement count over time (monthly/quarterly charts) ,
the staff movement headcount per position over time (monthly/quarterly charts), drop down box to allow to see a specific staff movement, that is, promotion, lateral transfer, etc
the type of staff movement count per department over time (monthly/quarterly charts, widgets),
the type of staff movement count per staff category over time (monthly/quarterly charts),
Reason Type by gender % that is % of female/male who was promoted/lateral transfer, etc
a “Movement report, where I can click on a drop down and select employees that were promoted/transfer/temp to permanent in a specific time period (together with the dates and their old & new positions, time spent in their old positions and comments) *
The post the staff movement headcount per position appeared first on My Assignment Online.