Skip to Content
Author's profile photo Former Member

Data Geek III: “Human Capital Management Analysis”

Hey Everyone,

I chose the House of Dragons where the Business prevails as my allegiance.

My module’s name is Human Capital Management (HCM). The reason I chose this is because I think for any organization to run its business, HCM plays a very crucial role. Say it be Recruitment of Employees, Manpower Utilization, Revenue Consumption or Cost included. Everywhere the HCM data and its analysis is required.

Some Technical Points:-

  • SAP Lumira 1.19 desktop version has been used to build up the story.
  • Esri connection has been done to fetch the live real time World map for analysis.
  • Source of Data- SAP Data Geek library of HRM USA Data datasets: –

The KPI’s which we will inherit from this story board are :-

  • What is the Recruitment Trend of an Organization
  • How well is the Training Budget  consumed within an Organization
  • Employee Performance comparison across different Tenure Groups.
  • Resource Utilization across different Occupation Code

Now let’s take deeper look into the story I have created here.

The First Page: Recruitment Trend


In the above snapshot I have tried to portray a Geographical picture to see the distribution of the employees and the training budget utilized across different regions. An Input control of Year has been provided here if we want to see Year on Year breakdown.


This is a live real time World Map powered by ESRI in which the employee distribution across different geographies has been plotted. You can zoom in and out like you do in Google maps. The bubble size shows the count of Employees in that region.

The second chart below is the pie chart representation across different geographies.


The inference what I made here is I can easily see in which geography my training budget is been absorbed. And for which Tenure Group particularly the Training Budget is high.

Thought process which this screen ignites:

  • Where can we have new growth markets (NGM) and where is the highest manpower stock available to be extended for that NGM?
  • Secondly, where is the maximum training budget getting absorbed and why?

The Second Page: Manpower Distribution & Performance Comparison


This snapshot implies the Manpower distribution across state and how well are they performing in their respective groups.

A filter by State has been provided here in case the user just wants to view those results which are making maximum impact.


In the above we are looking at Employee and Salary Consumption trend state wise.


A table which gives a peak to the Employee details giving us the reason to retain them for future or not.


This bar chart helps us determine the Top Performer, Sustained, Not Sustained and Unacceptable across different business groups.

Thought process which this screen ignites:

  • Identify the employee needed to be retained, who all need special attention so that they can upgrade themselves to improve their performance.
  • The Annual Salary Vs. Employee Count trend by State proposes us the option to relocate people if not required in that state, helping us reduce the Overall cost of the Company.

The Third Page: Resource Utilization (Manpower/Cost)


This above view summarizes the overall Utilization of the Resources enabling the User to take that next step for making an impact on the business.

screen 3.1.png

The above Pareto Chart shows the number of Employee Count and Training budget Utilized by them across different Occupation Codes. Perfect blend to estimate the Cost Realization and how effectively we can utilize them to get more business.


The Cost center analyses, determines the most harnessed center from training point of view.

screen 3.3.png

    A blueprint to Employee Distribution by Occupation across different geographies.

Thought process which this screen ignites:

  • Why and what occupation needs more recruitment, how well the resources are been utilized?  
  • Which all are the business areas where we need to build the capabilities?

Thank you everybody for reading it.

Hopefully you enjoyed reading my story.

Please share your comments and feedback.


Ranajay 🙂

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Impressive Analysis Ranajay.

      Author's profile photo Former Member
      Former Member


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Mayank and Pierre 🙂

      Author's profile photo Nadeem Akhtar
      Nadeem Akhtar

      Great use of nascent technology. Awesome analysis can be put to use.

      Author's profile photo Former Member
      Former Member

      Nice presentation.... 🙂