The Power BI - Comparison report

Overview and purpose

Overview

The Course Comparison Report is a comprehensive analytical tool designed to provide an overarching view of various training metrics across an organization. This report utilizes a series of dynamic visualizations and data tables to present detailed information on course registrations, progress, completions, and participant engagement in training programs. Each section of the report is tailored to focus on specific aspects of training data—ranging from course registration and in-progress courses to completions and courses not yet started. This multifaceted approach allows stakeholders to gauge the effectiveness of different training sessions, understand participation trends, and identify areas for improvement in the training process.

 

Purpose

The purpose of the Training Comparison Report is to establish a comprehensive baseline for analyzing and comparing various training metrics within an organization. It is designed to encourage users to customize and expand upon the initial data insights, promoting a deeper engagement with the analytics provided. By empowering users to adapt and enhance the report according to their specific needs, this tool aims to foster a culture of continuous improvement and skill development, enabling stakeholders to assess training effectiveness, monitor trends, and pinpoint opportunities for optimization in the training process more effectively.

 

Report structure

Overview

The report consists of several visualizations (charts and graphs), which you can interact with to explore specific data sets. Key components include filters and slicers on the left side of the report, allowing you to customize the data display.

 

Filters and slicers

Filters and slicers allow you to view only the data you're interested in. They are consistent across most pages, so you can apply the same filters as you navigate through different sections of the report.

 

How to apply filters

  • Single-Select Filters: Indicated by circular radio buttons, allowing you to select one option.
  • Multi-Select Filters: Indicated by square buttons. Hold Ctrl (or Cmd on Mac) to select multiple options.
  • Mandatory and Optional Filters: Mandatory filters are labeled with "Select" and must be set to display data. Optional filters are labeled with "Filter."

 

Common filters across all pages

  • Filter Catalog(s): Choose catalogs to only see data related to selected catalogs.
  • Select a Training: Mandatory selection needed to display data; focuses the analysis on a specific training.
  • Status Filters (Required, Registration, Completion): Break down data by various statuses to update visualizations dynamically and highlight areas of interest.

 

NOTE   

The availability and content of data in the filters may vary by page depending on the data provided. For example, the completion status filter might show "Completed," "In Progress," and "Not Started" on one page, but only "Completed" and "In Progress" on another if no learners are in the "Not Started" category.

 

Instructions for use

This report includes various charts and graphs that help you understand the data through visual representations. You can interact with visuals in a couple of different ways.

  • Viewing Details. Simply move your mouse over any part of a chart or graph. A small box will appear, showing you more specific information, like numbers or percentages, related to the part you are hovering over.
  • Drilling Down. If you want to see more detailed data about a particular section of a chart, such as a slice of a pie chart or a bar in a bar graph, just click on it. This action will "drill down," which means it will open more detailed information about that section and change the data displayed on the entire page based on your selection.

 

Comparison Report splash page

 

 

Overview

The Splash Page serves as the welcoming interface for the Zensai Comparison Report, providing users with an initial overview and essential tips for navigating and utilizing the report effectively. This page is crucial for setting the context and ensuring users understand the report’s capabilities and best practices before diving into detailed data analysis.

 

Navigating to report sections

Click on any of the buttons to navigate to the specific reports. Each button is clearly labeled according to the section it leads to, making it easy to move through the report seamlessly.

 

NOTE   

If you are using Power Bi Desktop clicking buttons requires you to hold Ctrl (or Cmd on Mac) and click the button.

 

General Overview. Provides a comprehensive snapshot of key training metrics across the organization, enabling quick assessments of various training programs' effectiveness.

Registration - Department. Focuses on the registration details by department, highlighting participation trends and registration statuses to assess departmental engagement.

Progress - Department. Analyzes course progress within departments, showcasing ongoing and completed training activities to identify efficiency and areas needing attention.

Time - Completed. Delivers insights into the duration from course registration to completion, helping understand the timelines involved and the efficiency of course completion.

Time - In Progress. Offers details on the time courses are actively being engaged with, helping to monitor ongoing training durations and spot delays or prolonged engagements.

Time - Not Started. Details courses that have been registered for but not yet begun, identifying delays in course initiation and opportunities for improving start rates.

Data Table. Provides granular data on training programs, including detailed metrics like enrollment numbers and time-related statistics for thorough analysis.

 

Training Comparison Overview page

 

 

Overview

The Training Comparison Overview page offers a detailed analysis of training metrics within the organization, focusing on the comparison of various training programs over selected time periods. This page is crucial for stakeholders to assess the performance of different training sessions, registration trends, and completion outcomes, enabling strategic decisions to enhance training effectiveness.

 

How it works

This report section pulls data from various training to display aggregated and comparative insights. The data is categorized by training, registration status, and course passing status. Filters allow users to customize the data display according to specific training, required status, completion status and registration status ensuring relevant information is always at the forefront.

 

Visualizations and insights

Visualizations

Registration Status by Training and Time. Presents a bar graph detailing the number of enrollments per training and their respective status over time, giving a clear picture of registration trends and their outcomes.

Number of Registrations by Training. A bar graph showing total registrations for each selected training, which helps in identifying the most and least popular courses.

Course Passing Status by Training and Time. Offers insights into how many participants have completed the courses, are still in progress, or haven’t started, enabling identification of courses that might need additional promotional activities or support.

 

Insights

The comparison of active, cancelled, and expired registrations can highlight issues in course uptake or scheduling. Analysis of course passing statuses helps in understanding the effectiveness of different training and identifying where additional resources may be needed. Monitoring registrations and completions over time assists in recognizing patterns or seasonal fluctuations in training engagement.

 

Registration Comparison Business page

 

 

Overview

The Registration Comparison Business page is designed to deliver a granular view of training registrations across different departments and overtime within the organization. It helps stakeholders understand registration trends, analyze departmental participation, and evaluate the impact of training programs on various business units.

 

How it works

This page consolidates registration data by department and over specific periods to offer a comparative analysis. Users can select different training, registration statuses (active, cancelled, expired), and completion statuses (completed, in progress, not started). This functionality allows for a dynamic assessment of training effectiveness and participant engagement across the organization.

 

Visualizations and insights

Visualizations

Registrations by Department. Displays a bar graph with the number of enrollments by department for selected training, highlighting departmental involvement and potential areas for increased participation.

Registration Status by Selected Training. A pie chart shows the proportion of active, cancelled, and expired registrations, providing a quick visual representation of engagement and retention rates.

Registration Status Over Time. A line graph that illustrates the trends in registration status over time, helping identify seasonal trends or effects of specific initiatives.

 

Insights

Comparing registration statuses across departments and over time can uncover successful practices and areas needing improvement.

The visualization of registration by selected training offers insights into which courses are most or least popular, guiding future training offerings.

Tracking registration trends over time aids in forecasting future training needs and evaluating the impact of past and current training strategies.

This section of the report enables comprehensive analysis and strategic planning by providing detailed insights into registration patterns across different business units and over selected time frames.

 

Progress Comparison Business page

 

 

Overview

The Progress Comparison Business page is structured to track and compare the progression of various courses within the organization across different departments. It focuses on providing insights into the status of course completions, ongoing courses, and those not yet started, aiding in the assessment of training effectiveness and participant engagement.

 

How it works

This page gathers and displays data based on the completion status of training courses, segmented by department. It includes filters for selecting specific training and adjusting the view based on course registration and completion statuses. This allows users to tailor the information to specific organizational needs and training strategies.

 

Visualizations and insights

Visualizations

Course Passing Status. A pie chart summarizing the overall course completion status—completed, in progress, and not started—providing a quick overview of course outcomes.

Course Progression Over Time. A dotted line graph displaying the number of enrollments, completions, and courses in progress over selected time periods, illustrating trends and identifying potential delays or accelerations in course completions.

Completed Courses by Department. A bar chart showing the number of enrollments in completed courses, segmented by department, highlighting departmental success in course completions.

In Progress and Not Started Courses by Department. Two additional bar charts display the number of courses currently in progress and those not started within each department, helping to identify departments that may need additional support or resources to initiate or complete courses.

 

Insights

Analysis of course completion rates and statuses across departments can pinpoint areas where intervention is needed or where best practices can be replicated.

Understanding the progression of courses over time helps in planning future training schedules and adjusting training strategies to improve outcomes.

Insights from department-specific data on course progress can foster competitive spirit and motivate departments to enhance their engagement and completion rates.

By examining these visualizations and using the data effectively, organizational leaders and training coordinators can optimize training programs and ensure that they meet the strategic goals of the organization.

 

Comparison Statistics page

 

 

Overview

The Completion Statistics page provides a detailed evaluation of course completion metrics across various training programs within the organization. It is designed to help stakeholders understand the efficiency of training completions and the time taken for participants to start and finish courses, enabling a thorough assessment of training effectiveness.

 

How it works

This report section utilizes filters for selecting specific training and viewing data based on completion, registration status, and whether training is required or optional. It aggregates data to showcase the number of completions, time intervals from start to completion, registration to start, and registration to completion, offering a comprehensive look at the pace and progress of training programs.

 

Visualizations and insights

Visualizations

Completions by Course. A bar chart representing the number of completions per course, indicating the courses' popularity or participants' success rates.

Start to Completion (Minutes/Days). Two graphs showing the time taken from the start of the course to its completion in minutes and days, highlighting the duration participants spend on different training.

Registration to Start (Days) and Registration to Completion (Days). Bar charts depicting the median time from registration to the start of the course, and from registration to completion, respectively, providing insights into the administrative and participant readiness efficiency.

 

Insights

The number of completions by course can highlight which courses are more engaging or effectively managed.

Analysis of time from start to completion can help identify courses that may be too lengthy or quick, suggesting potential adjustments in course design or delivery.

The median time from registration to start and completion offers an understanding of the operational effectiveness in managing course schedules and participant pacing.

This page serves as a vital tool for monitoring and improving the training process, ensuring that courses are not only completed but are also efficient in terms of participant time investment and administrative handling.

 

In Progress Statistics page

 

 

Overview

The In Progress Statistics page is specifically designed to monitor and analyze the status of courses that are currently active and have not yet been completed across the organization. It offers a detailed view of the duration courses have been in progress and the efficiency with which courses are initiated after registration.

 

How it works

This page aggregates data to track the ongoing courses within the organization, displaying how long they have been in progress and the time taken from registration to the start of these courses. It includes filters that allow stakeholders to select specific training, registration statuses, and whether the courses are required or optional, providing a customizable view for detailed analysis.

 

Visualizations and insights

Visualizations

In Progress by Course. A bar graph that shows the number of learners currently engaged in courses, highlighting the courses with the highest ongoing participation.

Number of Days in Progress. A line graph that tracks the duration for which courses have been in progress, showing trends over time and identifying any courses that may be unusually prolonged.

Registration to Start | Days. A histogram that illustrates the time taken from registration to the start of the course, providing insights into the administrative efficiency and readiness of participants.

 

Insights

Tracking the number of days courses are in progress helps in identifying potential bottlenecks or inefficiencies in course delivery.

The number of learners currently engaged in courses and the duration these courses have been in progress can signal courses that are effectively maintained and those that may require review or acceleration.

Analysis of the time from registration to course start offers insights into how swiftly the organization can mobilize resources and support learners in starting their training, indicating areas where process improvements are needed.

This page is essential for managing ongoing training and ensuring that courses are progressing towards timely completion, thereby enhancing the overall training management and efficiency within the organization.

 

Not Started Statistics page

 

 

Overview

The Not Started Statistics page provides insights into the courses that have been registered for but not yet begun within the organization. This page is crucial for identifying potential issues in training engagement and startup, and it offers a clear view of the delays in course initiation, allowing for better management and encouragement strategies.

 

How it works

This report section collects and displays data regarding courses that participants have registered for but have not started. It features filters to select specific training and view data based on registration status and whether the courses are required or optional. This focused approach helps stakeholders understand the reasons behind the lack of commencement and devise methods to improve course startup rates.

 

Visualizations and insights

Visualizations

Not Started by Course. A bar graph indicating the number of learners who have not started each course, highlighting which courses are facing the highest delays in commencement.

Number of Days Not Started. A line graph showing the duration that registered courses have remained not started, helping to identify how long courses are typically delayed.

Median Days Not Started. Bar charts that display the median number of days that courses have remained not started after registration, offering a measure of delay severity across different courses.

 

Insights

High numbers in not-started courses may indicate issues with course accessibility, scheduling conflicts, or lack of motivation or awareness among participants.

Understanding the median days not started helps in pinpointing courses that require intervention to reduce startup delays, enhancing overall training engagement.

Insights derived from these visualizations can guide improvements in communication, scheduling, and resource allocation to minimize the number of not-started courses.

This page serves as a valuable tool for managing course startups effectively, ensuring that registered courses transition smoothly into active learning phases, thereby improving the training efficiency and participant engagement across the organization.

 

Data Table page

 

 

Overview

The Data Table page is an essential tool for analyzing detailed training data across various courses offered by the organization. It provides a comprehensive view of registration statuses, completion stages, and the specific metrics related to time taken for course actions such as registration to start and start to completion. This page is pivotal for understanding granular details and dynamics within specific courses, helping stakeholders make informed decisions based on real-time data analysis.

 

How it works

This page functions by aggregating extensive data related to course enrollments, progression, and outcomes into accessible tables and graphs. It includes various filters such as training selection, required status, and registration status, which help in drilling down into specific data sets. This setup enables detailed tracking of course metrics and offers an analytical base for evaluating training effectiveness.

 

Visualizations and insights

Visualizations

Passing Status by Course. Displays a bar graph of the number of learners in different stages (Not Started, In Progress, Completed) for selected courses, which helps identify courses with high dropout rates or successful completions.

Registration Status by Course. Shows a bar graph detailing the number of active, cancelled, and expired registrations per course, highlighting courses with high engagement or issues in retention.

Data Tables (Time Calculated As Median). These tables provide a breakdown of median days for specific actions like registration to today, start to today, registration to start, and start to completion, offering detailed timing metrics for administrative and learner performance.

 

Insights

Detailed breakdowns of course status (Not Started, In Progress, Completed) help in identifying courses that may need more promotional efforts or additional resources to aid completion.

Insights from the registration status can direct administrative efforts to improve engagement strategies and retention rates.

Time metrics provided in the data tables allow for an understanding of the efficiency and responsiveness of course management processes, highlighting areas for potential improvement in speeding up course initiation and completion.

By leveraging the detailed data provided on the Data Table page, administrators can effectively monitor, analyze, and enhance course offerings and strategies, leading to improved educational outcomes and optimized training programs.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

Article is closed for comments.