What is business intelligence (BI)?
What business intelligence means, how it differs from plain reporting, the usual stack, and why the semantic layer decides if dashboards can be trusted.
Business intelligence (BI) is the collective name for the tools and methods that turn scattered company data into decisions. In practice, for most companies BI means visualising data from the ERP and other systems on a dashboard.
Business intelligence is not the same as reporting
Reporting describes the past: what did we sell last month, how many invoices were issued. BI adds comparison, breakdown and tracking on top — which item group lost margin, which rep is behind target in which region, how this quarter compares with the last. Same data, different question.
A typical BI stack
- Source systems — ERP, CRM, e-commerce, production tracking
- Data transfer (ETL/ELT) — the layer that extracts, transforms and moves
- Data warehouse — one consolidated, consistent source
- Semantic layer — a single definition per measure: what is net sales, how is margin computed
- Visualisation — Power BI, Tableau, Qlik, Looker, Excel
The step most often skipped: the semantic layer
Most BI projects start straight with the visualisation tool. It connects to the ERP, a few dashboards appear, and everyone is happy in week one. The problem surfaces in month six: the same question has two different answers on two dashboards. The cause is usually the same — the two dashboards computed “net sales” differently; one subtracted returns, the other did not.
If the definition of a measure does not live in exactly one place, the numbers will diverge no matter how good the tool is. That is why a semantic layer is not a luxury but a precondition for trustworthy BI.
What to watch out for
- Dashboards connected straight to the ERP can slow the production database
- If every new question spawns a new query, you accumulate dozens of near-duplicate reports
- If a dashboard figure disagrees with accounting, the project loses trust in the first meeting
- As user count grows, “who may see which company's data” becomes a real problem
Where Floemdata sits
Floemdata is not a BI tool; it is the layer underneath. It extracts data from the source system, moves it into a warehouse, computes measures from a single definition catalogue, and reconciles the result against the source. Whichever BI tool you use — Power BI, Tableau, Qlik or Excel — it reads from there.