Browse history interactively
← Older edit

Meryam Sahin (talk | contribs)

14 user groups
4,331 edits
VisualWikitext
Meryam Sahin (talk | contribs)
ALL_admin, CM_admin, IMS_admin, Administrators, wiki_FIN_reader, wiki_HR_editor, wiki_HR_reader, wiki_IIT_reader, wiki_IMS_editor, wiki_IMS_reader, wiki_MnS_reader, wiki_RnD_editor, wiki_RnD_reader, wiki__global_admin
4,331 edits
No edit summary
Meryam Sahin (talk | contribs)
ALL_admin, CM_admin, IMS_admin, Administrators, wiki_FIN_reader, wiki_HR_editor, wiki_HR_reader, wiki_IIT_reader, wiki_IMS_editor, wiki_IMS_reader, wiki_MnS_reader, wiki_RnD_editor, wiki_RnD_reader, wiki__global_admin
4,331 edits
No edit summary
 
(38 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="background:#F9EBEC; border:1px solid #EFC8C9; border-radius:10px; padding:14px; margin-bottom:15px; text-align:center;">
{{DemoContentNav
'''Executive Summary (June 2026)''' <br> <br>
|next=Spreadsheet:Monthly Workforce Data 2026
Workforce size increased to '''265 employees''', representing '''10.4% growth''' since January. Attrition remains healthy at '''3%''', while '''82% of performance reviews''' have been completed. Recruiting efficiency continues to improve, with average time-to-hire reduced from '''31 days to 23 days'''. Engineering remains the largest department, accounting for '''51.7% of the workforce'''.
|nextlabel=Spreadsheet
|explore=Main Page
|explorelabel=All journeys
}}
{{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.
==Workforce at a glance==
 
<div class="pl-container pl-container-divider">
<div class="pl-col">
<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>
<br>
 
<br>
<div class="pl-col">
'''Purpose''' <br>
<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>
This dashboard provides a consolidated view of workforce composition, growth, retention, and recruiting effectiveness across the organization. Metrics are ''updated monthly'' and reflect active employees, workforce movements, and talent acquisition performance.
</div>
==Workforce Overview==
 
''High-level indicators for organizational size and growth''<div class="pl-container"><div class="pl-col"><span style="text-align: center; display: block;"><br><br><br> <br><kpitile value="265" max="300" label="Total Workforce" showpercentage="false" desc="Active employees as of June 2026" iconcls="true" /></span>
<div class="pl-col">
</div><div class="pl-col"><span style="text-align: center; display: block;"><br> <br><br><br> <br><kpitrend base="240" value="265" tolerance="0.05" label="Workforce Growth" desc="Current workforce compared to Jan 1, 2026" showtext="true" showpercentage="true" size="medium" /></span>
<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 class="pl-col">
</div>
<span style="text-align: center; display: block;"><piechart title="Workforce Distribution" showvalues="true" width="500">Engineering,137
 
Sales,82
Workforce development<linechart width="400" title="Monthly headcount by department" showvalues="true">
Product,46</piechart></span></div></div>
---color:red label:Engineering
==Retention & Employee Health==
Jan,120
''Indicators on employee exits during the first half of 2026 relative to average workforce size''<div class="pl-container"><div class="pl-col"><span style="text-align: center; display: block;"><kpigauge value="3" max="10" label="Attrition Rate" unit="%" color-thresholds="0:green | 0.4:yellow | 0.6:red" showpercentage="false" /></span>
</div><div class="pl-col"><span style="text-align: center; display: block;"> <br> <kpiprogress value="82" max="100" label="Performance Review Completion" showpercentage="true" /></span>
</div></div>
==Recruitment & Talent Acquisition==
''Measures recruiting efficiency and hiring effectiveness''<div class="pl-container"><div class="pl-col">
<h3 style="text-align:center;">Average Time to Hire</h3>
<span style="text-align: center; display: block;"><kpitile value="23" showpercentage="false" iconcls="true" unit="days" max="30" desc="Average number of days from job posting to accepted offer" /></span>
</div><div class="pl-col"><h3 style="text-align:center;">Hiring Efficiency</h3><span style="text-align: center; display: block;"><kpiprogress value="23" max="30" label="8 days faster than January" showpercentage="true" color-thresholds="0:green |0.8:yellow |1.0:red" /><br>Time-to-hire '''improved''' from '''31 days in January''' to '''23 days in June''', indicating increased recruiting effectiveness and streamlined hiring workflows</span>
</div><div class="pl-col"><barchart title="Recruiting Sources" width="500">Company website,38
Employee referrals,31
Recruiting agencies,14
Career website,9
University hiring,6
Other,2</barchart></div></div>
==Workforce Trends==
''Longitudinal view of workforce development''<span style="text-align: center; display: block;"><linechart width="500" title="Headcount Growth by Department">Jan,120
Feb,123
Feb,123
Mar,126
Mar,126
Line 36: Line 30:
May,133
May,133
Jun,137
Jun,137
---color:red label:Engineering
Jul,141
Aug,145
 
---color:blue label:Sales
Jan,80
Jan,80
Feb,78
Feb,78
Line 42: Line 39:
Apr,80
Apr,80
May,83
May,83
Jun,83
Jun,82
---color:blue label:Sales
Jul,86
Aug,88
 
---color:green label:Product
Jan,40
Jan,40
Feb,41
Feb,41
Line 50: Line 50:
May,45
May,45
Jun,46
Jun,46
---color:green label:Product</linechart></span>
Jul,47
==Data Source==
Aug,49
</linechart>Workforce composition<piechart showvalues="true" width="500" title="Current workforce distribution">Enginering,145
Sales,88
Product,49</piechart>Recruitment & Talent Acquisition<barchart title="Recruiting Sources" width="500">
Direct,38
Referral,31
Agencies,14
Job Board,9
Campus,6
Other,2
</barchart>
==Data Source ==
<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.

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 GrowthCurrent workforce compared to January 1, 2026
28 %
Attrition rate

Workforce development

Monthly headcount by department

Workforce composition

Current workforce distribution

Recruitment & Talent Acquisition

Recruiting Sources

Data Source

MonthEngineering HCSales HCProduct HCEngineering HiresSales HiresProduct HiresEngineering ExitsSales ExitsProduct Exits Total WorkforceTotal HiresTotal ExistsBeginning WorkforceAverage Workforce Attrition RateOverall Attrition Rate
Jan120804065337224214122402414.98%
Feb123784184356224415132422435.35%
Mar12676427622212541552442492.01%
Apr1318043653421261147254257.52.72%
May133834576237126515112612634.18%
Jun1378246873432274189265269.53.34%
Jul14186477643422821792742783.24%
Aug14588498544422891710282285.53.50%28.733459357278

The dashboard is based on the monthly workforce data maintained in the HR wiki.

Retrieved from "https://galaxy.demo.bluespice.com/HR/index.php?title=Workforce_Dashboard&oldid=1084"