SAMPLE AND DEMONSTRATION ONLY. Illustrative analysis of publicly available information, prepared by BI Consulting Services. Not affiliated with, endorsed by or produced for any company shown.
Demonstration · Illustrative data · BI Consulting Services

Locust Walk × BI Consulting Services

The deal-flow warehouse — a business-development board across CRM, marketing platform and ERP
Prepared for Chris
September 2026 · Business development

One semantic model under every mandate — so the question “where did this deal come from, and what did it take to close?” has one answer, not four.

Therapeutic area
Period
Transactions closed since 2008
80+
5 offices · 3 countries
Published figure — locustwalk.com¹
Active mandates
–
Pipeline value (aggregate deal size)
–
Median months to close
–
Win rate (closed ÷ decided)
–
Marketing-sourced mandates (in flight)
–
Signature · Data architecture

Four lines, one interchange: how the sources reach this board

Drawn as a Boston transit map. Every line is one of your systems; every station a table the model reads; the interchange is the shared semantic model this board (and every future board) sits on. Station counts recalculate with the filters.

CRM line Marketing-platform line ERP line Other-sources line (deal databases, spreadsheets, calendar)
Pipeline

Mandate funnel

Every mandate in flight during the period and how far it has travelled. Stages are cumulative — a closed mandate counts at every stage.

Trend · 24 months

Mandates won per month, Sep 2024 – Aug 2026

Bars are mandates closed; the line is the trailing 3-month average. Months outside the selected period are dimmed.

Ranking

Therapeutic area × deal type

Mandates closed in the period, split by deal type, with the aggregate deal size and median months to close.

LicensingM&AFinancing
Marketing → BD attribution

Where mandates came from

First-touch source of every mandate in flight during the period, joined from the marketing platform to the CRM deal record — with the share that closed in the period.

What this board answers

Three questions a BD lead asks every Monday

Each answer below is read straight off the board for the current filter.

Ask the data · mock

A question typed in plain English

What a natural-language layer over the same semantic model would return. The answer is computed from the board's figures for the current filter.

Source: semantic model (Fact Mandate, Fact Touch, Dim Therapeutic Area). Illustrative — no live model is attached to this page.
Also from BI Consulting Services

Private AI on your own server

The "ask the data" panel above is built to run on a GPU server inside your own network: an open-weight model over your own documents, with every answer citing the file it came from. No per-seat licence, works offline, and nothing leaves the building.

How it sits in your environment

YOUR NETWORK · NOTHING LEAVES THE BUILDING Your files policies · SOPs · contracts reports · ERP exports indexed locally GPU One server, in your building open-weight model · your data only in seconds Cited answers every reply links to the source file and page no cloud AI · no third-party processor
One appliance-class server on your rack or in a secured closet. Your files are indexed where they already live; the model runs locally; answers come back with the source page attached.

What that means in practice

  1. 1
    Your data only, on your hardwareAn open model over your own documents and exports. No third-party AI processor, no data-transfer agreement to review.
  2. 2
    Every answer cites its sourceReplies point to the file and page they were drawn from, so people check the answer instead of trusting it blind.
  3. 3
    No per-seat licenceThe whole team can ask questions. Cost is the server and our build, not a monthly number that grows with headcount.
  4. 4
    Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.

The short deck

14 slides on how a private AI server is scoped, secured and rolled out. Click through, or take the PDF.

Download the PDF
Private AI on your own server — slide 1 of 14 Private AI on your own server — slide 2 of 14 Private AI on your own server — slide 3 of 14 Private AI on your own server — slide 4 of 14 Private AI on your own server — slide 5 of 14 Private AI on your own server — slide 6 of 14 Private AI on your own server — slide 7 of 14 Private AI on your own server — slide 8 of 14 Private AI on your own server — slide 9 of 14 Private AI on your own server — slide 10 of 14 Private AI on your own server — slide 11 of 14 Private AI on your own server — slide 12 of 14 Private AI on your own server — slide 13 of 14 Private AI on your own server — slide 14 of 14
1 / 14Tap or click a slide to advance · arrow keys work too

Worth a conversation? Book 30 minutes with NicholeBI Consulting Services · powerbiconsultingservices.com