HR Analytics - Build Dynamic Excel Dashboard from Scratch

Well, we're going to build an interactive dynamic dashboard in excel. Yes you heard it right. We gonna create it in MS Excel. No, we are not kidding…. Let me show you the end result, then you might believe me. You may have seen dashboards in tableau, power BI. but it's time you learn how to do that in excel.

Why excel?

My reason for building it in MS excel is because excel is easily available to everyone, and almost everyone have hands-on experience in working in Excel.

Additionally let me tell you one very amazing part. You gonna learn to create the dashboard in less than two hours. Yes you heard it right, in less than 2 hours Amazing isn't it. Just imagine, your manager asked you to submit the report, and comeback with and interactive, dynamic, analytical dashboard. Definitely, It is going to add some extra points in your performance score. Start expecting a good bonus already.

Now your question would be Why do we create a dashboard? What is the purpose?

The main purpose of an operational Dashboard is to provide a comprehensive snapshot of performance, which means that you should incorporate a large amount of detail without using too many drill downs. Analytical Dashboards – Use data from the past to identify trends that can influence future decision-making.

In this course we used one of the very popular KPI “Time to Hire” and built an interactive dashboard around it. Which calculates and visualize the ageing of different stages, then we can also check or you can say filter the data week wise, by sourcing channel, skill wise. Also we can go ahead and check the recruiters efficiency, which business unit is takes too much time to get the candidate hired.

We have also went ahead and created an anatomy of dashboard which will help you drill down the problem into smaller parts so that it becomes easy for you to build any interactive dashboard in very less time. That is a step by step approach to build a dashboard for any type of business problems.