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: – http://scn.sap.com/docs/DOC-31433

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


/wp-content/uploads/2014/12/screen1_601433.png

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.


/wp-content/uploads/2014/12/screen1_1_601434.png

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.

/wp-content/uploads/2014/12/screen1_2_601435.png

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


/wp-content/uploads/2014/12/screen2_601445.png

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.


/wp-content/uploads/2014/12/screen2_1_601446.png

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


/wp-content/uploads/2014/12/screen2_2_601447.png

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


/wp-content/uploads/2014/12/screen2_3_601456.png

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)


/wp-content/uploads/2014/12/screen3_601460.png

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.

/wp-content/uploads/2014/12/screen3_2_601472.png

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.


Regards,

Ranajay 🙂



To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply