Financial Dashboard

Real-time executive insights
Connected

Drug Revenue by State

Revenue by prescriber state — sourced from {year}_quick_heat

Prescriber Revenue Heatmap
Hover over a state to see revenue, prescriber count, and revenue per day
Database Query
Querying database…
Low High
0
Top 10 States by Revenue
#StateRevenue Share of Totalvs Avg

Heatmap data sourced via SELECT state, revenue, pres_num, rev_per_day FROM {year}_quick_heat WHERE brnd_name = '...'

Drug Comparison

Compare up to 5 drugs side-by-side on the US map

Multi-Drug Revenue Heatmap
Hover over a state to compare drugs — sorted by highest revenue first
Database Query
Select drugs and click Compare…
Low High
0

Comparison data sourced via SELECT state, brnd_name, revenue, pres_num, rev_per_day FROM {year}_quick_heat WHERE brnd_name IN (…)

KOL Comparison

Compare Key Opinion Leader prescribing patterns across two drugs by state

KOL Prescriber Comparison
Prescribers who prescribed both selected drugs — sorted by total revenue
Database Query
Select filters and click Run Query to load KOL data

KOL data sourced from {year}_prov_drug_data_p — prescribers who prescribed both selected drugs

KOL Drug Table

Single-drug prescriber breakdown by state — Key Opinion Leader prescribing data

KOL Drug Prescriber Table
Prescribers for the selected drug — sorted by revenue
Database Query
Select filters and click Run Query to load prescriber data

Data sourced from {year}_prov_drug_data_p — single drug prescriber breakdown

KOL Trend Comparison

Year-over-year revenue difference between two drugs per prescriber — sourced from prov_drug_pivot

KOL Trend Comparison
Revenue difference (Drug 1 − Drug 2) per prescriber per year — sorted by combined lifetime revenue
Database Query
Select two drugs and click Run Query

Data sourced from prov_drug_pivot — year-over-year revenue difference per prescriber

KOL SD Trend

Single-drug year-over-year prescriber revenue by state — sourced from prov_drug_pivot

KOL SD Trend
Single-drug prescriber revenue per year — sorted by lifetime revenue
Database Query
Select a drug and state, then click Run Query

Data sourced from prov_drug_pivot — single-drug prescriber revenue by state

Drug List

Browse drugs by therapeutic area — sourced from drug_list

Drug Directory
Showing all drugs — filter by therapeutic area to narrow results
Database Query
Loading drug list…

Data sourced from SELECT brand_name, thera_class, manufacturer FROM drug_list