Guide · Business intelligence
What business intelligence (BI) is, and what it gives a small company
Business intelligence (BI) is a way of bringing the numbers from the programs a company works in together in one place automatically, and showing them so that decisions are made from the numbers, not by feel. Here we explain in plain words what business intelligence means in a small company, what a dashboard and a KPI are, how a dashboard differs from an Excel report, and when a spreadsheet is entirely enough.
What business intelligence (BI) is, in plain words
BI is short for business intelligence. The software itself is also called a "BI system" or a "business analytics system". The idea is simple. Your company's numbers already exist, but they sit in different places: sales in one program, orders in another, costs in a spreadsheet. BI collects them automatically, puts them in order and shows them on one screen.
That screen is called a dashboard. A dashboard is a page with a few numbers and charts that update themselves. You open it and see how the company is doing, without anyone having prepared a report.
An example from one Monday. The owner of a trading company with an online store and a small warehouse wants to know how the week went. Without BI, someone downloads the sales from the store, the stock levels from the inventory software and the costs from the spreadsheet, and puts them together by hand. With BI, the owner opens the dashboard on their phone and sees revenue, orders by day and the items that are running out.
A dashboard or a report in Excel: the difference
Both show numbers. The difference is where the numbers come from and who collects them.
- A report made by hand in Excel Someone downloads the data, arranges it and does the sums. The report is correct at the moment it was made and goes out of date with every new sale. If another person prepares it, the numbers may come out differently.
- A dashboard (BI) The data arrives by itself from your programs and updates without anyone stepping in. Every number is calculated the same way every day, so weeks and months can be compared.
- A ready-made dashboard tool A program in which you arrange charts from your own data yourself, such as Power BI. BI is the name of the approach, not of one program.
Where the numbers come from
A dashboard does not create new data. It shows what is already being recorded in your programs, gathered in one place. So the first question is where the numbers will come from. The second is whether each program allows the data to be pulled from it automatically.
- An online store or an ordering system Revenue, number of orders and best-selling items.
- A CRM system Customers, enquiries and deals: how many new enquiries came in and how many of them became orders.
- An ERP system or inventory software Stock levels, deliveries and the movement of goods.
- Spreadsheets Whatever is kept by hand today in Excel or in Google Sheets, such as costs.
- System integrations How programs pass data to each other by themselves, with no re-typing.
What a KPI is, and which numbers belong on the dashboard
KPI stands for key performance indicator. In plain words: a number by which you judge whether the work is going well. The week's revenue is a KPI. So is the number of new enquiries.
A dashboard is not the place for everything that can be measured. It is useful when it shows the few numbers you actually make decisions from.
- Trade and online stores Revenue, number of orders, average order value, items below minimum stock.
- Services New enquiries, how many of them became deals, the team's workload.
- A restaurant Revenue by day, orders by channel, the most ordered dishes.
- In every company A comparison with last week and with the same month last year. A number with nothing to compare it to says little.
When a small company needs BI, and when Excel is enough
- Excel is enough when You work in one program and its reports answer your questions. Or you need the numbers once a month and collecting them takes minutes.
- A dashboard makes sense when Your data sits in several systems, someone regularly loses hours copying numbers, the figures from different places do not match, or you want to see them every day rather than once a month.
- It is too early when The data is not yet recorded regularly anywhere. If orders live in a notebook, the first step is to start entering them in a program or a spreadsheet. The dashboard comes after that.
What to check before you order a dashboard
- How each number is calculated Agree in writing what goes into each figure. Revenue with returned orders and revenue without them are two different numbers. Before you rely on the dashboard, compare its numbers with the ones you know.
- How often it updates That depends on the program the data comes from. Some numbers update straight away, others at a set interval.
- Whose data it is A dashboard gathers numbers from all your programs in one place. Ask where the copies are kept, who has access to the dashboard and whether you can download the reports if you stop the service.
- What drives the price The number of systems the data comes from, the number of figures and reports, and how many people have access.
How we work with business intelligence
We build custom dashboards that collect sales, orders, enquiries and costs from your systems and show them on one screen. Before the quote we check each system and tell you what can be pulled automatically. Then you see a working dashboard with your real numbers and check them against the ones you know.
We do not do bookkeeping and we do not replace your accounting software. The official statements stay with your accountant. If the reports in the program you work in are enough for you, we will tell you so on the first call.
If you are not sure whether you need a dashboard, the free 5-minute check shows where your business loses time and money, using your own numbers. The €390 audit shows whether the investment in a dashboard pays off.
- Custom business intelligence and reporting What the dashboard includes and how the work goes.
Frequently asked questions about business intelligence (BI)
What is a business intelligence (BI) system?
A system that collects the data from a company's programs, puts it in order and shows it as numbers and charts on one dashboard. That way you decide from numbers, without anyone putting a report together by hand.
What is a KPI dashboard?
A dashboard that holds the company's most important figures, such as revenue, orders and new enquiries. It is also called a management dashboard. It works best when it is short: a few numbers you look at every week.
What is report automation?
The report someone puts together by hand today starts preparing itself: the data is taken from the programs and arranged the same way every time. The result can be a dashboard or a regular report by email.
Excel or a dashboard: which should I choose?
If your data is in one program and the report takes minutes, stay with Excel. A dashboard makes sense when the numbers come from several systems, are collected by hand every week, or need to be seen by several people, each only their own part.
Can a dashboard replace accounting software?
No. A dashboard is for everyday decisions: how sales are going, what is running out, where things are held up. Bookkeeping, taxes and the official statements remain the job of the accounting software and the accountant.
Next step
Tell us which numbers you look at today and where you get them from. In a free 20-minute call we will tell you whether a dashboard makes sense, or whether the reports in your current software are enough.
See also