AI Assistant over Nielsen Sales Data for a Global Beverage Company
An AI assistant that answers questions about Nielsen sales data with numbers and charts, a source behind every result. Client under NDA.
- Industry
- FMCG
- Country
- Polska
- Timeline
- Completed
- Team
- Small senior team
Where the client was
The company needed marketing and sales people to be able to ask questions about the data themselves, without knowing the file structure and without waiting for the analytics team. The answers had to be trustworthy: based only on the data, with the source of every number visible, because budget and promotion decisions are made on top of them. And the analytics team was to be relieved, not replaced.
What we delivered
Putting the data in order
We moved the data from Nielsen exports out of Excel and into a database, with automatic loading on every new delivery and quality checks at the door.
Writing down the knowledge about the data
The structure, the relationships between metrics, and the methodological quirks, previously known only to the analysts, were described once, in a form the AI understands. This description layer is maintained together with the data.
An assistant that answers from the data
A question asked in plain language is translated into a controlled query against the database. The assistant does not guess: it calculates on the data and answers with a number, a table, or a chart.
A source with every answer
Each result shows which data and which period it was calculated from, so an answer can be verified before it lands in a board presentation.
An analyst in the loop
Questions the assistant cannot safely translate into the data go to the analytics team. Each such case extends the data description, so over time the assistant answers more and more on its own.
Rollout in the teams
Marketing and sales got the chat in the tools they already use, along with training on what the assistant can and cannot do.
How the work was run
Sales knowledge that used to be locked inside a two-person analytics team became available to the whole company within a minute.
Scope of work
We delivered the assistant end to end, from raw data files to a tool used daily by business teams.
Workshops with the analytics team to capture the structure, metric definitions, and quirks of the Nielsen data before any code was written.
Building the data pipeline: automatic loading of new deliveries into a database, with validation and quality checks replacing manual Excel handling.
Creating the data description layer that lets the AI translate business questions into correct, controlled queries.
Building the assistant itself: plain-language questions in, answers with numbers, tables, and charts out, each with its calculation source.
Validating the assistant against the analysts' own answers before opening it to marketing and sales teams.
Setting up the analyst-in-the-loop process, so unusual questions reach a person and each case improves the data description.
Technologies
Let's Talk About Your Project
Not sure where to start? Begin with the AI Readiness Audit