Need help with a graph or chart to show percentage of completion

I have created a consolidated worksheet that is showing the dates that each person completed a required class. Each person has a ID#, job title, manager's name, Division in which they work, and the completion date for each of the required classes. If they have not yet completed the task, the cell shows 'Not Found' as intended by the formula in the date cells. 

History: I have separate worksheets for each class (Class A, Class B, etc..) which shows the roster of individuals who attended the class and the date in which they attended. On those separate worksheets, the data is in a table that has been named and the completion date is located in the 9th column. I mention the name of the table and the info in the 9th column for context when viewing my formula below. On the consolidated worksheet, I am using the formula below to show hundreds of people in 1 table and when they completed each class or if they still need to complete the class. 

Formula used in Class A column: 

=IFERROR(IF(VLOOKUP([@USER],ClassATbl,9,FALSE)=0,"Incomplete",VLOOKUP([@USER],ClassATbl,9,FALSE)),"Not Found")

Note: The formula is copied into the other columns and the table_array is changed to the appropriate table name. 

HELP! I would like to create a dashboard that is able to show the completion percentage for each department and also for each manager so I can better track the progress to ensure that everyone completes the required classes by the deadline. Being able to filter on the department or Manager and see the results will make this much easier for stakeholders to view the progress.