Found by AutoExplore
Find overlooked product costs.
Explore product profitability and see which costs deserve a closer look.
Started from a subject area.
AI business intelligence
Ask a question or choose an area to explore. xFalcon finds answers in your business data and shows you what’s behind them.
Finding
Your bestseller has a hidden margin problem.
Accessories and packaging were hiding the true cost of a bestselling bundle.
WHAT IT FOUND
AutoExplore tied overlooked costs to the product that incurred them.
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.
THE EVIDENCE
Sources, definitions and SQL behind every finding.
The finding
17%margin left on the bundle
How it was calculated
Selling price100%−Product cost54%−Accessories18%−Packaging11%=Margin left17%
What it readRead-only
order_linesSelling price after discounts. Selected period only. Returns are excluded.bill_of_materialsProduct and accessory cost, by SKU. Accessories count against the bundle they shipped with.packaging_specPackaging cost, by SKU. Charged to the product that uses it.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.skuProposed next step
Fewer accessories, same price.
Review a leaner bundle with the person who owns the range.
Questions to consider
FOR YOUR TEAM
Set permissions, agree on definitions and review activity.
Your admins set tool permissions. Approvals and denials are recorded.
Manage users, data connections and tool permissions in one admin console.
Give each metric an agreed meaning. Definitions guide queries, and earlier versions stay available.
ACROSS THE BUSINESS
Start with an area to explore or a question to answer.
Found by AutoExplore
Explore product profitability and see which costs deserve a closer look.
Started from a subject area.
Asked by a person
Compare workload and cost across departments.
Started with a business question.
Field Service carries 18% of the workload and 29% of the cost.
Open a demo dashboard and explore the numbers.
Explore a demoTHE PRODUCT
Investigate, Explain, Deliver, Act and Govern.
WHAT YOU NEED
Choose a question worth answering. We’ll help you try it on your data.
Read-only access to Snowflake, BigQuery, Databricks, Redshift, Postgres, SQL Server and Oracle. CSV and Excel upload at gigabyte scale is also available.
One person to define the metrics, one to approve the connection.
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
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