Prism BI LLC

Engagement Estimator

Build your own estimate. Every line item is transparent and fixed at Phase 2 sign-off. No surprises after you sign.

Engagement Tiers

Clarity2-4 source systems, under 10M rows
Floor $45,000
Velocity4-7 source systems, 10M-500M rows
Floor $75,000
Momentum7+ source systems, 500M+ rows
Floor $125,000
PHASE 01

Discovery

$0
Source system discovery ? Auto-calculated from your ingestion selections below — $500 per source system. Deliverable: ERD of your full data landscape.
Auto $0
PHASE 03

Ingestion

$0
Standard source systems ? QuickBooks, spreadsheets, SaaS tools — includes API setup and cron jobs
$500 each
$0
ERP systems ? NetSuite, MS Dynamics, SAP, JDE, and similar
$5,000 each
$0
Salesforce ? Complex relational structure — priced separately
$5,000 each
$0
PHASE 04

Medallion Build

$0
Bronze layer tables ? Raw ingestion — source table count
$100 each
$0
Silver layer tables ? Cleansed and standardized — may differ from Bronze count
$100 each
$0
Gold layer tables ? Star schema fact and dimension tables — business-ready
$100 each
$0
PHASE 05

Power BI Build

$0
Semantic model + DAX build ? Flat fee includes up to 300 measures
$1,000 flat
$0
Additional DAX measures (over 300) ? Each measure beyond the included 300
$10 each
$0
Visualizations ? Each chart, table, card, or visual element across all reports
$25 each
$0
ADD-ON

Data Cleansing

$0
Cleansing level required ? Assessed during Phase 1 Discovery
$0
ADD-ON

Specialty Services

$0
ML scripts ? Built and validated against historical data, deployed in Snowflake or Fabric
$500 each
$0
Budget development ? Annual add-on — actuals vs budget model built on your existing data
$1,500 each
$0
Predictive trend visualizations ? Forecasting visuals built on your clean Gold layer data
$100 each
$0
Automated process scripts ? Power Query, Python, or Power Automate — custom workflow automation
$200 each
$0
Warm Transfer hours ? Post-delivery training and knowledge transfer
$200/hr
$0

Your Estimate

Discovery$0
Ingestion$0
Medallion Build$0
Power BI Build$0
Data Cleansing$0
Specialty Services$0
Itemized total $0
Engagement tier
Add your source systems to begin
Estimated engagement
$0
Higher of engagement floor or itemized total

Worked Examples

See how real engagements build up. Click any example to load it into the calculator.

Clarity Tier

Regional Distribution Company

$3M revenue, Charlotte NC. QuickBooks, payroll, and a warehouse management system.

Discovery (3 systems, auto)$1,500
Ingestion (3 standard)$1,500
Bronze (8 tables)$800
Silver (6 tables)$600
Gold (5 tables)$500
Power BI (1 model, 40 visuals)$2,000
Data cleansing (minor)$500
Warm Transfer (8 hrs)$1,600
Itemized total$9,000
Clarity floor + Warm Transfer
$46,600
Velocity Tier

Mid-Market SaaS Company

$12M revenue. Salesforce, NetSuite, proprietary platform, HubSpot, payroll.

Discovery (5 systems, auto)$2,500
Ingestion (SF + NS + 3 standard)$11,500
Bronze (18 tables)$1,800
Silver (14 tables)$1,400
Gold (10 tables)$1,000
Power BI (1 model, 80 visuals)$3,000
Data cleansing (moderate)$1,500
Warm Transfer (12 hrs)$2,400
Itemized total$25,100
Velocity floor + Warm Transfer
$77,400
Momentum Tier

Fasion Design Software

$25M SaaS. 7 source systems including 2 Billion row telemetry. 300+ measures delivered in 45 days.

Discovery (7 systems, auto)$3,500
Ingestion (SF + NS + 5 others)$15,000
Bronze (25 tables)$2,500
Silver (20 tables)$2,000
Gold (14 tables)$1,400
Power BI (1 model, 38 extra measures, 72 visuals)$3,180
Data cleansing (major)$10,000
Warm Transfer (16 hrs)$3,200
Itemized total$40,780
Momentum floor + Warm Transfer
$128,200

What is a source system?

Any software your business uses that stores data. Every place your business information lives right now counts as one source system.

Standard source systems

Everyday business tools we connect to directly. We set up automated data pulls on a schedule so your data flows in without you lifting a finger after setup.

What is an ERP?

An ERP (Enterprise Resource Planning) system is the central nervous system of a larger business. It manages financials, inventory, purchasing, manufacturing, and HR all in one place.

ERPs are significantly more complex to connect than standard tools — which is why they cost more to ingest.

Why is Salesforce priced separately?

Salesforce has one of the most complex data structures of any business tool. A single Account can have hundreds of related records — opportunities, contacts, activities, products, custom fields — all linked in ways that require careful mapping before any reporting makes sense.

Bronze layer

Raw data exactly as it came from the source. We preserve it untouched as a permanent record — the historical archive of everything before it was cleaned or transformed.

Think of it as the vault. Count the number of data tables coming in from your source systems.

Silver layer

This is where raw data gets cleaned, standardized, and made consistent. Duplicates removed. Naming unified. Dates formatted the same way. Fields aligned across systems.

Silver makes your data trustworthy before it becomes reportable. The Silver count may differ from Bronze as some tables get combined or restructured.

Gold layer

Your finished, business-ready data model — the star schema that Power BI connects to directly. Gold tables are optimized for speed and accuracy.

Two source tables might combine into one Gold fact table. A single dimension table might serve every report you have. This is where the real architecture lives.

What is a semantic model?

The intelligence layer between your data and your reports. It defines what every number means, how metrics are calculated, and how tables relate to each other.

Build it once, use it in every report forever. The flat fee includes up to 300 individual business measures — things like Revenue MTD, Gross Margin %, or Days Sales Outstanding.

DAX measures explained

A DAX measure is a single calculated business metric. "Total Sales," "Sales vs Last Year," "Rolling 90-Day Average," "% of Target" — each one is a measure.

300 covers most standard business reporting. Complex or deep-analytics environments may go over. Each additional measure beyond 300 is $10.

What counts as a visualization?

Every individual chart, table, card, bar, line, or visual element on any report page counts as one visualization.

A report page with a revenue line chart, a sales table, three KPI cards, and a map = six visualizations. More visuals means more design and configuration work.

Why data cleansing matters

Real example: a client wants a sales report for a major retail partner. We pull the data and find the same retailer entered three ways by three different people over the years: "Walmart," "Walmart Corporate," and "Wal-mart."

Until those are unified into one record, any report shows three partial numbers instead of one accurate total. Fixing it requires research, stakeholder interviews, and mapping tables.

We always normalize and standardize data as part of the build. Significant remediation beyond standard cleanup is scoped and priced separately to protect you from surprise costs.

Machine learning for your business

ML scripts analyze your historical data to find patterns humans miss. You do not need a data science team — you just need clean data and the right question.

A $500 script that identifies daily margin erosion could pay for itself in two months if it catches a $10/day pricing problem you did not know existed.

Stop guessing at your budget

A budget built on your actual historical data is completely different from one built on gut feel. We build an actuals vs budget model on your clean data so you can see in real time whether you are ahead or behind — by product, department, region, or rep.

Budgets hold your team accountable for where they said they were going. Are targets being met? Is a product line underperforming against plan? Your budget answers all of it — automatically, every day.

See where you are headed

Predictive trend visuals use your historical data to project forward. Instead of a revenue chart that stops at today, you see a confident forecast of where things are likely to go based on actual patterns in your data.

Your platform, your independence

Once your platform is live and delivering daily intelligence, we show you how to build your own reports. Not just how to read them — how to create them.

We work through your actual platform with your actual team until they are confident and self-sufficient. Available on-demand after delivery. No retainer required.

Custom automation built for your workflow

Sometimes a report needs to work WITH your team, not just display data at them. These are custom scripts built in Power Query, Python, or Power Automate that solve specific workflow problems unique to your business.

Real example: a client needed to track "new products" in their reports but "new" was subjective — their team defined it differently each season. We built a simple spreadsheet their team maintains that Power BI reads as a live filter. Their definition of "new" updates anytime they want, and every report refreshes automatically.