I will create workforce analytics dashboards in excel for HR

Majority of the Microsoft Excel users, Excel is treated as a tracking or computation mechanism. Via the Excel dashboards and VBA automated templates my attempt is to show case the unexploited/unexplored features of excel when it comes to data visualizations or be it automating the repeated manual process. You can create magic with Excel provided, its used properly exploiting this applications full potential.

This Gig is all about an excel based dashboard for Human resources / Work force demographics showcasing various slice & dice of HR data into meaningful insight's. What else? : - you have an elegant beautiful eye catchy dashboard in place which is more interactive with the report filtering options.

Few of the summaries included in this dashboard:

1. Active / Inactive staff count
2. Staff Retention %
3. Staff Average Age
4. Staff Average Tenure
5. Gender Diversity % split
6. Headcount hierarchy pyramid
7. Cost to company analysis (Annual & monthly)
8. Joiners / Leavers Ratio
9. Staff Turn over rate analysis
10. Exit reason analysis

The best part which feel about this dashboard is that you have all the above summaries in a single page with quite a lot of button click filter options. Check it yourself.