TwinFyRxTwinFyRx Labs
From raw claims to
drug economics
Walk through seven transformations that turn unstructured pharmacy claims into actionable economic intelligence. Every step is transparent, every calculation reproducible.
Step 1 of 7
Raw Claims
Unstructured pharmacy data
This is what most pharmacy analytics teams start with: raw claims data with NDC codes, quantities, and days supply. The problem? NDCs alone tell you almost nothing about the drug, its therapy class, or its true cost.
| member_id | ndc | drug_name | qty | days_supply |
|---|---|---|---|---|
| M-10042 | 00071015523 | Atorvastatin 20mg Tab | 90 | 90 |
| M-10042 | 00378395505 | Atorvastatin 20mg Tab | 30 | 30 |
| M-20187 | 00310075190 | Rosuvastatin 10mg Tab | 30 | 30 |
| M-20187 | 65862035490 | Rosuvastatin 10mg Tab | 90 | 90 |
| M-30291 | 00228277311 | Metformin 1000mg Tab | 60 | 30 |
| M-40553 | 00597015605 | Empagliflozin 25mg Tab | 30 | 30 |
| M-50814 | 00597010930 | Tamsulosin 0.4mg Cap | 30 | 30 |
| M-10042 | 16714068201 | Atorvastatin 20mg Tab | 500 | 90 |
→
Look at the atorvastatin rows. Three different NDCs, three different package sizes (30, 90, 500) \u2014 but they're all the same therapy. Without normalization, each looks like a different drug.