AI THAT DELIVERS ON THE PROMISE OF BUSINESS INTELLIGENCE

Ask your warehouse anything. Get the answer, the why, and what to do next.

xFalcon dives into your complex business questions, follows the evidence, uncovers the drivers, and delivers answers and recommendations.

Book a demo See how it works

You asked

Why did Northeast margin drop?

3.2 ptsdownvs May

Traced to

Freight surcharges · 2 distributors

Review the evidence

query 8f3c-42a1

gross margin %

Net of freight surcharges, excludes intercompany.

3 tables · 184,220 rowsread-only

Definition v3. The v2 wording is still queryable.

Watch it work

A business question, and what comes back

A person asks in their own words. xFalcon plans the investigation, follows the evidence through the warehouse, and comes back with the driver, the size of it, and the part you can recover - then opens every figure back to the SQL it came from.

Ask the business question

An analyst asks about the Northeast margin drop in their own words. xFalcon does not go looking for a query to run - it returns the investigation it intends to carry out, and nothing runs until that plan is confirmed.

Northeast margin is down. Where did it go?

Plan proposed

Compare margin across regions and time
Isolate freight, product mix, pricing and volume
Identify the biggest drivers
Size what is recoverable

Confirmation gate

The plan runs only after the analyst confirms it. No run starts on a clock.

SELECT onlyRead-only on every backend

Margin decline
Freight
Contracts
Distributors

confirmedFreight surcharges rosetwo contracts, second query agreed from a different angle
partialProduct mix shifted to lower-margin SKUsreal, but only 0.4 points of the 3.2
ruled outDiscounting deepened in the regionnet price flat vs May
ruled outVolume fell and fixed cost spread thinnerorders down 1.4%, not enough

Standard of proof

One query is a hypothesis. Two that agree from different angles is a finding. An explanation the data will not support is dropped, and written down as dropped.

12queries run
4hypotheses tested
2drivers found

One investigationAny deliverable

AnswerThe finding in a paragraph, with its query ID attached.
ReportThe executive view - KPIs, drivers, charts, filters.
RecommendationRenegotiate the two freight contracts. 2.4 points by Q4.

Report: gross margin % by region, Jan to Jun

Gross margin %
28.9%
down 3.2 pts vs May
Freight / order
$18.40
up 22% vs May
Orders
41,180
down 1.4% vs May

Northeast28.9%
Midwest33.1%
West31.4%

You open it. Nothing here runs on a schedule.

query 8f3c-42a1Governed definition

gross margin % - net of freight surcharges, excludes intercompany

SELECT region, month, gross_margin_pctFROM   fct_margin_daily mJOIN   dim_freight_contract c  ON   c.contract_id = m.contract_idWHERE  region = 'Northeast'  AND  month >= '2026-01'  AND  month <= '2026-06'

fct_margin_daily184,220 rows · 6 columns read
dim_freight_contract14 rows · 2 matched
dim_region9 rows · 2 columns read

Recorded for this answer

12 tool rounds · 34.2 s · $0.041

Illustrative scenario. The figures are an example, not a named customer.

WHAT YOU GET

Same question, same answer. And you can prove where it came from.

01
One definition, so one answer
Ask in your own words. The metric resolves against your company's approved definition rather than whatever the query happened to say, so two people asking the same question get the same number - and a critical annotation overrides anything that conflicts with it.
02
Traceable, and it learns what you correct
Every answer opens to its query ID, the exact SQL, and the tables and columns it read. Correct it once and the correction is versioned and reviewed before it counts, then reused - so nobody re-explains the same thing next quarter.
03
Results in the shape you asked for
A table, a chart, or a saved report that re-queries live data and comes back in the format you captured. Personal work stays personal: nothing you save becomes the company's answer until an admin promotes it.

Explore all features See pricing

LIVE DEMOS