Training Dashboard
Training Dashboard Overview
This Training Dashboard, built for a non-profit organisation,, has anonymised data and was built using Power BI. It offers a comprehensive view of our organisation's training programmes. It is designed to track the effectiveness of our training initiatives and provide actionable insights for continuous improvement.
The dataset contains 3 tables in Excel:
Attendance contains: Course Category, Session Type, Course Start Date, Course End Date, Financial Quarter, No. of Sessions and No. of Attendees
Eventbrite Data contains: Event Name, Date Attending, Financial Quarter, Country of Residence, Profession
Feedback Data contains: Question, Quarter, Rating, No. of answers
Key Objectives
The dashboard serves several critical functions:
Session Tracking: Monitor the number of different training sessions conducted throughout the year.
Attendee Monitoring: Track the number of attendees for each session, ensuring we reach our target audience effectively.
Satisfaction Measurement: Assess course attendee satisfaction through post-training surveys, enabling us to gauge the effectiveness of our training programmes.
Trend Analysis: Measure the increase or decrease in course numbers over the years, helping us identify trends and adjust our training strategies accordingly.
Features and Functionality
This dashboard is equipped with powerful features that enhance data analysis and presentation:
Interactive Visualisations: Dynamic charts and graphs that provide a clear visual representation of key metrics.
Slicers and Filters: Users can easily filter data by year, department, or course type, allowing for customised views and deeper analysis.
User-Friendly Interface: The dashboard's layout is intuitive, making it accessible for users at all levels of technical proficiency.
Target Audience
This dashboard is a vital tool for our entire organisation. It is presented annually to the entire company, with a detailed analysis shared with the Board of Directors. The insights derived from the dashboard inform decision-making at the highest levels and help shape our training strategies.
Technical Implementation
The dashboard was developed using a suite of Microsoft tools:
Power BI: The primary platform used for data visualisation and dashboard creation.
Excel: Served as the initial data source, providing the raw data for analysis.
Power Query: Used to clean, transform, and load data into Power BI.
DAX (Data Analysis Expressions): Utilized within Power BI to perform complex calculations and create custom measures, enabling deeper data insights.
Insights and Impact
The insights gained from this dashboard have had a significant impact on our training programs:
Improved Course Design: By analysing attendee satisfaction and participation trends, we've been able to refine course content and delivery methods.
Enhanced Resource Allocation: The ability to track session attendance and satisfaction allows us to allocate resources more effectively, focusing on the most impactful training programs.
Strategic Decision-Making: The historical trend analysis enables us to forecast training needs and adjust our strategies to better meet organisational goals.