Recruiting Power BI content

This topic describes the Recruiting 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

If you're using Microsoft Dynamics 365 for Finance and Operations, Enterprise edition (July 2017), the Recruiting Power BI content is shown in the Recruitment management workspace.

Reports and visuals in the Recruitment management workspace

The Recruitment management workspace contains an Analytics tab. This tab contains the embedded Power BI content for recruiting. The content consists of an overview tab and additional tabs that contain details. The following table describes the reports on each tab.

Report Contents
Recruitment Overview Summarizes other reports
Applicant Analysis Total number of applicants, applicants by job, applicant sources, female to male applicants, and applicants by location
Applicant Status Applicants by type and status, and applicant status
Recruiting Analysis Net hire ratio, average days to hire, percentage of bad hires, recruiting costs, number of recruitment projects, hire to applied, and applicants versus openings by recruitment project

Understanding the data model and entities

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.

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

Entity Contents Relationships with other entities
Applicant Applicants, hired applicants, net hire ratio, and costs Applicant Name, Company, Calendar Offset, Date, Geographic Location, Demographics, Job, Media, Recruitment Project
Applicant Name Applicant first name, last name, and full name Applicant, Employed Applicant, Terminated Applicant
Calendar Offset Calendar offsets to slice reports Applicant, Employed Applicant, Terminated Applicant
Company Companies to filter reports by Applicant, Employed Applicant, Terminated Applicant
Date Days, weeks, months, and years Applicant, Employed Applicant, Terminated Applicant
Demographics Date of birth, gender, ethnic origin, and marital status Applicant, Employed Applicant, Terminated Applicant
Employed Applicant Applicant, performance, start date, and applicant type Company, Calendar Offset, Date, Geographic Location, Applicant Name, Employment, Performance, Job, Media, Recruitment Project
Employment Start date, end date, and transition date Applicant, Employed Applicant, Terminated Applicant
Geographic Location City, county, postal code, and state or province Applicant, Employed Applicant, Terminated Applicant
Job Function, type, and title Applicant, Employed Applicant, Terminated Applicant
Media Source of applicants Applicant, Employed Applicant, Terminated Applicant
Performance Rating, description, and rating model Applicant, Employed Applicant, Terminated Applicant
Recruitment Project Project description, project status, and openings Applicant, Employed Applicant, Terminated Applicant
Terminated Applicant Terminated applicants, reason, performance, and termination date Company, Calendar Offset, Date, Geographic Location, Performance, Demographics, Employment, Media, Recruitment Project, Applicant Name

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