Explain how you would design a model to test the effectiveness of a new sales incentive plan.
Use the tables below to compare sales performance before and after the plan starts. Return one row per rep with pre-plan and post-plan sales, plus the change in performance.
rep_id, rep_name, pre_plan_sales, post_plan_sales, sales_lift, lift_pctlift_pct descending, then sales_lift descending, then rep_id ascending| Column | Type | Description |
|---|---|---|
| rep_idPK | INT | Unique sales representative identifier |
| rep_name | VARCHAR(255) | Sales representative name |
| region | VARCHAR(100) | Primary region for the rep |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| rep_id | INT | Sales representative identifier |
| sale_date | DATE | Date the sale was booked |
| sale_amount | NUMERIC(12,2) | Booked sale amount |