Now in Private Beta

Scenario Modeling
as Powerful as Excel,
Built for Teams

BIDB.ai brings the logic of pivot tables and formulas into a collaborative, cloud-native platform — so your whole team works from one live model, not a dozen spreadsheet files.

Request Early Access See Features
BIDB.ai FY2026 Revenue Planning Model.bidb
Home
Insert
Formulas
Data
Scenarios
Collaborate
View
G9
fx
=IF(AND(SEGMENT="Enterprise",QUARTER>=3), PREV_QUARTER*(1+GROWTH_RATE), BASE_ARR)
Scenario / Segment
Q1
Q2
Q3
Q4
FY Total
vs Budget
▾ Base Case
Enterprise
$1.2M
$1.4M
$1.7M
$2.1M
$6.4M
+12%
Mid-Market
$0.6M
$0.7M
$0.8M
$0.9M
$3.0M
+5%
SMB
$0.3M
$0.3M
$0.4M
$0.4M
$1.4M
0%
▾ Upside Scenario (+15%)
Enterprise
$1.4M
$1.6M
$2.0M
$2.4M
$7.4M
+29%
↗ Headcount Cost [linked]
$0.8M
$0.9M
$1.0M
$1.1M
$3.8M
Headcount Model
▾ Downside Scenario (−10%)
Enterprise
$1.1M
$1.2M
$1.5M
$1.9M
$5.7M
−1%
Revenue Model
Headcount Model
P&L Summary
Cash Flow
Core Capabilities

Everything your planning model needs.
Nothing it doesn't.

Four powerful primitives that unlock planning models of any complexity — without the spreadsheet chaos.

Large-Scale Pivot Tables

Build multidimensional pivot tables that scale across thousands of rows and dozens of dimensions — without performance degradation. Group, slice, and pivot on any axis.

Multidimensional
ƒ

Conditional Formulas in Pivots

Drop custom formulas directly into any pivot cell — conditionally. Apply logic only when criteria are met, blending lookup, aggregation, and business rules in one expression.

Conditional Logic

Cross-Linked Pivot Models

Reference live values from one pivot inside another using formula links. Changes propagate automatically — your headcount model feeds your revenue model feeds your P&L.

Live Links

Robust Planning Models

Assemble scenario-aware planning models from linked pivots. Run Base, Upside, and Downside cases side-by-side, with version history and real-time team collaboration.

Scenario Planning

From data to decisions
in four steps

1

Connect Your Data

Import from spreadsheets, databases, or data warehouses. BIDB.ai structures it into queryable collections ready for modeling.

2

Build Pivot Tables

Drag dimensions onto rows and columns. Define measures with formulas. Apply conditional logic to any cell or range in the pivot.

3

Link Models Together

Use formula references to pull live values from any pivot into another. Build a dependency graph that auto-propagates on change.

4

Collaborate & Scenario-Plan

Invite your team. Run multiple scenarios. Compare outcomes side-by-side and share a single source of truth with stakeholders.

Conditional formulas that think like you do

Write expressive, spreadsheet-like formulas directly in pivot cells — and link them to live values in other models. No macros. No scripting. Just formulas that understand context.

  • Apply formulas conditionally — fire only when row, column, or filter criteria match
  • Reference cells across linked pivot tables with simple TABLE.measure syntax
  • 100+ built-in functions: financial, statistical, logical, and date-based
  • Formulas recalculate in real-time as upstream data or linked models change
Revenue Model · Enterprise Row Formula Conditional
1// Fire only for Enterprise segment, Q3 onwards
2IF(
3AND(SEGMENT = "Enterprise", QUARTER >= 3),
4PREV_QUARTER * (1 + GROWTH_RATE),
5BASE_ARR
6)
Headcount Cost · Linked from Headcount Model Cross-Linked
1// Pull live headcount cost from linked model
2HEADCOUNT_MODEL.total_cost(
3department = "Sales",
4scenario = CURRENT_SCENARIO,
5quarter = QUARTER
6)
10×
faster model builds vs. spreadsheets
linked pivots per workspace
100+
built-in formula functions
Live
real-time team collaboration
Limited spots available

Ready to model
without limits?

Join the teams already using BIDB.ai to build planning models that actually reflect how their business works.

No credit card required  ·  Free during beta

You're on the list!

We'll be in touch soon with your access details.

Waitlist Submissions Owner Only
Loading submissions...