← All courses

Your finished work

An SLA review CSV with evidence IDs and ordered follow-up actions

Completion requires every output check to pass. Exact columns, types, values, missing values and duplicate counts all matter. A diagnostic score helps you revise your work.

All examples use original, fictional business data. Your final project starts with 93 source records.

The course

1. 1. Freeze the cohort and review clock

   Use a reproducible opening window and as-of time.

   Start lesson →

2. 2. Apply deadline boundaries

   Distinguish invalid timing, breached deadlines and awaiting replies.

   Start lesson →

3. 3. Attach a trustworthy evidence receipt

   Prove each observed reply with a matching public receipt.

   Start lesson →

4. 4. Prioritize the handoff

   Turn timestamp and evidence checks into explicit next actions.

   Start lesson →

Put it together

Handoff a checked SLA and evidence queue

93 source records. Apply the business rules, check your output and download a handoff report with your source, answer and results.

Start the project →Try a fresh dataset →

Preview your first input

CREATE TABLE tickets (ticket_id INTEGER, team TEXT, priority TEXT, opened_min INTEGER, first_reply_min INTEGER, owner TEXT);
INSERT INTO tickets VALUES
(6000,'Billing','P1',1440,NULL,NULL),
(6001,'Technical','P2',0,120,'Agent 2'),
(6002,'Delivery','P3',1420,1805,'Agent 3'),
(6003,'Billing','P3',1439,NULL,'Agent 4'),
(6004,'Technical','P2',92,91,'Agent 5'),
(6005,'Delivery','P3',115,115,'Agent 6'),
(6006,'Billing','P1',138,168,'Agent 1'),
(6007,'Technical','P2',161,282,NULL),
(6008,'Delivery','P3',184,NULL,'Agent 3');
CREATE TABLE evidence (evidence_id TEXT, ticket_id INTEGER, recorded_min INTEGER, kind TEXT);
INSERT INTO evidence VALUES
('EV-6000',6001,120,'internal_note'),
('EV-6001',6002,1805,'public_reply'),
('EV-6002',6005,115,'public_reply'),
('EV-6003',6006,168,'public_reply'),
('EV-6004',6007,282,'public_reply'),
('EV-6001',6002,1805,'public_reply'),
('ORPH-6000',6999,10,'public_reply'),
('BAD-6000',6004,92,'public_reply');
CREATE TABLE policies (priority TEXT, limit_minutes INTEGER);
INSERT INTO policies VALUES
('P1',30),
('P2',120),
('P3',480);