Sales
Question from the sales director
“Which three customers have cut their purchases most this quarter compared with the last one?”
Answer
- North Hardware
- −32%
- Lake Supplies
- −18%
- Vega Garages
- −11%
Sales model · query visible
Use case
Anyone on the team asks the company's data questions in their own words: “which customers have cut their purchases this quarter?”. The AI turns the question into a query, runs it and returns the answer.
Examples
Sample data from a fictitious distributor.
Question from the sales director
“Which three customers have cut their purchases most this quarter compared with the last one?”
Answer
Sales model · query visible
Question from the purchasing manager
“Which product families have the lowest margin this year, and how much have they sold?”
Answer
It comes with a monthly chart that can be copied into a presentation.
Question from the warehouse manager
“How many orders went out late last week, and from which warehouse?”
Answer
Saved as a frequent question for the team
The problem
Today
With AI
How it works
The person types what they want to know, in their own words.
“Sales by region in October?”
The AI turns it into a query on the data model, using the agreed names and definitions.
sales[region], month = 10
The database or Power BI runs it with that person's permissions.
4 regions · 1 table
Human review
The AI explains the result and shows the query. If the question is ambiguous, it asks before answering.
Table + chart + query
What it connects to
If the company works with Microsoft, that is the most direct route. If not, it connects to your database just as well.
Down to earth
If "sale" means different things in each department, the AI will be confused too. Definitions are agreed first.
The AI queries with each person's identity. Anyone who cannot see margins in the dashboard cannot see them in the chat either.
Before opening it to the team, we check a bank of real questions with their correct answers.
Meetings
When a question about the figures comes up in a committee, it can be settled on the spot, with the query in full view.
Method
We pick an area with reliable data and plenty of questions (sales, purchasing or operations) and collect the questions the team actually asks.
Bank of questions with their correct answers
We review tables, names and definitions so the AI understands them, and set up permissions.
Documented data model
A small group uses it for a few weeks. We measure accuracy, unanswered questions and the requests no longer sent to the data team.
Accuracy and usage report
We add AI to the tools your business already uses to automate tasks, search information and connect data without having to change everything.
Draw conclusions from your data with AI, even if you are not a data scientist.
Your spreadsheets, boosted with AI so you analyse more and type less.
Tell us where your data lives (Power BI, a database, the ERP) and which questions keep coming up. We will tell you whether they can be answered reliably in plain language.
May we measure visits?
We use Google Analytics to see which pages are visited. Its cookies are only set if you accept; if you decline, Google only receives cookieless signals. You can change this at any time from the footer. Cookie policy