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