PioneerRx Analytics Dashboard

I want a live, self-service dashboard that plugs into the Pioneer Rx read-only API, ingests the full billing history, of pharmacy dispensing and automatically cross-references each NDC with its GCN / First Databank equivalents. The core purpose is to surface three things in one place:
• high-profit items, ranked by margin and volume
• clear opportunities to swap current NDCs for lower-cost equivalents within the same GCN
• dispensing discrepancies that point to potential billing or inventory errors

The data model must stay aligned with Pioneer Rx’s schema, yet be flexible enough for ad-hoc filters (date range, payer, store, drug class, etc.) and scheduled refreshes without manual intervention. Visuals should be crisp and intuitive—bar or line charts for trends, tables with conditional formatting for profit and discrepancy alerts, and drill-through views down to the individual Rx level.

All code, connection scripts and transformation logic should be delivered alongside the interactive report, so I can redeploy or extend it later. I’m tool-agnostic; Power BI, Tableau or a comparable platform is fine as long as it handles API refreshes gracefully.