# Ask your business data questions in plain English, with reporting you can check

Source: https://ai.prospicience.in/capabilities/data-warehouse-and-text-to-sql

We build your reporting database and a chat that turns plain English questions into database queries, showing the query with every answer. For a mobile retail fleet, five reports replaced a day in a spreadsheet, 5.17 million dollars of sales were reconciled, and everything rebuilds in one click on a server costing a few dollars a month.

## What you get

- Every number comes straight from your database, with the query behind it shown alongside, so your finance team can verify any figure.
- Totals are checked against the source on every rebuild, so your reports always match your till or billing system.
- New columns from your source system are picked up automatically, so reporting keeps running as your business changes.
- Cancelled sales get their own line and known data gaps sit next to the chart they affect, so the picture you act on is complete.
- Sized to your real data, on a single small server, so running costs stay at a few dollars a month.

## Systems we have shipped for this

- E01 Sales reports and a question-answering chat for a truck fleet (Mobile retail fleet selling uniforms at hospitals): https://ai.prospicience.in/work/fleet-sales-reporting-and-chat
- E11 A factory's complete business system, with more than fifteen AI helpers built in (Transformer and brass parts manufacturer): https://ai.prospicience.in/work/factory-erp-with-ai-helpers

## What businesses come to us for

- A land agency wanted rule based site scoring over an external data feed, joined to their existing customer records, with a full action log for audit.
- A consultancy wanted a margin and revenue engine fed from their billing system, with a check layer proving the arithmetic matches the source.
- A staffing operator wanted market signals filtered against their ideal customer profile into a ranked prospect list.

## Questions

### Can AI write SQL against our database safely?

Yes. The chat has read only access, and every answer shows the query it ran, so anyone on your team can see exactly how a number was produced.

### Do we need a big data platform for this?

Usually not. The retail fleet's reporting database is a single file on a one gigabyte server that costs a few dollars a month. Most businesses have thousands of rows rather than billions, and we size the build to match.

### What happens when the source system adds a new column?

It is picked up automatically on the next rebuild, so your reporting keeps running without anyone maintaining it.

### How do you handle cancelled or refunded transactions?

They are reported on their own line. About 25,000 dollars of cancelled sales surfaced this way in one build, giving the owners a true view of every truck.