Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Develop advanced people analytics capabilities to analyze workforce supply and demand, segment critical roles, and identify skill gaps. You will use Power BI, Excel with Copilot, and Viva People Skills to build predictive models, conduct retention risk analysis, and quantify workforce gaps. This course transforms you into a strategic advisor who uses data to anticipate and address talent challenges before they impact business performance. The curriculum requires Power BI Desktop (Windows PC or Mac with Parallels Desktop) for advanced analytics and visualizations. While Microsoft 365 with Copilot significantly enhances forecasting and analysis activities, free online versions may be used with limited functionality. All exercises are supported by provided sample datasets for Viva Insights and Viva People Skills, ensuring a hands-on learning experience that prepares you to tackle complex workforce modeling and predictive analytics in a professional setting.

Syllabus

Workforce Demand: Estimate Future Needs

Learn to translate business growth projections into concrete workforce requirements using data-driven forecasting methods enhanced by AI.

Workforce Demand: Create Strategic Scenarios

Develop multiple workforce demand scenarios that reflect different strategic paths, enabling leadership to understand talent implications of business decisions.

Workforce Supply: Assess Current State

Build a view of your current workforce supply by analyzing headcount trends, talent movement patterns, and pipeline strength across the organization.

Workforce Supply: Build Pipeline KPIs

Transform raw talent pipeline data into actionable KPIs that predict future talent availability and highlight areas requiring intervention.

Critical Roles: Build Segmentation Matrix

Develop a systematic approach to identifying which roles deserve strategic focus by evaluating their business impact and talent scarcity.

Critical Roles: Visualize Role Clusters

Transform your role segmentation analysis into dynamic visualizations that reveal patterns and enable data-driven discussions about talent investment priorities.

Workforce Gaps: Map Skill Capabilities

Create skill inventories that compare your organization's current capabilities against future requirements using advanced analytics tools.

Workforce Gaps: Visualize Skill Gaps

Transform complex skill gap data into intuitive visualizations that highlight critical capability shortfalls and guide investment decisions.

Workforce Gaps: Calculate Gap Metrics

Move beyond simple comparisons to create sophisticated gap calculations that quantify shortfalls in FTEs, costs, and time-to-close.

Workforce Gaps: Prioritize Risks

Create sophisticated risk models that help leadership prioritize which gaps to address first based on business impact, closure difficulty, and strategic importance.

Retention Risks: Analyze Attrition Patterns

Uncover hidden patterns in attrition data and extract meaningful themes from exit interviews using AI-powered analysis to inform retention strategies.

Retention Risks: Build Risk Heatmaps

Transform retention risk analysis into powerful visual tools that highlight where your organization faces the greatest talent loss exposure.

Project Module: Workforce Gap Analysis

Synthesize your people analytics skills by conducting a comprehensive workforce gap analysis that integrates demand forecasting, supply assessment, and risk prioritization into actionable recommendations.