DT. DIEGO TORRES
FRCV ↓
← TC Concept experience
CASE STUDY · DATA SCIENCE
FIRST QUARTER 2025 EVALUATION

Pricing
and prediction.

Estimate whether a quote will convert

This project explored historical quote data to estimate conversion. The report documents data preparation, feature engineering, modelling iterations and analysis of results.

PythonPandasscikit-learnLightGBMMachine Learning
01 — BUSINESS QUESTION

Turn history into
a useful signal.

The project explored prediction at quote-line and quote level, combining historical variables with business information. The goal was to support analysis and prioritisation by business teams.

REPORT DATA

Scores vary
by category.

Each plotted point represents an anonymised category from the report table. The chart plots F1 against AUC; hover a point for detail.

MEDIAN F1precision / recall balance
MEDIAN AUCranking quality
CATEGORIESrows in source table
F1 / AUC · Q1 2025 TEST

Scores by anonymised category

F1AUC
AUC
Each point links the F1 and AUC scores for one category.0.5 reference line

Source: “Section / n / Acc / F1 / AUC” table in the Pricing report. F1 and AUC values are reproduced; category names and volumes are omitted. Medians are calculated from the table rows.

MARGIN ANALYSIS

Explore the pricing logic.

The report combines customer margin and conversion, business rules and pricing-action scenarios.

METHOD

Prepare, compare
and communicate.

The workflow examined historical splits, quote-level aggregates such as mean and median net amount, model metrics and category-level performance. Visuals made the relationship between pricing choices and business outcomes easier to discuss.

Quote history→Features→Models→Business analysis