Organizational training Power BI content
This article describes the finance and operations - Organizational training 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 |
|---|---|
| Course Analysis | Registration by location, course attendees by status, and registration list |
| Course Types | Course types by skill |
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 Organizational training content pack. The following table shows the entities that the content pack was based on.
| Entity | Contents | Relationships with other entities |
|---|---|---|
| Training_CalendarOffset | Calendar offsets to slice reports | Training_CourseAgenda, Training_CourseAttendees |
| Training_Company | Companies to filter reports by | Training_CourseAgenda, Training_CourseAttendees |
| Training_Course | Course, description, instructor name, location, room, and status | Training_CourseAgenda, Training_CourseAttendees, Training_CourseSkill |
| Training_CourseAgenda | Agenda, course, and start and end times | Training_Company, Training_CalendarOffset, Training_Date, Training_Course |
| Training_CourseAttendees | Name, status, job, and registration date | Training_Company, Training_CalendarOffset, Training_Date, Training_Demographics, Training_Employment, Training_Course, Training_WorkerName, Training_WorkerTitle, Training_Job, Training_Position |
| Training_CourseSkill | Skill, skill type, and level | Training_Course |
| Training_Date | Days, weeks, months, and years | Training_CourseAgenda, Training_CourseAttendees |
| Training_Demographics | Date of birth, gender, ethnic origin, and marital status | Training_CourseAgenda, Training_CourseAttendees |
| Training_Employment | Start date, end date, and transition date | Training_CourseAgenda, Training_CourseAttendees |
| Training_Job | Function, type, and title | Training_CourseAgenda, Training_CourseAttendees |
| Training_Position | Position, title, and full-time equivalent (FTE) | Training_CourseAgenda, Training_CourseAttendees |
| Training_WorkerName | First name, last name, and full name | Training_CourseAttendees |
| Training_WorkerTitle | Title and seniority date | Training_CourseAttendees |