Edit

Share via


Workforce metrics Power BI content

This article describes the Workforce metrics Microsoft Power BI content. It explains how to access the Power BI reports, and provides information about the data model and entities that were used to build the content.

Accessing the Power BI content

The Workforce metrics Power BI content appears in the Personnel management workspace if you use one of these products:

  • Microsoft Dynamics 365 Finance
  • Microsoft Dynamics 365 Human Resources

Metrics that are included in the Power BI content

The following table lists the metrics that are shown on each report.

Report Metrics
People Metrics Summary of other reports
Headcount Analysis Company, Department, Location Headcount by company, headcount by department, headcount by location, and total headcount
Headcount Analysis Job, Step, Manager Headcount by job, headcount by step, headcount by manager, and total headcount
Headcount Trend Analysis Headcount this year versus last year by company and rolling headcount for the last 12 months
FTE Analysis Total full-time equivalent (FTE), total assigned FTE, FTE by department, FTE for the last 12 months, and FTE by job
Workforce Demographics Headcount by age and gender, headcount by ethnic origin, headcount by veteran status, headcount by marital status, number of full-time students, average tenure, average age, ratio of female to male employees, and languages spoken by employees
Position Analysis Open positions by department, open-to-filled positions, active-to-inactive positions, and positions by department
Attrition Analysis Attrition this year versus last year, attrition, exiting employees by age and gender, average tenure of employees leaving, employees exiting this month, and employees leaving by reason
People by department Employees with a personnel number by department, position, and assignment start and end dates
Seniority Analysis Average tenure, average years of service by company, and seniority list
Employee Anniversaries Anniversaries this month, anniversaries next month, employees by years of service, and anniversaries, years of service by department
Employee Birthdays Birthdays this month, birthdays next month, employee birthdays, and birthdays by month and department
Mass Hire Projects Total mass hire projects, mass hire projects by status, mass hire projects by department and owner, mass hire projects by job, and mass hire projects

You can filter the charts and tiles on these reports, and pin the charts and tiles to the dashboard. For more information about how to filter and pin in Power BI, see Create and configure a dashboard.

Be sure to download the Workforce metrics Power BI content that applies to the version of Microsoft Dynamics 365 that you're using.

Note

The .pbix files available in Lifecycle Services apply to finance and operations apps only.

Understanding the data model and entities

The following table shows the entities that the content was based on.

Entity Contents Relationships with other entities
Calendar Offset Calendar offsets to slice reports Past Position Assignment, Position Trend, Employee Trend, Terminated Employee
Company Companies to filter reports by Current Employee, Terminated Employee, Employee Trend
Current Position Positions as of the current date, FTE, open positions, and open-to-filled positions Job, Position
Current Employee Workers as of the current date, age, and headcount Company, Geographic Location, Employee Name, Reports To, Employee Title, Demographics, Job, Employment, Position
Date Days, weeks, months, and years Past Position Assignment, Position Trend, Terminated Employee, Employee Trend
Demographics Date of birth, gender, ethnic origin, and marital status Current Employee, Terminated Employee, Employee Trend
Employment Start date, end date, and transition date Current Employee, Terminated Employee, Employee Trend
Geographic Location City, county, postal code, and state or province Current Employee, Terminated Employee, Employee Trend
Job Function, type, and title Current Position, Current Employee
Past Position Assignment Assignment reason, start date, end date, and job Calendar Offset, Date, Job, Position
Position Department, FTE, position, position type, and title Current Position, Current Employee
Position Trend Positions over time, FTE, and job Calendar Offset, Date, Job, Position
Reports To First name, last name, and full name Current Employee, Terminated Employee, Employee Trend
Terminated Employee Terminated workers, termination date, title, position, and job Company, Geographic Location, Employee Name, Reports To, Calendar Offset, Date, Employee Title, Demographics, Employment, Job, Position
Employee Name First name, last name, and full name Current Worker, Terminated Employee, Employee Trend
Employee Title Title and seniority date Current Employee, Terminated Employee, Employee Trend
Employee Trend Workers over time, headcount, company, and position Company, Geographic Location, Employee Name, Reports To, Calendar Offset, Date, Employee Title, Demographics, Employment, Job
Mass Hire Project Number of mass hire projects, project owner, and project status Company, Mass Hire Line
Mass Hire Line Department, employment type, and position Date, Job, Mass Hire Project