Pilot Program Report and Data Visualisation

Creating the Report and Visualising the Results

With the pilot data and insights now clear, Marcus needs to consolidate everything into a report for Grace, decide the best way to save time while creating it, complete the next practical steps, and then prepare strong visuals for the executive team.

Time-saving method

Which method would help Marcus save time in creating the report?

Choose the best answer.

Consolidate the information manually, typing up the report by hand.

This is not the best option because it is slower and does not make good use of the existing AI analysis.

Begin a new GPT conversation, submit all the information and insights, and ask it to create the report.

This is not the strongest option because it breaks the existing context and does not fully use prompt chaining.

Build onto the conversation that analyzed the data in the GPT model and ask it to create a report with the analyzed information.

Correct. This uses prompt chaining, keeps the context, and saves time by building on the analysis that has already been done.

Prompt chaining

Prompt to consolidate the report

Marcus can chain the next prompt onto the existing GPT conversation so the report is created from the analyzed tables and insights already available.

You now need to report on this information. Create a report that consolidates all the tables for each goal and the key insights associated with them. Ensure that the report takes no more than 10 minutes to read and is easy to understand. The output should introduce the goal, showcase the tables and where the data was sourced, and summarize the key insights. At the end of the report, ensure there is a conclusion that suggests whether full-scale implementation would be wise based on the data.

Report summary

Consolidated report content

Below is a compact version of the pilot report Marcus can give to Grace, combining the two goals, the analyzed data, and the recommendation.

Role	Pre-AI Screening Time (hrs)	Post-AI Screening Time (hrs)	Time Reduction (%)
Software Engineer	14.5	2.1	85.52%
Data Scientist	10.5	1.5	85.71%
Product Manager	11.7	1.7	85.47%
Marketing Specialist	12.8	1.8	85.94%
HR Generalist	11.2	1.6	85.71%
Sales Associate	14.0	2.0	85.71%
Averages	12.45	1.78	85.68%

Goal 1 insight: Screening time fell by 85.68% on average, far exceeding the 70% target.

Activity	Pre-AI Time (hrs/week)	Post-AI Time (hrs/week)	Time Shift (hrs)	Time Shift (%)
Resume Screening	87	12.6	-74.4	-85.52%
Candidate Engagement	15	40	+25.0	+166.67%
Interviewing Candidates	10	25	+15.0	+150.00%
Workforce Planning	5	10	+5.0	+100.00%
Total	117	87.6	-29.4	-25.13%

Goal 2 insight: Recruiters spent much less time screening and much more time on strategic tasks, while total workload also decreased.

Recommendation

Based on the pilot data, full-scale implementation is recommended. Screening time improved well beyond target, recruiter productivity increased, and workload shifted toward higher-value recruitment activities.

Next steps

Drag and drop: What should Marcus do next?

Put the next three steps in the best order.

Cards to sort

Drag each step into the correct order.

Submit the report to Grace

Input the information into the report format

Read the report to ensure the information is correct and accurate

Place in order

Drop one card into each step.

First

Second

Third

Correct order

Read the report to ensure the information is correct and accurate
Input the information into the report format
Submit the report to Grace

Data visualisation

Marcus prepares the visuals

“Great job on the report! Please could you visualize this data so I can present it in the next update with our executive team”

Maya, CHRO

Marcus continues prompt chaining and asks the GPT to create graphs that clearly show the change in screening time and the shift in recruiter activity.

Prompt selection

Which prompt would get the best output?

Choose the best answer.

You now need to visualize the data. Create two graphs showcasing the information. Create one graph showcasing the pre-AI screening time and post-AI screening time differences and a graph showing the pre-AI time and post-AI time recruiter activity. Use the colors #1ebbf0 for pre-AI visuals, #f45c0f for post-AI visuals, and #31216b for surrounding text in the graphs. Ensure that the graph types chosen are best suited to showcase each table’s particular information.

Correct. This prompt is specific, includes the colours, names the two graphs, and asks for the most suitable chart types.

Create two graphs that showcase the information from the two tables above. Ensure the tables are easy to read and highlight key aspects from the pre- and post-AI screening processes. Ensure that the graph types chosen are best suited to showcase each table’s particular information.

This is weaker because it is vague, refers to tables instead of graphs, and does not provide the visual design guidance or colours.

Charts

Data visualisations for Maya’s presentation

Bar chart 1. Screening Time Reduction — This bar chart compares the pre-AI and post-AI screening times for each role, showing a significant reduction.

Bar chart 2. Recruiter Activity Time Shift — This horizontal bar chart highlights the shift in recruiter workload, with reduced résumé screening time and increased time for strategic tasks like candidate engagement and interviewing.

Outcome