Meryam Sahin (talk | contribs) No edit summary |
Meryam Sahin (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
{{Textbox|boxtype=important|header=Try it yourself|text=Switch to Visual Editor mode {{Icon|bi bi-bs-edit|||}} and experiment with the KPIs and charts. Values are currently maintained manually as part of this demo.|icon=yes}} | {{Textbox|boxtype=important|header=Try it yourself|text=Switch to Visual Editor mode {{Icon|bi bi-bs-edit|||}} and experiment with the KPIs and charts. Values are currently maintained manually as part of this demo.|icon=yes}} | ||
A monthly view of workforce growth, composition, employee development, and recruiting effectiveness. <br>Data is based on active employees and HR activity recorded throughout 2026. | A monthly view of workforce growth, composition, employee development, and recruiting effectiveness. <br>Data is based on active employees and HR activity recorded throughout 2026. | ||
==Workforce at a glance== | ==Workforce at a glance== | ||
<div class="pl-container pl-container-divider"> | <div class="pl-container pl-container-divider"> | ||
<div class="pl-col"> | <div class="pl-col"> | ||
<span style="text-align: center; display: block;"><kpitile max=" | <span style="text-align: center; display: block;"><kpitile max="300" label="Total Workforce" showpercentage="false" desc="Active employees as of August 2026" iconcls="true" value="{{#sheetcell:Monthly_Workforce_Data_2026|K9}}" showscale="false" /></span> | ||
</div> | </div> | ||
<div class="pl-col"> | <div class="pl-col"> | ||
<span style="text-align: center; display: block;"><kpitrend base=" | <span style="text-align: center; display: block;"><kpitrend base="{{#sheetcell:Monthly_Workforce_Data_2026|K2}}" value="{{#sheetcell:Monthly_Workforce_Data_2026|K9}}" tolerance="0.05" label="Workforce Growth" desc="Current workforce compared to January 1, 2026" showtext="true" showpercentage="true" size="medium" /></span> | ||
</div> | </div> | ||
<div class="pl-col"> | <div class="pl-col"> | ||
<span style="text-align: center; display: block;"><kpigauge value=" | <span style="text-align: center; display: block;"><kpigauge value="{{#sheetcell:Monthly_Workforce_Data_2026|Q9}}" label="Attrition rate" showpercentage="true" max="100" color-thresholds="0:green | 0.2:yellow | 0.6:red" unit="%" showscale="false" /></span></div> | ||
</div> | </div> | ||
Workforce development<linechart width="400" title="Monthly headcount by department" showvalues="true"> | Workforce development<linechart width="400" title="Monthly headcount by department" showvalues="true"> | ||
---color:red label:Engineering | ---color:red label:Engineering | ||
| Line 64: | Line 63: | ||
</barchart> | </barchart> | ||
==Data Source == | ==Data Source == | ||
<sheetdata page="Spreadsheet:Monthly Workforce Data 2026" separator="," format="table" range="a1: | <sheetdata page="Spreadsheet:Monthly Workforce Data 2026" separator="," format="table" range="a1:q9" /> | ||
The dashboard is based on the [[Spreadsheet:Monthly Workforce Data 2026|monthly workforce data]] maintained in the HR wiki. | The dashboard is based on the [[Spreadsheet:Monthly Workforce Data 2026|monthly workforce data]] maintained in the HR wiki. | ||
Latest revision as of 10:09, 5 November 2026
Try it yourselfSwitch to Visual Editor mode and experiment with the KPIs and charts. Values are currently maintained manually as part of this demo.
A monthly view of workforce growth, composition, employee development, and recruiting effectiveness.
Data is based on active employees and HR activity recorded throughout 2026.
Workforce at a glance
Total Workforce
289
Active employees as of August 2026
Workforce Growth
Current workforce compared to January 1, 2026
28 %
Attrition rate
Workforce development
Workforce composition
Recruitment & Talent Acquisition
Data Source
| Month | Engineering HC | Sales HC | Product HC | Engineering Hires | Sales Hires | Product Hires | Engineering Exits | Sales Exits | Product Exits | Total Workforce | Total Hires | Total Exists | Beginning Workforce | Average Workforce | Attrition Rate | Overall Attrition Rate |
| Jan | 120 | 80 | 40 | 6 | 5 | 3 | 3 | 7 | 2 | 242 | 14 | 12 | 240 | 241 | 4.98% | |
| Feb | 123 | 78 | 41 | 8 | 4 | 3 | 5 | 6 | 2 | 244 | 15 | 13 | 242 | 243 | 5.35% | |
| Mar | 126 | 76 | 42 | 7 | 6 | 2 | 2 | 2 | 1 | 254 | 15 | 5 | 244 | 249 | 2.01% | |
| Apr | 131 | 80 | 43 | 6 | 5 | 3 | 4 | 2 | 1 | 261 | 14 | 7 | 254 | 257.5 | 2.72% | |
| May | 133 | 83 | 45 | 7 | 6 | 2 | 3 | 7 | 1 | 265 | 15 | 11 | 261 | 263 | 4.18% | |
| Jun | 137 | 82 | 46 | 8 | 7 | 3 | 4 | 3 | 2 | 274 | 18 | 9 | 265 | 269.5 | 3.34% | |
| Jul | 141 | 86 | 47 | 7 | 6 | 4 | 3 | 4 | 2 | 282 | 17 | 9 | 274 | 278 | 3.24% | |
| Aug | 145 | 88 | 49 | 8 | 5 | 4 | 4 | 4 | 2 | 289 | 17 | 10 | 282 | 285.5 | 3.50% | 28.733459357278 |
The dashboard is based on the monthly workforce data maintained in the HR wiki.