Workforce metrics Power BI content

This topic 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 for Finance and Operations, Enterprise edition July 2017 update
  • Microsoft Dynamics 365 for Talent

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.

Extending the Power BI content

By using the content packs that are available in Microsoft Dynamics Lifecycle Services (LCS), you can provide great analytics to people who don't sign in to Finance and Operations. You can modify these content packs so that they include other reports or visuals, and then publish the content packs to your Power BI.com tenant for analysis.

You can find the Workforce metrics Power BI content in the Shared assets library in LCS. For more information about how to download the content and implement it in your organization, see Power BI content in LCS from Microsoft and your partners. To watch a demo that shows how to implement the Power BI content, see the Power BI content from Microsoft and your partners in Dynamics Lifecycle Services Office Mix.

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 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

These entities were used to create calculated measures in the data model. These calculated measures are then used to calculate the key performance indicators (KPIs) and reports that are used in the Power BI content. If you want to include additional calculations on your reports and dashboard, you can download and modify the .pbix file from LCS. This file is the default data model that was used to create the Power BI content. After you've made modifications, you can create an organizational content pack and dashboard that contain the information that you’ve added.