WEBVTT - Demo C: Analyst calculates completion rates, flags June and August, and charts them (step-by-step narration; the recording has no audio)

1
00:00:00.000 --> 00:00:07.000
Step 1: Demo C, Lab 11: Analyst. This recording has no audio. From the previous chat, select Analyst under Pinned in the left pane.

2
00:00:07.000 --> 00:00:12.000
Step 2: The Analyst page opens. The starter cards are optional.

3
00:00:12.000 --> 00:00:19.000
Step 3: Select +, then Upload images and files, and choose 06_Service_Request_Data.xlsx (fictional).

4
00:00:19.000 --> 00:00:23.000
Step 4: The file is attached. Consumer Copilot shows an upload notice here; your work Copilot may look different.

5
00:00:23.000 --> 00:00:28.000
Step 5: The prompt: calculate the monthly completion rate, flag any month over 100% or with missing data, and make a simple chart.

6
00:00:28.000 --> 00:00:41.000
Step 6: Analyst plans the work, then writes and runs code ('Coding and executing').

7
00:00:41.000 --> 00:00:55.000
Step 7: It checks the data first: every month needs complete fields, and any month over 100% or missing data gets flagged.

8
00:00:55.000 --> 00:01:02.000
Step 8: Results: Completion Rate = Requests Completed divided by Requests Received, times 100, for each month.

9
00:01:02.000 --> 00:01:08.000
Step 9: Flags: June 2026 is 116.67% (455 completed, 390 received), so it is over 100%. August is flagged for missing data, even though its rate can be calculated.

10
00:01:08.000 --> 00:01:16.000
Step 10: The chart shows June in red and August in yellow. Analyst also offers an Excel workbook of its analysis.

11
00:01:16.000 --> 00:01:22.000
Step 11: Your turn: check June by hand (455 / 390 x 100 = 116.7%), then open the reasoning steps to see the code.