|
|
| (5 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{DemoContentNav|next=Spreadsheet:Monthly Workforce Data 2026 Spreadsheet}} | | {{DemoContentNav|next=Spreadsheet:Monthly Workforce Data 2026{{!}}Spreadsheet}} |
| A monthly view of workforce growth, composition, employee development, and recruiting effectiveness. <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}} |
| 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. |
| <excerpt-block name="WorkforceAtAGlance" hidden="false"> | | <excerpt-block name="WorkforceAtAGlance" hidden="false"> |
| ==Workforce at a glance== | | ==Workforce at a glance== |
| Line 18: |
Line 18: |
| </div> | | </div> |
| </excerpt-block> | | </excerpt-block> |
| == 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 |
| Jan,120 | | Jan,120 |
| Line 57: |
Line 57: |
| Campus,6 | | Campus,6 |
| Other,2 | | Other,2 |
| </barchart>Data Source == | | </barchart> |
| | ==Data Source == |
| <sheetdata page="Spreadsheet:Monthly Workforce Data 2026" separator="," format="table" range="a1:J9" /> | | <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. | | The dashboard is based on the [[Spreadsheet:Monthly Workforce Data 2026|monthly workforce data]] maintained in the HR wiki. |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| <excerpt-block name="Workforce_Dashboard" hidden="false">{{Bannerbox|banner-title=Executive Summary (June 2026)|titlesize=20px|titlecolor=#000|banner-text=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'''.|textsize=16px|textcolor=#000|boxbgcolor=#EDF2F8}}</excerpt-block><br>
| |
| '''Purpose''' <br>
| |
| This dashboard provides a monthly overview of workforce composition, growth, retention, and recruiting activity. It brings together key workforce indicators and visualizations based on the latest available HR data.
| |
|
| |
| == Workforce Overview ==
| |
| ''High-level indicators for organizational size and development.''
| |
| <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><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>
| |
| </div><div class="pl-col">
| |
| <span style="text-align: center; display: block;"><piechart title="Workforce Distribution" showvalues="true" width="500">Engineering,137
| |
| Sales,82
| |
| Product,46</piechart></span></div></div>
| |
| ==Retention & Employee Health==
| |
| ''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">Direct,38
| |
| Referrals,31
| |
| Agencies,14
| |
| Job Board,9
| |
| Campus,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">---color:red label:Engineering
| |
| Jan,120
| |
| Feb,123
| |
| Mar,126
| |
| Apr,131
| |
| May,133
| |
| Jun,137
| |
|
| |
| ---color:blue label:Sales
| |
| Jan,80
| |
| Feb,78
| |
| Mar,76
| |
| Apr,80
| |
| May,83
| |
| Jun,83
| |
|
| |
| ---color:green label:Product
| |
| Jan,40
| |
| Feb,41
| |
| Mar,42
| |
| Apr,43
| |
| May,45
| |
| Jun,46
| |
| </linechart></span>
| |
| ==Data Source==
| |
| <sheetdata page="Spreadsheet:Monthly Workforce Data 2026" separator="," format="table" range="a1:J7" />
| |
Switch 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
310
Active employees as of June 2026
Workforce Growth
Current workforce compared to January 1, 2026
29 %
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
|
| Jan | 120 | 80 | 40 | 6 | 5 | 3 | 3 | 7 | 2 |
| Feb | 123 | 78 | 41 | 8 | 4 | 3 | 5 | 6 | 2 |
| Mar | 126 | 76 | 42 | 7 | 6 | 2 | 2 | 2 | 1 |
| Apr | 131 | 80 | 43 | 6 | 5 | 3 | 4 | 2 | 1 |
| May | 133 | 83 | 45 | 7 | 6 | 2 | 3 | 7 | 1 |
| Jun | 137 | 82 | 46 | 8 | 7 | 3 | 4 | 3 | 2 |
| Jul | 141 | 86 | 47 | 7 | 6 | 4 | 3 | 4 | 2 |
| Aug | 145 | 88 | 49 | 8 | 5 | 4 | 4 | 4 | 2 |
The dashboard is based on the monthly workforce data maintained in the HR wiki.
