BRP Pharmaceuticals × BI Consulting Services

Point-of-care dispensing · Burbank, CA · Prepared for Rick · September 2026

Demonstration · Illustrative data · BI Consulting Services Dispensing Commercial & Supply Board · Power BI concept

One board for the numbers that used to live in thirty-one workbooks.

Sales by formulary, region and product · lot expiry against BRP's 6-month ship floor · repack-to-release cycle time · chargebacks and rebates vs plan — all from one SQL model, refreshed nightly.

Before31 Excel workbooks
→
NowSQL Server · 1 model
→
RefreshNightly 02:00 PT
Trend

Net revenue by formulary vs plan

What this board answers

Three questions, three numbers

Signature view · inventory risk

Lot expiry horizon — on-hand lots against the 180-day ship floor

Inside floor (<180 d) 180–365 d 1–2 yrs 2 yrs + Tile height = prepacks on hand
Ranking

Top products by net revenue

Operations

Repack → QC release cycle time

Target ≤ 3.0 days
Margin leakage

Chargebacks & rebates vs plan

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