People Analytics with Excel + AI

practitioner

en

• - One HRIS export becomes your first clean headcount bridge in 20 minutes, in a workbook you reuse every month.
• - Split one turnover number into cohorts that reveal what's actually driving regrettable attrition, with Copilot checking your reasoning, not writing your conclusion.
• - Band positioning, a merit matrix, and a pay-equity check ahead of the EU Pay Transparency Directive, all built with Copilot at scale.
• - Turn a column of open-ended survey feedback into themes and sentiment with Excel text insights, with privacy thresholds built in.
• - Assemble four workbooks into one leadership-ready pack with Claude Code, then save the playbook so next month takes ten minutes.

• Url: https://aiacademy.anthropos.work/chapters/people-analytics-excel-intro/ · People Analytics with Excel + AI: Start Here · Position: 1 · The export-transform-report loop every HR team runs, and where Copilot and Claude cut it down to an afternoon.
• Url: https://aiacademy.anthropos.work/chapters/people-analytics-headcount/ · Headcount & Org Reporting · Position: 2 · One HRIS export becomes your first clean headcount bridge in 20 minutes, in a workbook you reuse every month.
• Url: https://aiacademy.anthropos.work/chapters/people-analytics-attrition/ · Attrition & Retention Analysis · Position: 3 · Split one turnover number into cohorts that reveal what's actually driving regrettable attrition, with Copilot checking your reasoning, not writing your conclusion.
• Url: https://aiacademy.anthropos.work/chapters/people-analytics-comp-review/ · The Comp Review Cycle · Position: 4 · Band positioning, a merit matrix, and a pay-equity check ahead of the EU Pay Transparency Directive, all built with Copilot at scale.
• Url: https://aiacademy.anthropos.work/chapters/people-analytics-survey-comments/ · Make Sense of Survey Comments · Position: 5 · Turn a column of open-ended survey feedback into themes and sentiment with Excel text insights, with privacy thresholds built in.
• Url: https://aiacademy.anthropos.work/chapters/people-analytics-monthly-dashboard/ · The Monthly People Dashboard · Position: 6 · Assemble four workbooks into one leadership-ready pack with Claude Code, then save the playbook so next month takes ten minutes.

Course Mode: online · Course Workload: PT110M · Mode: online