Demonstration · Illustrative data · BI Consulting Services

Upstream Bio×BI Consulting Services

Claims-data market insight board · New Product Planning · Respiratory & Immunology
Prepared for Seth
September 2026 · Power BI concept demo

Where do the treated patients sit in the airway — and how many reach a biologic?

A single Power BI model over refreshed medical, pharmacy and eligibility claims: diagnosed prevalence, line-of-therapy flow, biologic share, payer mix and site of care for severe asthma, CRSwNP and COPD — the three indications in verekitug's development plan. Filter by indication, US census region and claims refresh.

Showing all three indications · national · Q3 2026 refresh

1Line-of-therapy flow, drawn as the airway

Each branch is a patient segment; branch width is proportional to patient count. Trachea = diagnosed population.

2Biologic-treated patients, trailing 24 months

Monthly count of patients with ≥1 biologic claim in the month, vs. planning baseline.
Actual (claims)Planning baseline

3Biologic share by mechanism

Share of biologic-treated patients by target class (pharmacy + medical J-code claims).

4Payer mix of biologic-treated patients

Primary payer on the most recent biologic claim.

5Prescriber specialty & site of care

Rendering-provider taxonomy on biologic claims, plus the HCP count behind each.

6Treated patients per 100k population, by region

Treated = ≥2 indication-coded claims and ≥1 maintenance-therapy fill in the refresh window.

7Claims feed refresh status

Structure for the refreshed claims drop: load counts, completeness against expected volume, and script run state.
SourceRows loadedLast refreshCompletenessScriptState

8What this board answers

Three new-product-planning questions, each answered from the current filter.

9Ask the data

Natural-language layer over the same model (Copilot-style). Illustrative response.
Demonstration · Illustrative data · BI Consulting Services
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min