top of page

Excel Data Dashboard

This data dashboard built in Excel uses pivot tables to transform raw participant survey results into clear charts, tables, slicers, and comment summaries. The dashboard helps evaluate the effectiveness of multiple courses and present findings in a visually engaging format that supports productive discussions with SMEs and stakeholders. Slicers make it easy to filter results by individual course or view combined data across several trainings. This structure highlights trends, strengths, and areas for improvement, while also making achievements easy to showcase. 
View averages along the top such as facts about time, complexity, satisfactory rating, or objectives meet. 
Graphs displaying objective data, duration stats, and ratings per course offer comparable information that can be visually analyzed to identify disparities and areas of improvements. 
Slicers on the right also filter text fields, such as comment summaries, by course. Instead of reading hundreds or even thousands of individual comments, a consolidated summary is generated by selecting a course from the slicer. 
bottom of page