Which product lines are really growing?
Once returns and part-months are treated consistently, month-on-month change can be compared fairly. The note will still say if a line is too small for its trend to mean much.
AVC Data Analytics prepares business data so that it can be trusted, processes it into consistent tables and summaries, and then explains in plain English what the figures do and do not show. Agreed outputs can be kept in a controlled hosted location for the people who need them.
| Customer | Date | Value |
| Hartley & Co | 3/4/25 | £1,200 |
| HARTLEY AND CO | 2025-04-03 | 1200 |
| Brook Joinery | blank | n/a |
| Customer key | Date | Value (GBP) |
| HARTLEY-CO | 2025-04-03 | 1200.00 |
| BROOK-JOIN | flagged: no date | flagged: no value |
| 1 duplicate merged, 2 gaps reported back to you | ||

What the company does
Most reporting problems are preparation problems that have been left until the end.
AVC Data Analytics Ltd is registered for data processing, hosting and related activities. In practice that means three connected pieces of work. First, we take the exports, spreadsheets and records a business already has and prepare them: matching, de-duplicating, standardising and documenting every change. Second, we process the prepared data into the tables, summaries and recurring reports that a team actually uses. Third, we interpret the results with you, so that a chart is accompanied by a short, honest note on what it can support.
We are deliberately practical. You will not be asked to buy a platform before we have seen the shape of your data, and we will tell you plainly when a question cannot be answered from the records you hold.
These come up again and again in small and mid-sized British organisations. None of them needs a large programme; all of them need someone to look carefully at the data before anyone presents a number.
Services
You can ask for a single stage, for example a one-off clean-up before a board pack, or for the whole sequence as a recurring arrangement. Each stage ends in something you can hold: a file, a document or a link.
Stage A
We profile what you send, agree the rules with you, then clean and reshape the data. Every transformation is written into a change log so the result can be traced back to the source.
Stage B
Once rules are agreed, the work becomes a repeatable job instead of a manual exercise. A monthly or weekly extract goes in; the same checks and transformations run; consistent tables come out.
Stage C
Numbers rarely speak for themselves. We write a short reading alongside each output: what moved, what is likely noise, which caveats matter and which questions the data cannot answer.
Stage D
Where it helps, agreed outputs are made available from a controlled hosted location rather than circulated by email, with access, retention and deletion arranged in advance.
Inputs
Outputs
Try it
A quick, illustrative estimate. Move the sliders to roughly match a file you work with and see which preparation steps would come first. Two further tools, for converting mixed dates and profiling a CSV sample, are on the tools page.
Tool 01 / illustrative
Estimate how much preparation a file needs before anyone should draw conclusions from it. Enter rough figures; no data is uploaded.
Preparation is not the goal; it is what makes a decision safe. Three examples of the kind of question prepared data can support, and the caveat that travels with each answer.
Once returns and part-months are treated consistently, month-on-month change can be compared fairly. The note will still say if a line is too small for its trend to mean much.
Joining order and dispatch records on a cleaned key shows where time is lost. If dispatch dates are missing for one depot, we say so rather than guess.
Matching variant spellings gives a defensible count of distinct accounts. The matching rules are listed so that anyone can challenge or repeat them.
Method
We agree the question, the files, the people and what a useful answer looks like.
We measure the data as it is: columns, gaps, formats and suspected duplicates.
You approve each cleaning rule before it is applied. Nothing is silently changed.
Rules run as a repeatable job; counts in and out are recorded.
We walk through the outputs and the note, and agree what happens next.
See the method in detail, including what we need from you at each step
Honest limits
We are a data processing company, not a regulated adviser. Interpretation notes describe your figures; they are not financial, tax, legal or investment advice.
We do not operate a physical data centre and we do not offer round-the-clock monitoring. Hosted outputs use reputable infrastructure arranged for the engagement, and support runs on UK working hours.
We do not hold industry certifications that we would need to list here, and we will not imply otherwise. If your organisation requires a specific standard, tell us early so we can discuss whether the work fits.
We cannot make poor source data accurate. We can make its weaknesses visible and measurable, which is often the more valuable outcome.
Related hosting
"Hosting" in our registered activity does not mean renting you servers. It means that the prepared datasets, reports and notes we produce for you can live in one controlled place for an agreed period, instead of drifting through inboxes.
Before anything is hosted we agree, in writing, who can see it, how long it is kept, how it is removed and what format you receive if you want it back. When an engagement ends, outputs are returned or deleted on the date agreed and we confirm that it has been done.
Resources
Our resources page has a glossary of the terms that appear in data work, a checklist for preparing an export safely, and guidance on reading a change log. They are written so that you can use them whether or not you work with us.
Support and contact
The most useful first message describes what the data is, roughly how large it is, where it comes from and what decision depends on it. Please do not attach files or paste records; we will agree a safe route if we need them.
We reply Monday to Friday between 09:00 and 18:00, UK time. Existing clients can raise questions about a run, an output or a hosted file through the support page.
Direct
AVC Data Analytics Ltd
Company number 17408779
Registered office: 131 Williams Lane, Fulwood, Preston, England, PR2 9UF