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 |