Recruitment (Dashboard)
Overview
- Six filters for Department, Position, Location, Stage, Source, and Status, every one built from the values actually present in the list
- An overall applicant count above a column chart of applications by month, each column labelled with its share of the busiest month
- A source card pairing the hired count with ranked bars for the top sources and top departments, closing on a one-line insight naming the strongest channel
- A pipeline snapshot counting the active requisitions represented, with a density grid and a line stating how many positions and locations the pipeline spans
- A metrics card that toggles between process and quality – average days in process against a twenty-five day goal, or the rejection rate – on a single progress bar
- Conversion, open applications, and hiring manager tiles across the middle row, with total applications and offer acceptance rate closing the page
- A sortable fifteen-column applicant table with candidate search and status badges, and everything on the page recalculates together when a filter changes
Benefits
- Replaces the weekly recruiting spreadsheet and the chart refresh that goes with it
- Shows whether time to hire is inside target while there is still a candidate to lose
- Makes the strongest sourcing channel visible, which is where recruiting budget decisions actually get made
- Gives each hiring manager a filtered view of their own requisitions without a separate report
- Turns a list the HR team already maintains into reporting, with no new system to buy or roll out
- Serves the HR director and the recruiter from one page, because the filters change who the page is for
- Opens in any browser and can be embedded directly into a SharePoint page
Details
- Build Method: Copilot Dashboard
- Chart Types: KPI card, Column chart, Bar chart, Heatmap, Table
Common Questions About the Recruitment Dashboard
What is this recruitment dashboard built with?
It is built on a standard SharePoint list of applicants and requisitions, with Microsoft 365 Copilot generating the dashboard page from that list. There is no third-party applicant tracking system and nothing to license beyond Microsoft 365. The charts, filters, and applicant table all live on one page that can be embedded in a SharePoint site – the kind of clean, maintainable reporting Greg Zelfond builds for HR teams.
What is included on the recruitment dashboard?
An applicant volume column chart by month, a source card ranking channels and departments, a pipeline snapshot of active requisitions, a metrics card toggling between average days in process and rejection rate, conversion and open application tiles, an offer acceptance rate, and a searchable applicant table. Filters cover department, position, location, stage, source, and status.
Where does the dashboard data come from?
A single SharePoint list with fifteen columns – requisition ID, position, department, hiring manager, location, candidate ID, stage, source, applied and stage-changed dates, offer date, start date, days in process, status, and rejection reason. Most HR teams already keep a version of this list.
Does the dashboard refresh automatically from the SharePoint list?
This example carries its data with it, so it opens instantly and works offline, and it is refreshed by regenerating the page from the current list. When a live-refreshing view is the requirement instead, the same numbers can be charted with the Quick Chart web part directly on a SharePoint page, or with Power BI when scheduled refresh is needed.
Should we use Copilot, the Quick Chart web part, or Power BI?
It depends on how much you need. The Quick Chart web part is the lightest option – one chart, pointed at a list, no setup. A Copilot-generated dashboard suits a full page with filters and several linked charts that move together. Power BI earns its place when data volumes are large, sources need joining, or row-level security and scheduled refresh matter.
Can Greg build this dashboard for our organization?
Yes – this is exactly the kind of work Greg Zelfond does. As an independent SharePoint consultant and Microsoft MVP, he sets up the underlying list, shapes the columns so the charts are worth drawing, and builds the dashboard around the questions your leadership actually asks rather than the ones the data happens to answer. Reach out through the contact page.
