Describe your process for validating the results of an analytical project before presenting them to leadership at Biogen.
For the hands-on SQL portion, use the supplied source measurements and project results to identify agreement, discrepancies, missing records, and null values.
period_start, region, metric_name, reported_value, source_value, absolute_difference, and validation_statusperiod_start, region, and metric_name| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique source measurement identifier |
| event_date | DATE | Date of the source measurement |
| region | VARCHAR(50) | Reporting region |
| metric_name | VARCHAR(100) | Name of the measured metric |
| metric_value | DECIMAL(12,2) | Measurement value |
| validation_flag | VARCHAR(20) | Source record validity indicator |
| Column | Type | Description |
|---|---|---|
| project_result_idPK | INT | Unique analytical result identifier |
| period_start | DATE | First day of the reporting month |
| region | VARCHAR(50) | Reporting region |
| metric_name | VARCHAR(100) | Name of the analytical metric |
| reported_value | DECIMAL(12,2) | Value reported by the analytical project |