Employee competencies and development Power BI content

This article describes the Employee competencies and development 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
Competency & Development Analysis	Team member skill types and team member skills by type
Skill Profile	Skill profile for the selected employee
Skill Analysis	Skills by type and rating

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

Application data is used to populate the reports in the Employee competencies and development 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_Company	Companies to filter reports by
Workforce_Compensation	Pay rate and frequency over time
Workforce_CurrentCompensation	Pay rate and frequency as of the current date	Workforce_Company, Workforce_CurrentCompensation, 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_PersonSkill, Workforce_WorkerName, Workforce_ReportsToWorkerName, Workforce_WorkerTitle, Workforce_Demographics, Workforce_Job, Workforce_Employment, Workforce_Position
Workforce_Date	Days, weeks, months, and years
Workforce_Demographics	Date of birth, gender, ethnic origin, and marital status
Workforce_Employment	Start date, end date, and transition date
Workforce_GeographicLocation	City, county, postal code, and state or province
Workforce_Job	Function, type, and title
Workforce_JobPreferredSkill	Importance, rating, skill, and skill level	Workforce_Skill, Workforce_Job
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_PersonSkill	Level, level date, and skill	Workforce_Skill
Workforce_PersonSkillAnalysis	Certified, level, level date, and skill	Workforce_WorkerName, Workforce_Skill
Workforce_Position	Department, FTE, position, position type, and title
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_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_WorkerName	First name, last name, and full name
Workforce_WorkerTitle	Title and seniority date
Workorce_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