Meryam Sahin (talk | contribs)
No edit summary
Meryam Sahin (talk | contribs)
No edit summary
 
(36 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|next=Spreadsheet:Monthly Workforce Data 2026{{!}}Spreadsheet}}
'''Executive Summary (June 2026)''' <br> <br>
{{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}}
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'''.
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.
<excerpt-block name="WorkforceAtAGlance" hidden="false">
==Workforce at a glance==
 
<div class="pl-container pl-container-divider">
<div class="pl-col">
<span style="text-align: center; display: block;"><kpitile max="350" label="Total Workforce" showpercentage="false" desc="Active employees as of June 2026" iconcls="true" value="310" /></span>
</div>
</div>
<br>
 
<br>
<div class="pl-col">
'''Purpose''' <br>
<span style="text-align: center; display: block;"><kpitrend base="240" value="310" 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==
 
<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="29" label="Attrition rate" showpercentage="true" max="100" color-thresholds="0:green | 0.2:yellow | 0.6:red" unit="%" /></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
</excerpt-block>
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
<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==
<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;"><kpitrend base="23" value="31" tolerance="0.05" showtext="false" showpercentage="true" size="medium" label="8 days faster than January" /><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==
<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 26:
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 35:
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 46:
May,45
May,45
Jun,46
Jun,46
---color:green label:Product</linechart></span>
Jul,47
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:J9" />
 
The dashboard is based on the [[Spreadsheet:Monthly Workforce Data 2026|monthly workforce data]] maintained in the HR wiki.

Latest revision as of 07:21, 2 September 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
310
Active employees as of June 2026
Workforce GrowthCurrent workforce compared to January 1, 2026
29 %
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
Jan1208040653372
Feb1237841843562
Mar1267642762221
Apr1318043653421
May1338345762371
Jun1378246873432
Jul1418647764342
Aug1458849854442

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