Independent pharma data analytics
Prescription, claims, lab, and specialty pharmacy feeds in. Reports, triggers, forecasts, and answers out — built by senior pharma analysts, sized to the question, delivered in days.
NDA and third-party data-access agreements as standard · Your environment by default · No project minimums
W12 — refill-gap trigger fired. 312 enrolled patients past expected refill; list to the hub Monday for outreach.
W18 — NBRx inflection. New writers up 14% in the Northeast; field alerted the following Monday.
Who we're built for
Emerging & mid-size pharma
You bought the data before you built the analytics team. We're the team — senior from day one, sized to your stage, gone the day you don't need us.
Brand teams inside large pharma
Central analytics has a six-week queue and your question is due Tuesday. We work alongside your internal groups and hand everything back, documented.
Commercial ops, access & medical
Functions that run on recurring, right-sized analysis — call plans, payer views, KOL and cohort work — delivered on a rhythm you can plan around.
Why Whetstone
Pharma teams license more data than ever — prescriptions, claims, labs, specialty pharmacy — and it lands faster than any team can absorb. The questions pile up quicker than the answers do.
The usual ways to cope fall short. Your data provider's services team is built for programs measured in quarters. Large consultancies are built for six-month engagements. Your own analysts are already stretched across three workstreams. None of them helps with the Tuesday-afternoon question — the payer-mix cut due Thursday, the trend report that broke when a file layout changed, the trigger list the field asked for a quarter ago. So it sits in a backlog, or gets done in a hurry in a spreadsheet, or doesn't get done at all.
Whetstone is the option built for that: analysts who've done this work before, engagements sized to the question, turnaround measured in days. The data you already pay for finally earns its keep.
We don't sell data, resell licenses, or push a platform. The only thing on our price list is analytical work — so the only thing we optimize for is your answer. We work alongside your existing data providers and internal teams, and everything we build is yours to keep.
Prescription and medical claims, lab results, specialty pharmacy files — landing weekly and monthly, in whatever shape they land.
Ingest · clean · analyze · deliver. We standardize the feeds, keep them healthy, and turn them into reports, triggers, dashboards, and forecasts sized to your actual questions.
Brand, field, market access, finance, medical — decision-ready outputs in the formats your stakeholders already use, on the schedule they already keep.
What we do
Six practice areas, one habit: every deliverable answers a real business question, arrives on time, and is documented well enough that you could take it in-house tomorrow.
If a file arrives every week, we make it useful every week. Ingestion, consolidation, cleansing, standardization, and validation of your incoming data feeds — building the longitudinal asset your analyses sit on.
The reporting a brand actually runs on: trends, share, and source of business from your Rx and sales data, cut the way your team thinks about the market.
Longitudinal, patient-level analysis on de-identified claims and lab data — where patients enter, where they stall, and where a small intervention changes the outcome.
Rule-based and model-driven signals that watch your data between report cycles, so the field and patient-services teams hear about a change while it still matters.
Patient-based and trend-based forecasts grounded in your real data and transparent assumptions — plus monitoring of forecast versus actuals after the fact.
Live dashboards and scheduled reports that compare against prior snapshots and surface the trend, delivered in your stack — not one more portal to log into.
Rules where rules suffice, models where they earn their place — explainable everywhere, delivered on a schedule, routed to the people who act on them.
Refill gap widening — 312 enrolled patients past expected refill by 14+ days, concentrated in two specialty pharmacies.
NBRx decline, 2 consecutive weeks — 47 prescribers flagged; 31 were top-decile writers last quarter. List routed to field Monday.
Drug A → Drug C — switches up 18% on the prior period; most attributed to one plan's formulary move. Bands are colored by the therapy patients moved to.
Discontinuation — one in ten starters off therapy by month 12, concentrated in two specialty pharmacies' status files. Cohort list routed to patient services.
The questions we answer
Some questions justify a six-month engagement. Most just need a good analyst and a deadline. A sample of real-shaped work — the shape of a Whetstone month — scoped in a conversation, delivered on a date:
Rebuild the weekly TRx trend deck around a new file layout — needed for Friday's leadership call.
One brand, one region: payer-mix and prior-auth table for Thursday's P&T prep.
Persistency and compliance curves for patients initiating therapy in 2025 versus 2024.
Flag prescribers whose NBRx has fallen two consecutive weeks; refresh the list every Monday.
Summarize A1c distribution across a de-identified lab cohort against therapy starts.
Reconcile specialty-pharmacy status files against referral records — and find where patients leak out.
Turn the monthly wholesaler file into territory workbooks the field can actually open.
Pressure-test the forecast the agency delivered before it goes to finance.
Build a call-planning list from affiliation reference data plus last quarter's writers.
Take over the recurring report your last vendor left behind, undocumented.
Right-sized by design. A one-day question gets a one-day project — and a one-day invoice.
Send us yoursHow we work
The same four moves on every engagement, whether it's a one-day pull or a standing weekly pipeline.
Twenty minutes on the question and the data behind it. You get a fixed scope, a fixed fee, and a delivery date before any work starts.
We work inside your environment where you have one. Where you don't, we set up secure transfer once — SFTP, S3 — and never make you re-send anything.
Your work is done by people who know what an NBRx is and why the layout changed. Every field mapped, every refresh checked for anomalies and trend breaks — with a QC log to prove it. Models where they earn their place, explainable everywhere.
Outputs in the format your stakeholders use, on the schedule they keep. You own everything we build: code, models, documentation — all of it.
Fixed scope, fixed fee, fixed date. The right shape for a single analysis, a forecast review, or a report rebuild.
A monthly block of senior hours for the steady stream of small asks — recurring reports, triggers, and the Tuesday-afternoon questions.
A dedicated Whetstone analyst working in your tools and your meetings — capacity without headcount, and without a six-month recruiting cycle.
Fixed fee, quoted before work starts. Scope drives the fee: a one-day analysis is a one-day fee; a report rebuild is typically three to five days. Retainers start after a first project and run in three-month blocks.
Data & security
We work exclusively on data you're licensed to use, inside the terms of those licenses — de-identified at the patient level, in your environment by default.
Weekly and monthly Rx claims, prescriber-level trend files, new-to-brand feeds, and retail/mail splits.
Open and closed claims for diagnoses, procedures, and sites of care — the backbone of journey and access work.
De-identified results feeds from national labs, linked to therapy behavior for eligibility, monitoring, and outcomes views.
Status files, referrals, dispenses, and patient-services data — reconciled so the funnel finally adds up.
Prescriber and account universes, affiliations, and hierarchies to keep targeting and roll-ups clean.
Master data, alignments, and targeting lists — joined to the market view so the story is one story.
Weekly Rx trend files · longitudinal patient claims · lab results feeds · specialty-pharmacy status files · patient-services extracts · prescriber and account universes · 852/867 channel data
New sources and layout changes are routine here. If a file lands in your organization, we can put it to work — inside the terms of your licenses, every time.Questions we hear
No — deliberately. Whetstone doesn't sell data, resell licenses, or take referral fees from anyone who does. We work with the data you already license and the internal data you already own, which keeps our advice independent and your vendor relationships yours.
Not for projects. Our smallest engagements are one-day analyses — if it takes a day, we bill a day. Retainers start after a first project and run in three-month blocks.
Fixed fee, quoted before work starts. Scope drives the fee: a one-day analysis is a one-day fee; a report rebuild is typically three to five days. Retainers start after a first project and run in three-month blocks. The first deliverable typically lands within the first week.
Only data you're licensed to use, within the terms of those licenses, under NDA and a data-processing agreement. Patient-level data is de-identified. We work in your environment by default, sign your data vendors' third-party access agreements, and complete your security questionnaire before a file moves. The full list is under How we handle your data.
Yours, by default — your warehouse, virtual desktop, or clean room, so nothing leaves unless you choose it. Where there's no environment for us to work in, we set up secure transfer once, under NDA and a data-processing agreement.
Yours. Excel, Power BI, Tableau, Qlik, Snowflake, Databricks, Python, R, SQL — we build in the stack your team already uses, and everything is handed over so you're never locked in.
Days, not quarters. For ad-hoc work, the first deliverable typically lands within the first week. Recurring pipelines take a little longer to stand up — then they run on schedule.
Yes — it's a specialty. We reverse-engineer the logic, document it properly, fix what was quietly broken, and keep it running on time. Undocumented inheritance is often where a relationship starts.
Every recurring deliverable has a runbook, and you own everything we build — code, models, documentation — so nothing depends on one person, and your own team could run it tomorrow.
Didn't find it? Ask Whetstone — quick answers now, a team member if it needs one.
Scope a project
Two lines about your data and the question you can't get to. We'll reply within one business day — with an honest read on fit, a rough size, and a start date.
contact@praxisadvisoryconsulting.comNot ready to scope it yet? Ask Whetstone first.