Synthetic data, 3,000 Rx fills, 500 patients, Jan 2024 to Dec 2025. Wound care, burn care, hyperbaric, and infusion therapy products. Built with Snowflake, SQL, Python, Power BI.
Total Rx Fills
3,000
Across all products and payers
New Patient Starts
1,749
Unique patients initiating therapy
PA Approval Rate
79.6%
Prior authorization approvals
Avg Time to Fill
4.8 days
Prescription to fill
Volume Trends
Monthly Rx fills and 3-month rolling average
Monthly new patient starts
Payer Performance
PA approval rate by payer
Payer summary
Payer
PA Requests
Approved
Approval Rate
Avg Days to Fill
Channel Mix and Patient Journey
Channel mix (specialty vs retail)
Fills by therapeutic class
Patient journey funnel
Product Detail
Drug
Therapeutic Class
Fills
Revenue
Avg Cost/Fill
All data are synthetic. This dashboard demonstrates the analytics workflow described in the repository README. Source: github.com/nicholasjh-work/pharma_dashboard