Turn raw HR data into actionable workforce insights using Microsoft Excel, Power Query, Microsoft Power BI, and Microsoft Copilot. In this program, you'll learn to prepare and govern people data, run headcount, attrition, hiring, and compensation analyses, and communicate findings through executive-ready dashboards and narratives. AI-assisted workflows are integrated throughout so you can draft insights faster, validate outputs confidently, and recommend evidence-based HR actions. By the end, you'll produce reusable workbooks, interactive Microsoft Power BI reports, and workforce-planning summaries that support real business decisions.

This program is designed for HR analysts, people analytics professionals, and HRIS practitioners who want to strengthen their data-to-insight workflow with Microsoft tools. You'll get the most value if you have basic Microsoft Excel familiarity and an interest in using AI to accelerate your people-reporting responsibilities. No experience with a specific HR platform or applicant tracking system is required - where ATS data appears, the focus is on interpreting exports in Microsoft Excel and Microsoft Power BI, not navigating any particular tool.

Übungsprojekt

You'll complete three integrative projects that mirror real Human Resource (HR) analyst work. In the first, you'll build a governed, analysis-ready HR dataset from messy source files. In the second, you'll produce a multi-metric workforce analysis covering headcount, attrition, hiring, and pay. In the third, you'll deliver an executive-ready Microsoft Power BI dashboard with an AI-assisted narrative briefing and workforce-planning recommendation for leadership.