AI business intelligence

Find what you weren't looking for.

Ask a question or choose an area to explore. xFalcon finds answers in your business data and shows you what’s behind them.

Found by AutoExploreIllustrative reconstruction

Finding

Your bestseller has a hidden margin problem.

Accessories and packaging were hiding the true cost of a bestselling bundle.

WHAT IT FOUND

Their bestseller earned less than they thought.

AutoExplore tied overlooked costs to the product that incurred them.

Where the bundle price goesIllustrative reconstruction
  1. 54%Product costThe unit cost already counted.
  2. 18%AccessoriesNot counted hereIncluded in the bundle, but costed across the range.
  3. 11%PackagingNot counted herePackaging used only for this bundle.
  4. 17%Margin leftAfter product, accessory and packaging costs.

How it started

The user chose product profitability and approved a plan. AutoExplore found the overlooked costs.

What was overlooked

Costs spread across the range hid how much this one bundle consumed.

See how it investigates

THE EVIDENCE

Every number traces back to a record.

Sources, definitions and SQL behind every finding.

Where the number comes from
  1. The finding

    17%margin left on the bundle

  2. How it was calculated

  3. What it readRead-only

    • Shipped order linesorder_linesSelling price after discounts. Selected period only. Returns are excluded.
    • Bill of materialsbill_of_materialsProduct and accessory cost, by SKU. Accessories count against the bundle they shipped with.
    • Packaging specificationpackaging_specPackaging cost, by SKU. Charged to the product that uses it.
Show the SQL

Bundle margin by SKU

Business rule: count accessories and packaging against the product they shipped with.

select  ol.sku,
        sum(ol.net_price)      as revenue,
        sum(bom.unit_cost)     as product_cost,
        sum(bom.accessory_cost) as accessory_cost,
        sum(pkg.unit_cost)     as packaging_cost
from    order_lines ol
join    bill_of_materials bom using (sku)
join    packaging_spec   pkg using (sku)
where   ol.returned_at is null
group by ol.sku
Retained
The SQL, the tables and columns it touched, and the question that produced it

Proposed next step

Fewer accessories, same price.

Review a leaner bundle with the person who owns the range.

Questions to consider

  • Would fewer accessories affect demand?
  • Would the bundle remain competitive?

FOR YOUR TEAM

You choose who can do what.

Set permissions, agree on definitions and review activity.

Tool permissions · analyst role
  • Read the warehouseAllowed
  • Load agreed definitionsAllowed
  • Write to a system you connectedAsk first
  • Take data out of the tenantDenied

Your admins set tool permissions. Approvals and denials are recorded.

Your team stays in control

Manage users, data connections and tool permissions in one admin console.

Shared business definitions

Give each metric an agreed meaning. Definitions guide queries, and earlier versions stay available.

See team controlsBuild or buySecurity and trust

ACROSS THE BUSINESS

The same method, anywhere in the organization.

Start with an area to explore or a question to answer.

Found by AutoExplore

Find overlooked product costs.

Explore product profitability and see which costs deserve a closer look.

Started from a subject area.

Asked by a person

Does this department’s workload justify its cost?

Compare workload and cost across departments.

Started with a business question.

Departmental review · illustrative
Cost per request handledField Service$41.20Onboarding$22.40Billing$18.90Support$14.60Fulfilment$12.30
Field Service, by quarter$45$35$25Q1Q2Q3Q4
Share of workload against share of costWorkloadCost0%10%20%30%SupportFulfilmentField ServiceBillingOnboarding

Field Service carries 18% of the workload and 29% of the cost.

Example review with illustrative figures.

Open a demo dashboard and explore the numbers.

Explore a demo

WHAT YOU NEED

Start with one area of your business.

Choose a question worth answering. We’ll help you try it on your data.

  • Your existing data

    Read-only access to Snowflake, BigQuery, Databricks, Redshift, Postgres, SQL Server and Oracle. CSV and Excel upload at gigabyte scale is also available.

  • A business owner and a data contact

    One person to define the metrics, one to approve the connection.

  • One agreed use case

    Choose a subject area and agree what a useful result looks like.

Proof of concept

$3,5002-4 weeks

A working use case on your data. The fee is credited toward installation if you proceed. Full deployment takes 4-6 weeks.

You choose when to explore and approve the plan before it starts.

Get started

What could you find in your data?

See xFalcon explore a business question, then try it on your own data.

To try your own data, start with a $3,500 proof of concept over 2-4 weeks.

info@xfalcon.ai