Data-driven management, for a food SME, means taking decisions based on facts drawn from your own data rather than on gut feeling. In practice: knowing in a few minutes which customers are ordering less, which product is losing money and what a raw material rise does to the margin. It requires connecting existing data, not changing ERP.
This article is for leaders of food and drink SMEs who have data in their ERP and Excel files but still manage by feel. It sets out a four-step method, the indicators to track and the mistakes to avoid, with the case of one of our customers.
Key takeaway
according to the French Data Maturity Observatory 2024, 43% of the leaders surveyed see data quality as a major obstacle and 44% struggle to get their data projects adopted. Data-driven management comes down to four steps: bring data together, structure five to seven indicators, read them in context, act sooner. At a €9M dairy business, a 4% drop in orders turned out to be concentrated on two customers and two products.
The data paradox in food SMEs
Your ERP has been accumulating data for years. Your salespeople report field information every week. Your Excel files track purchases, sales and production costs. You hold a considerable amount of information about your business. And yet most important decisions are still taken on instinct.
This paradox is widespread. The French Data Maturity Observatory 2024, based on 339 respondents including 150 SMEs and mid-sized companies, shows that 43% see data quality as a major obstacle and 44% have difficulty getting their data projects adopted.
In a sector where margins are under pressure, it has a cost. According to a Banque de France study published by ANIA, the French food industry association, the net margin of food manufacturers was 3.5% of revenue in 2024. With so little margin, a decision taken six weeks too late shows in the results.
Managing by data: what it means for a food SME
The term often brings to mind heavy projects: data warehouses, data scientists, sophisticated dashboards. For a food SME, the reality is simpler.
A data-driven organisation takes its decisions on verified data rather than on experience alone or opinion. It is not the absence of human judgement: it is judgement exercised on facts.
In practice, it means being able to answer these questions in a few minutes, not a few days:
- Which customers ordered less this month, and on which products?
- What is the real margin of each product, with current variable costs?
- If a given raw material rises 8%, which products fall below my profitability threshold?
- Which customers are profitable, and which use up resources without contributing to margin?
These questions require neither an analyst nor a new ERP. They require the data that already exists to be organised to answer them automatically.
Why it is still difficult in most food SMEs
Data scattered across several tools
The ERP stores orders and purchases. The CRM or sales files track customers and selling prices. Production reports its data elsewhere, sometimes in Excel. Accounting has its own software. Cross-referencing them takes manual exports and reconciliations, which tie up hours every week to produce figures that are already out of date.
Too broad a view of performance
Most SMEs manage with aggregated indicators: the month's revenue, overall gross margin, cumulative purchases. These figures hide individual situations: products losing money, unprofitable customers, products whose cost price has drifted without anyone noticing.
Response time that is too long
When raw material costs vary from one month to the next and negotiations require precise arguments, deciding on figures that are 30 days old is a real constraint. Useful data is data available at the right time.
The 4 steps of data-driven management in a food SME
1. Accessibility: bring your data sources together
Gather existing data in a single, accessible place: ERP, sales tracking files, purchasing data, production history. The point is not to create data, but to connect what you have. We detail the possible connections in our article on agents connected to the ERP.
This is the most technical step, and the most decisive. You do not need perfect data to start: imperfect data in one place is worth more than perfect data scattered across five tools. The most common flaws, and how to fix them, are listed in ERP data quality in the food industry.
2. Analysis: choose five to seven management indicators
Once the data is together, define your key indicators, and keep only those that trigger a decision. For a food SME, a useful dashboard comes down to five to seven indicators.
| Indicator | Recommended frequency |
|---|---|
| Change in orders by customer | Weekly |
| Contribution margin by product | Monthly, and at every raw material rise |
| Purchase cost of key raw materials | Continuous |
| Material loss rate by line | Monthly |
| Gap between list and actual selling price | Monthly |
The rule is simple: if an indicator does not make you take a different decision, it has no place on the dashboard. The margin indicators are detailed on our page about margins in food industry SMEs.
3. Interpretation: read the figures in context
This is the most often neglected step. Structured data is not enough: it still has to be read with the right context.
The managing director of one of our customers, a dairy processing SME with €9M in revenue, notices a 4% drop in orders over the quarter. Read globally, the figure is worrying. Broken down by customer, it shows the drop is entirely concentrated on two accounts, which cut their orders on the same products. Read alongside purchasing data, it turns out these two customers have found cheaper alternatives in that specific segment.
The decision is not the same depending on whether you have the first figure or all three. That is interpretation: not reading a metric on its own, but with what explains it. It is also the step that gains most from automation: a tool that spots on its own that a drop is concentrated on certain customers, and links it to other data, does in seconds what would take hours.
4. Action: decide sooner
Data only has value if it leads to a decision, and a decision only has value if it comes early enough to change something.
A leader who knows within the week that a range's margin is falling below threshold because of a raw material rise can act immediately: renegotiate, adjust a production volume, trigger a price revision clause. Without that, they discover the problem six weeks later, at the month-end close.
What it changes in day-to-day decisions
Passing on a raw material rise. The question is no longer "do we pass it on?" but "on which products, for which customers, by how much and how quickly?". Taken on precise data, this decision protects the margin without needlessly risking a customer relationship.
Defending the right customers. Not all customers deserve the same effort. Managing by data spots those whose orders are falling but who remain profitable, and focuses sales energy where it pays most.
Understanding a quarterly margin drop. Rather than discovering at the close that the margin has lost 2 points, weekly monitoring identifies the problem as soon as it appears, and allows it to be dealt with before it deepens.
The 3 mistakes to avoid
| Mistake | Why it is a problem |
|---|---|
| Changing ERP before dealing with existing data | The data is in your current ERP. A new tool solves nothing if the management method does not change. |
| Waiting to hire a data analyst | Today's tools automate most of the analysis without dedicated technical skills. |
| Wanting to measure everything at once | A 30-indicator dashboard is no more useful than a 5-indicator one: it is often used less. |
What data doesn't do for you
It does not replace the leader's judgement. The data shows that a customer is ordering less and where they are buying more cheaply. Deciding to align, to differentiate or to let that volume go remains a management decision.
It does not correct wrong data. A two-year-old cost price produces a wrong margin by product, with misleading precision. Making data reliable comes before the dashboard.
It does not work without rules. Who has access to what, who updates which indicator, who acts when a threshold is crossed: our data and AI governance roadmap helps set this out.
Where to start in practice
Define five non-negotiable indicators. Not twenty, not ten. Five indicators you commit to tracking every week, whatever else is going on. They will form the foundation of your management.
Map your data sources. Before considering a new tool, find out where sales, purchasing and production data sit. In most food SMEs, the data needed already exists: it is simply not connected.
Choose a reading rhythm. In a sector with variable costs, weekly reading suits operational indicators, monthly reading suits trends. Setting this rhythm avoids spending time on figures that will not trigger any decision.
Frequently asked questions about data-driven management in food SMEs
What is a data-driven SME?
It is a company whose decisions rest on its own data rather than on intuition alone. For a food SME, it means knowing every week the change in orders by customer, the margin by product and the effect of raw material prices, from ERP data, without piecing them together by hand.
Which indicators should a food SME dashboard track?
Five to seven indicators are enough: change in orders by customer, contribution margin by product, cost of key raw materials, loss rate by line, gap between list and actual price. Each one must be able to trigger a decision. Beyond that, the dashboard gets looked at less.
Do you need to hire a data analyst?
Rarely in an SME. Most of the work consists of connecting existing data and producing a few indicators automatically. Tools connected to the ERP do this without dedicated technical skills. Time then goes into reading the figures and deciding.
Do you need to change ERP to manage by data?
No. The useful data is already in your current ERP. Changing ERP ties up the team for months without settling the question of method. It is better to connect the existing ERP to an analysis tool and make the priority data blocks reliable.
Is Excel enough to manage a food SME?
To start, Excel can be enough to test five indicators. It quickly becomes limiting: manual exports, multiplying versions, late figures. As soon as tracking needs to be weekly and to cross-reference sales, purchasing and production, a tool connected directly to the ERP saves hours every week.
Further reading
Data-driven management is the condition for margins and reactivity to market swings to become truly manageable. It is also the foundation on which AI agents in the food industry work: they produce indicators and alerts automatically from ERP data.
Want to see what your data already says about your business? Book 30 minutes with us: we start from your ERP and look at your five priority indicators.
Ready to take control of your data?
Book a 30-minute demo and see what Agrolytics can do for you.
Book a demo

