A five-page supply chain dashboard tying sales, shipments, inventory and supplier risk to profit.

A Power BI model and report for supply chain performance, built on a star schema of four fact tables (sales, purchases, shipments, inventory) and five dimensions. 140+ DAX measures cover OTIF and fill rate, inbound on-time delivery, inventory turns and days-in-inventory, stock-out and excess/dead stock, purchase price variance, freight cost, and supplier concentration. A risk layer links supplier risk tiers to the revenue they expose, so a late or defective supplier shows up as money at stake. Five pages: Executive Control Tower, Operations & Supplier Risk, Supplier Scorecard, Warehouse Snapshot and a Supply Chain P&L with a dynamic line selector. Built in the source-control-friendly PBIP / TMDL format. Synthetic data only.

Executive Control TowerOperations & Supplier RiskSupply Chain P&L

A four-page delivery-intelligence report designed and produced end to end by my DAX Workbench pipeline — finished by hand.

A professional-services dashboard (utilization, margin, collections, project economics) whose entire build ran through my DAX Workbench delivery pipeline: a Claude agent profiled the raw CSVs, designed the star schema, authored the semantic model as TMDL through the Power BI modeling MCP, wrote 37 measures that were each validated on the live engine, and generated the report as PBIR code — with me holding approval gates at every consequential step and applying the final visual polish by hand. Every headline number was re-computed on the engine by the pipeline's verifying gates and reconciles with the source files exactly (Revenue $62,870,822, to the penny; the AR aging buckets sum precisely to Outstanding). Ships with dynamic multi-role row-level security (Admin / Region / Practice, deny-by-default) added later as a governed change request, a Client-360 drill-through, and documentation generated from the model itself — the whole project lives in Git as PBIP.

Executive Command CenterDelivery & UtilizationClient & Project ProfitabilityFinancial Health · AR agingClient 360 drill-through

A board-ready finance dashboard where every number reconciles to the audited accounts.

A Power BI finance model for a Managed Service Provider that unifies billing hours, P&L and the balance sheet into one board-ready board — where every client, service and month ties back to a single audited revenue total (~£40M across 36 months). Where per-account revenue isn't reliable, the audited P&L is split by each account's share of billable value and cost by its share of actual delivery cost, so margins vary realistically. Includes semi-additive balance-sheet measures, a sign-convention P&L, common-size analysis, Row-Level Security and full time intelligence (YoY, MoM, fiscal YTD, rolling 12-month). Built in the source-control-friendly PBIP / TMDL format. Synthetic data only.

Executive SummaryValue FlowPer-figure insightService / Client breakdowns

End-to-end Power BI solution on medical-legal data, secured with dynamic RLS.

A complete BI solution built on synthetic medical-legal data: SQL Server views and stored procedures → Power Query ETL → a star schema with a bridge table → 40+ DAX measures → 6 report pages plus an executive dashboard, published to Power BI Service. Advanced DAX includes time intelligence, RANKX leaderboards, an Nth-largest-value measure driven by a disconnected parameter table, and a dynamic measure selector. USERPRINCIPALNAME()-based row-level security means each law firm sees only its own data — scalable to new firms with zero model changes.