Compensation and Benefits Power BI content

This article describes the Compensation and Benefits Power BI content.

Reports that are included in the content pack

After you've connected the content pack to your data, the reports show your organization's data. If you've never used Microsoft Power BI before, you can learn more about it on the Guided Learning page for Power BI. The reports that are included in the content pack have both charts and tables that contain additional information. The following table describes the reports.

Report	Contents
Comp and Benefits Analysis	Hourly and salaried employees by company, average hourly pay, average salaried pay, employees by employment type, and plan enrollment
Employee Benefits	Employee enrollment by selected benefit

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.

Understanding the data model and entities

The application data is used to populate the reports in the Compensation and Benefits content pack. The following table shows the entities that the content pack was based on.

Entity	Contents	Relationships with other entities
Workforce_CalendarOffset	Calendar offsets to slice reports	Workforce_PastPositionAssignment, Workforce_PositionTrend, Workforce_WorkerTrend, Workforce_TerminatedWorker
Workforce_Company	Companies to filter reports by	Workforce_CurrentCompensation, Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Compensation	Pay rate and frequency over time	Workforce_CurrentCompensation, Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_CurrentCompensation	Pay rate and frequency as of the current date	Workforce_Company, Workforce_Compensation, Workforce_Demographics, Workforce_Job, Workforce_Position
Workforce_CurrentPosition	Positions as of the current date, full-time equivalent (FTE), open positions, and open-to-filled positions	Workforce_Job, Workforce_Position
Workforce_CurrentWorker	Workers as of the current date, age, and headcount	Workforce_Company, Workforce_Compensation, Workforce_GeographicLocation, Workforce_Performance, Workforce_WorkerName, Workforce_ReportsToWorkerName, Workforce_WorkerTitle, Workforce_Demographics, Workforce_Job, Workforce_Employment, Workforce_Position, Workforce_WorkerBenefit
Workforce_Date	Days, weeks, months, and years	Workforce_PastPositionAssignment, Workforce_PositionTrend, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Demographics	Date of birth, gender, ethnic origin, and marital status	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Employment	Start date, end date, and transition date	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_GeographicLocation	City, county, postal code, and state or province	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Job	Function, type, and title	Workforce_CurrentPosition, Workforce_CurrentWorker
Workforce_PastPositionAssignment	Assignment reason, start date, end date, and job	Workforce_CalendarOffset, Workforce_Date, Workforce_Job, Workforce_Position
Workforce_Performance	Rating, description, and rating model	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Position	Department, FTE, position, position type, and title	Workforce_CurrentPosition, Workforce_CurrentWorker
Workforce_PositionTrend	Positions over time, FTE, and job	Workforce_CalendarOffset, Workforce_Date, Workforce_Job, Workforce_Position
Workforce_ReportsToWorkerName	First name, last name, and full name	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_Skill	Skill, skill type, and rating
Workforce_TerminatedWorker	Terminated workers, termination date, title, position, and job	Workforce_Company, Workforce_Compensation, Workforce_GeographicLocation, Workforce_Performance, Workforce_WorkerName, Workforce_ReportsToWorkerName, Workforce_CalendarOffset, Workforces_Date, Workforce_WorkerTitle, Workforce_Demographics, Workforce_Employment, Workforce_Job, Workforce_Position, Workforce_WorkerBenefit
Workforce_WorkerBenefit	Effective date, benefit option, benefit plan, and benefit type	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_WorkerName	First name, last name, and full name	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_WorkerTitle	Title and seniority date	Workforce_CurrentWorker, Workforce_TerminatedWorker, Workforce_WorkerTrend
Workforce_WorkerTrend	Workers over time, headcount, company, and position	Workforce_Company, Workforce_Compensation, Workforce_GeographicLocation, Workforce_Performance, Workforce_WorkerName, Workforce_ReportsToWorkerName, Workforce_CalendarOffset, Workforces_Date, Workforce_WorkerTitle, Workforce_Demographics, Workforce_Employment, Workforce_Job, Workforce_WorkerBenefit