| Organisation Name | |
| Training Program Name | |
| Training Provider | |
| Course Start Date | // |
| Organisation Name | |
| Training Program Name | |
| Training Provider | |
| Course Start Date | // |
| Organisation Name | Course Date | // | |
| Training Program Name | Training Provider |
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY s.student_id
) as emps' at line 20]
SELECT
SUM(if(bef < aft,1,0)) as positive_ct,
SUM(if(bef > aft,1,0)) as negative_ct,
SUM(if(bef = aft,1,0)) as no_change_ct
FROM (
SELECT
s.student_id,
sum(if(q.answer_after>q.answer_before,1,0)) as positive_ct,
sum(if(q.answer_after<q.answer_before,1,0)) as negative_ct,
sum(if(q.answer_after=q.answer_before,1,0)) as no_change_ct,
avg(q.answer_before) bef,
avg(q.answer_after) aft
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.student_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type IN ('M')
AND u.user != u.parent_user
AND s.training_id =
GROUP BY s.student_id
) as emps
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 11]SELECT
SUM(result_cost_savings) AS result_cost_savings,
SUM(result_time_savings) AS result_time_savings,
SUM(result_reduced_errors) AS result_reduced_errors
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_initiatives i ON i.survey_id = s.id
WHERE 1=1
AND u.user != u.parent_user
AND s.training_id =
| Incremental Business Improvement Results Forecast over 12 months | ||
|---|---|---|
Profit | NA | Cost savings & Revenue gains |
Productivity | NA | Hours saved |
Quality | NA | Error handling reductions |
| Forecasts based on new initiatives and process improvements completed by participants during training | ||
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 9]SELECT
round(avg(q.answer_before),1) as pd_average
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type IN ('PD')
AND u.user != u.parent_user
AND s.training_id =
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY rq.question_heading' at line 11]SELECT rq.question_heading,
round(avg(q.answer_before),1) as e_average
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
LEFT JOIN ey3_questions rq ON rq.question_id = q.ref_question_id
WHERE q.question_type IN ('E')
AND u.user != u.parent_user
AND s.training_id =
GROUP BY rq.question_heading
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY rq.question_heading' at line 13]
SELECT
REPLACE(rq.question_heading,'''','') as question_heading,
ROUND(avg(q.answer_before),1) as before_ct,
IFNULL(ROUND(avg(q.answer_after),1),0) as after_ct
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.student_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN ey3_questions rq ON rq.question_id = q.ref_question_id
WHERE q.question_type IN ('M')
AND u.user != u.parent_user
AND s.training_id =
GROUP BY rq.question_heading
The managers of the course participants completed a behaviour analysis survey before and after the program. Managers observed the participants behaviour in demonstrating the key training topic areas.
This graph shows the group average behaviour change results for each key training topic area.
The managers of the course participants completed a behaviour analysis survey before and after the program. Managers observed the participants behaviour in demonstrating the key training topic areas.
This graph shows the individual behaviour change results for each key training topic area.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY REPLACE(w.display_name,'''','')' at line 13]
SELECT
REPLACE(w.display_name,'''','') as employee_name,
ROUND(avg(q.answer_before),1) as before_ct,
IFNULL(ROUND(avg(q.answer_after),1),0) as after_ct
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.student_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN wp_users w ON w.id = u.user
WHERE q.question_type = 'M'
AND u.user != u.parent_user
AND s.training_id =
GROUP BY REPLACE(w.display_name,'''','')
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY REPLACE(rq.question_heading,'''','')' at line 12]
SELECT
REPLACE(rq.question_heading,'''','') as question_heading,
ROUND(avg(q.answer_before),1) as pd_average
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN ey3_questions rq ON rq.question_id = q.ref_question_id
WHERE q.question_type = 'PD'
AND u.user != u.parent_user
AND s.training_id =
GROUP BY REPLACE(rq.question_heading,'''','')
Participants rated their confidence in applying their professional development training to their work area.
This graph shows the group average professional development application results for each key training topic area.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY REPLACE(w.display_name,'''','')' at line 12]
SELECT
REPLACE(w.display_name,'''','') as employee_name,
ROUND(avg(q.answer_before),1) as before_ct
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN wp_users w ON w.id = u.user
WHERE q.question_type = 'PD'
AND u.user != u.parent_user
AND s.training_id =
GROUP BY REPLACE(w.display_name,'''','')
Participants rated their confidence in applying their professional development training to their work area.
This graph shows the individual average professional development application results.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND u.user != u.parent_user
GROUP BY REPLACE(rq.question,'''','')' at line 11]
SELECT
REPLACE(rq.question,'''','') as question,
ROUND(avg(q.answer_before),1) as e_average
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN ey3_questions rq ON rq.question_id = q.ref_question_id
WHERE q.question_type = 'E'
AND s.training_id =
AND u.user != u.parent_user
GROUP BY REPLACE(rq.question,'''','')
Participants identified their level of engagement based on developing and being empowered to apply their new skills in the workplace.
This graph shows the group average results for each engagement area.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY REPLACE(w.display_name,'''','')' at line 12]
SELECT
REPLACE(w.display_name,'''','') as employee_name,
ROUND(avg(q.answer_before),1) as before_ct
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN wp_users w ON w.id = u.user
WHERE q.question_type = 'E'
AND u.user != u.parent_user
AND s.training_id =
GROUP BY REPLACE(w.display_name,'''','')
Participants identified their level of engagement based on developing and being empowered to apply their new skills in the workplace.
This graph shows the individual average engagement results.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 10]
SELECT
DISTINCT w.id, REPLACE(w.display_name,'''','') as employee_name
FROM ey3_stru u
JOIN ey3_surveys s ON u.user = s.user_id
JOIN ey3_survey_questions q ON q.survey_id = s.id
JOIN wp_users w ON w.id = u.user
WHERE 1=1
AND u.user != u.parent_user
AND s.training_id =