Problem: Training status report showing certification status of employees for different Training courses was difficult to interpret because of one employee record appearing multiple times, one each for each of their Training courses despite pivoting the report on course name.
Enhancement: This issue has been addressed by grouping the same training status of an employee for different courses in one row and different training status in a separate row. This improvement has reduced the number of duplicate records for each employee and hence made the report visually more logical and easy to read.
Screenshot of the enhanced report:
Steps to build this report:
- Select measure Certification Date.Colored present under Training Explore with Null reporting.
- Add filters: Course Name, Course Status and Employee Name and pivot on Course Name