Business Intelligence for SMEs: steering with dashboards

Month-end. The manager closes the office later than planned: the sales rep's revenue has to be consolidated, cross-checked against the payments book, compared with what the stock files say, and then available cash has to be guessed at. The verdict lands… once the period is already closed and it is too late to act. Thousands of SMEs live through this scene every month. Business Intelligence exists precisely to put an end to it.

Business Intelligence, without the jargon

Behind the intimidating phrase lies a simple idea. Business Intelligence (BI) — or "decision support" — refers to all the methods and tools that turn a company's raw data into information you can read in order to decide. Sales, purchasing, stock, payments received: those figures already exist somewhere. BI collects them, organizes them and presents them in a form you can grasp at a glance.

For a long time, the term conjured up enormous projects reserved for multinationals: data warehouses, specialist consultants, six-figure budgets. That era is over. For an SME, BI today takes a concrete and affordable form: a dashboard that answers very down-to-earth questions. How much have I sold this month? What is my margin? How much do my customers owe me? Which products are moving and which are sitting on the shelf?

Static reporting versus real-time dashboards

This is the most important distinction to grasp, because many SMEs believe they are "doing BI" when all they produce is reporting. The two have neither the same purpose nor the same value.

A report is a static document — often a spreadsheet or a PDF — describing the past once the period is over. It records. You read it, you nod, and you file the month away. The problem: by the time the report arrives, the levers for acting on that period are gone. The stockout has already cost you sales; the unpaid invoice is already six weeks old.

A dashboard, by contrast, is a living screen, fed continuously, showing the current state of the business. It does not merely describe: it alerts and prompts action before it is too late. The stock threshold is approaching? You see it today. A customer is exceeding their credit limit? The indicator turns red now, not in next month's report.

Criterion	Static reporting	Real-time dashboard
Horizon	The past, a closed period	The present, continuously
Freshness	Monthly or quarterly	Permanently updated
Purpose	Record what happened	Decide and act in time
Preparation	Manual consolidation, re-keying	Automatic, no data entry
Risk of error	High (multiple versions)	Low (single source)
Reactivity allowed	Too late	Immediate

The moral is clear: reporting records, the dashboard steers. An SME that wants to decide quickly needs the second, not just the first.

Which KPIs should you really track?

A KPI (Key Performance Indicator) is a measure chosen because it reflects the health of the business or progress towards a specific objective. The classic trap is wanting to measure everything: you accumulate thirty indicators and consult none of them. Better to have five to eight genuinely useful KPIs, looked at regularly.

Here are the indicators that really matter for the vast majority of SMEs, whatever their line of business:

• Revenue: the pulse of the business, to be tracked by period, but also by product, by customer and by sales rep in order to understand where growth is coming from.
• Margin: selling a lot with no margin makes you poorer. The margin rate reveals whether growth is healthy or whether it is masking an erosion of profitability.
• Available cash: the company's oxygen. An SME does not go under because it is unprofitable, but because it runs short of cash at the wrong moment.
• Accounts receivable: the amount your customers owe you. A swelling balance means your sales have turned into debts rather than cash.
• Inventory turnover: idle stock is sleeping money and a risk (expiry, obsolescence). Turnover shows whether your items are moving or getting stuck.
• Top products and top customers: the famous 20/80 rule. Identifying the items and accounts that generate most of the result steers commercial effort to where it pays.

Different KPIs for different roles

Not every KPI is meant for everyone. The manager needs an overall view; the sales, finance or logistics head needs indicators specific to their own scope. A good BI set-up gives each person the dashboard that concerns them.

Role	Essential KPIs	Decision it informs
Management	Total revenue, margin, cash, monthly trend	Where the company is heading, whether to invest or slow down
Sales	Revenue per rep, conversion rate, top customers, average basket	Where to focus effort, whom to follow up, what to push
Finance	Cash, accounts receivable, payment terms, unpaid invoices	When to chase, how to anticipate a cash gap
Stock / Logistics	Stock value, turnover, stockouts, dormant items	What to reorder, what to clear
HR	Headcount, payroll costs, absenteeism, leave	Keeping costs under control, anticipating needs

The four classic KPI traps

Choosing an indicator is easy; choosing one that changes something is far less so. Four failings recur with disconcerting regularity in SME dashboards.

The vanity KPI. It only ever goes up, never down, and is pleasant to look at: number of customers created since day one, cumulative annual revenue, number of quotes issued. These cumulative measures can only grow; they tell you nothing and trigger no decision. The test is simple: if an indicator cannot deteriorate, it has no place on a dashboard.

The orphan KPI. Nobody owns it. It is displayed, vaguely commented on, and nothing happens when it turns red. Every indicator should have a name against it: the person who has to react. Without an owner, a KPI is decoration.

The misleading average. A stable average basket can mask the collapse of your small customers offset by one exceptionally large order. The average flattens precisely what you are trying to see. As soon as an indicator aggregates heterogeneous situations, you must be able to break it down — by segment, by product family, by channel — or you will be steering blind while believing you are watching.

The KPI that drives the wrong behaviour. Tracking revenue per rep alone encourages discounting and volume at the expense of margin. Tracking service level alone leads to overstocking. An indicator shapes behaviour: before displaying it, ask yourself what it encourages people to do, and systematically pair it with its counterweight — revenue and margin, service level and turnover.

How to read a dashboard in order to decide

A dashboard that is read badly is useless, however handsome it looks. Three simple reflexes turn a screen of figures into concrete decisions.

1. Always compare

"84,000 dinars of revenue" means nothing in itself. Compared with the previous month, with the same period last year or with the target set, that number becomes information: growth, decline, or course held. The human brain does not judge an absolute value, it judges a gap. A good dashboard therefore systematically places the figure alongside a reference point.

2. Look for the trend, not the point

A bad day is not a crisis; an excellent week is not lasting success. The curve over several periods tells a story that today's figure hides. A margin eroding month after month is a far more reliable warning than an isolated dip. Learn to look at the slope before the point.

3. From the overview to the detail (drill-down)

The dashboard answers "how much". The right tool then lets you go down to the "why". Revenue is falling? You click to see which product, which region or which customer is slipping. That is the logic of drill-down: start from the aggregated indicator, then dig down to the actionable cause. Without that capability, you observe a problem without being able to solve it.

Finding the right reading rhythm

The most neglected question is not "which indicators?" but "how often do we look at them?". A dashboard consulted at random, whenever a worry arises, steers nothing: it reassures or it alarms, without ever establishing a habit. Conversely, a manager who refreshes the figures ten times a day mistakes daily noise for a trend and burns out on micro-reactions.

The right rhythm depends on how fast the indicator can actually move, and on how fast you can act on it.

• Every day: whatever demands an immediate reaction — available cash, stockouts, orders waiting to be processed. A two-minute glance is enough; you are only looking for the anomaly.
• Every week: routine steering — revenue against target, accounts receivable, outstanding quotes, best sellers. This is the natural rhythm of operational decision-making in an SME.
• Every month: what belongs to trends and trade-offs — margin by product family, inventory turnover, customer mix. Looking at these figures daily adds nothing and blurs the reading.

This cadence has a valuable side effect: it forces you to sort. An indicator you have never managed to place in any of these three boxes is almost always an indicator nobody needs.

From dashboard to action

Many SMEs stop at putting the tool in place and are surprised that nothing changes. It is logical: looking is not deciding. Three very simple habits make the difference between a decorative dashboard and a genuine steering instrument.

A short, regular ritual

A twenty-minute weekly slot, always on the same day, with the same screens and the same people. Regularity matters more than length: a short meeting every Monday achieves more than a long quarterly analysis. This framework also builds in comparison — last week's figures are still fresh in everyone's mind, and the gaps stand out.

One threshold, one action decided in advance

For every critical indicator, decide beforehand what will happen when it crosses its limit. Accounts receivable above the threshold: systematic follow-up the same day. Margin of a product family below its floor: price review at the next meeting. Stockout on a flagship item: emergency order with no additional approval. A decision taken calmly is always worth more than improvisation under pressure, and it avoids long discussions about what ought to be done.

One traceable decision per meeting

The best measure of maturity is not the number of screens, it is the number of decisions that follow from them. At each review, note what was decided, by whom, and by when — then check at the following review. Without that loop, the dashboard becomes an observation ritual; with it, it becomes a cycle: measure, understand, act, measure again.

The prerequisite, in two sentences

A splendid dashboard plugged into scattered, contradictory data merely stages the disorder: everything that follows assumes a single, up-to-date data source, obtained through single entry and a shared master data set. That upstream work — removing duplicates, imposing a naming convention, appointing an owner for each reference base — is a project in its own right, described step by step in our guide to collecting and making your company data reliable. If your figures are still being argued over in meetings, start there: the rest of this article would be of no use.

So we start from the point where the data is clean, and we tackle the next question, which is a different discipline altogether: what do you do with it in order to decide?

Deciding by the numbers changes the company culture

Beyond the tool, steering with dashboards instils a healthy discipline. Meetings stop revolving around opinions and impressions and start relying on shared facts. Debates become shorter and fairer because everyone is looking at the same, updated reality rather than at extracts that contradict one another.

This factual logic spreads to every function: you only reduce your inventory management mistakes or stop losing sales for want of commercial follow-up by first measuring what is happening. The dashboard thus moves the company forward one indicator at a time, shifting the debate from convictions to facts.

Swifto: dashboards ready to use

That is the Swifto philosophy: because all your operations already live in the platform, the dashboards and KPIs come built in and are fed in real time, with no separate BI project. Revenue, margin, cash, accounts receivable, inventory turnover, top products and top customers appear from the very first sale recorded.

Each function has its own view — management, sales, finance, stock, HR — and the manager can go from the overview to the detail in a single click. The figures come up from the office and from the field alike, via the mobile apps that automatically synchronize sales reps and cash registers. BI is no longer a project: it is a feature you open every morning. Discover the ERP solution for SMEs and move on from the month-end Excel file to continuous steering.

Frequently asked questions