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