People-analytics mapping becomes operational when the analyst connects a specific HR decision to the data and evidence needed to answer it. You will use Microsoft Excel and supplied Microsoft Copilot examples to map HR questions to relevant workforce fields, compare an AI-assisted first-pass pattern summary with manual segment evidence, and determine which findings are supported. You will document the relationship among questions, data, AI-assisted observation, validation evidence, and decision needs.

A people insight becomes useful when it connects a supported finding to an action that fits the decision and the available evidence. You will organize HR findings into concise evidence-to-action recommendations for managers and HR business partners. You will distinguish observation, likely driver, recommendation, owner, and limitation so the action remains proportionate to what the data can support. You will use Copilot in Excel to draft recommendation wording from selected evidence, then verify every claim, match the action to the evidence, and state the limitation, editing or rejecting the draft wherever it overreaches.

Collaboration measures can point to possible wellbeing or manager-support concerns only when they are interpreted in context and checked for persistence and concentration. You will analyze exported Viva Insights collaboration data with Microsoft Copilot as a first-pass aid and verify the relevant meeting-load, after-hours, and focus-time patterns manually in Excel. You will identify a supported pattern and frame an appropriate manager-support question without treating collaboration measures as individual performance judgments.

Shared metric definitions help HR teams compare reporting periods without changing what a measure means from one report to the next. You will examine standard definitions for headcount, attrition, hiring, tenure, and span measures and identify the population, numerator, denominator, time basis, and inclusion rules that define each measure. You will use a supplied metric guide to explain why two reports with different rules can produce different answers even when both calculations are mathematically correct. You will also ask Copilot to explain a measure in plain language and check that explanation against the supplied guide, so you can explain where a Copilot explanation differs from your organization's approved definition and why that distinction matters for reporting accuracy. This content reflects Microsoft Excel and Microsoft Copilot as of August 2026.

Standardized metric calculations must reproduce the same approved business rules when reporting periods change. You will apply HR metric formulas in Excel using supplied effective-date, population, inclusion, and denominator rules, then verify the results across two reporting periods. You will document the rule assumptions that make the calculation repeatable and identify any records that require clarification before the metric is released. You will use Copilot in Excel to draft or troubleshoot at least one metric formula, then verify its output against the approved business rules before the calculation is reused. Knowing when to accept, correct, or reject a Copilot suggestion is part of the skill.

A technically correct measure can still be wrong for the workforce question. You will use Excel and Power BI evidence to evaluate candidate metrics, select a focused set, and reject measures that distract from the decision. You will also review a supplied Copilot shortlist against the question, available evidence, and business context.

AI-assisted interpretations can accelerate review, but they must be checked against the governing metric definition, source evidence, and known data limitations before they enter a report. You will evaluate supplied Copilot-generated HR interpretations for factual accuracy, definition alignment, segment scope, and transparency about limitations. You will decide which statements can be retained, which require revision, and which should be withheld. The Copilot interpretation of the Power BI evidence is supplied as annotated output; you will also generate one interpretation live with Copilot in Excel, so you review both an AI statement you did not author and one you prompted yourself.

Point-in-time headcount and FTE require clear as-of rules so employee status, effective dates, and assignment records are treated consistently. You will apply agreed inclusion rules in Excel to calculate headcount, FTE totals, and organizational rollups for a supplied reporting date. You will validate the totals against source controls and document any records that need clarification before reporting. You will use Copilot in Excel to draft or troubleshoot the inclusion logic, then verify its result against the supplied control counts before the snapshot is reported.

Period-over-period headcount change becomes useful when the net movement can be explained through the underlying employee events. You will compare two reporting periods, break the change into joiners, leavers, transfers, and reorganizations, and reconcile those components to the reported headcount movement. You will use the evidence to produce a concise explanation that distinguishes workforce movement from data or classification issues.

Recruiting metrics are trustworthy when the source fields, event dates, and calculation rules are clear. This module teaches learners to interpret an ATS-aligned export and use Power BI to calculate requisition volume, pipeline conversion, and time-to-fill. You will verify the metric population and date logic against supplied definitions before the results are used in a hiring review. You will also check a supplied Copilot summary of the same recruiting metrics against your own calculated totals and identify any figure it reports that the export does not support.

Recruiting bottlenecks are visible when funnel patterns are compared across meaningful segments rather than read from overall conversion alone. You will analyze Power BI funnel evidence by role, source, and business unit, identify the stage contributing most to slowed throughput or drop-off, and verify that the pattern is not caused by filter or data-quality differences. You will document the evidence supporting the bottleneck finding and one follow-up question for recruiting review. You will also check a supplied Copilot funnel summary against the segmented evidence and revise any stage or segment it misattributes.

Attrition rates are comparable only when the separation population, turnover type, denominator, and reporting period are defined consistently. In this activity, you will use Excel to calculate voluntary, involuntary, and segment-specific rates, validate them against approved definitions, and make the population and denominator visible. You will also use Copilot to assist with one calculation, then verify its population, numerator, and denominator before reporting the rate.

Retention analysis becomes more useful when the analyst can show where elevated attrition is concentrated and whether the pattern persists across periods. You will analyze Excel and Power BI evidence across tenure, role, location, or other supplied workforce segments, use Copilot as a first-pass pattern aid where provided, and validate the highlighted concentration manually. You will identify the employee group with the strongest supported retention signal and state the evidence and limitation behind the finding.

Retention findings should lead to follow-up that matches the evidence rather than an automatic intervention. You will evaluate attrition evidence, business context, uncertainty, and available response options, then prioritize the HR follow-up action that is most appropriate for the supported finding. You will document why the selected action is proportionate, which alternatives are less supported, and what additional evidence is needed before stronger action is taken. You will also evaluate a Copilot-drafted set of response options, rejecting any that the evidence does not support or that propose action beyond what the finding justifies.

Pay comparisons are interpretable when summary measures and employee groups are appropriate. You will use Excel and Power BI to summarize pay levels, ranges, and distribution patterns, and verify that filters, population rules, and summary methods match the reporting question. You will also use Copilot in Excel to assist with one summary calculation, then verify the population, filters, and summary measure it applied against the supplied reporting guide.

Compensation patterns need systematic comparison before they are escalated for HR partner review. You will analyze Excel and Power BI evidence across job level, geography, and demographic segments to identify unusual pay dispersion, compression, or concentration. You will verify filters and comparable groups, distinguish a descriptive pattern from a cause, and document which finding merits further HR review. You will also validate a supplied Copilot pattern summary against comparable-group evidence and correct any claim it makes that survives only because job level or geography was not controlled.

Professional Context: You are an HR analyst preparing the quarterly workforce review for a multi-region customer-operations organization. Leadership needs to understand whether current staffing pressure is primarily associated with hiring throughput, attrition concentration, headcount movement, compensation patterns, or a combination of factors. A supplied Excel workbook and Power BI report contain the relevant prepared metrics, but several interpretations have not yet been validated and one AI-assisted summary contains an unsupported statement.