What is business intelligence (BI)?
Quick answer
Business intelligence (BI) is the set of tools and habits a company uses to turn its everyday data (orders, invoices, tickets, ad spend) into reports and dashboards that update themselves, so people can answer "how are we doing?" without rebuilding a spreadsheet each time.
Last updated
Updated · By Robert Breen
Why it matters
Most companies already record what happens: every sale, refund and support ticket lands in some system. What they lack is a quick, trusted view of it. Without BI, that view is a person exporting, pasting and pivoting by hand, which is slow, error-prone and only as fresh as the last export.
BI makes the view repeatable. You connect the data once, agree how each number is calculated (what counts as "revenue", whether refunds come out), and publish a dashboard. Everyone sees the same number, defined the same way, which ends the meeting where three people bring three different totals.
A worked example
A regional furniture retailer has 14 stores and a point-of-sale system that exports daily sales. The finance lead used to spend Friday afternoons building a sales-by-store spreadsheet. With a BI tool, the export lands in a shared folder, Tableau refreshes from it overnight, and a dashboard shows revenue by store, by week, against the same week last year.
In the first week, the dashboard shows store 9 down 22% year over year. The spreadsheet never showed that, because it only had this year’s numbers. That comparison, which nobody had time to build by hand, is the kind of thing BI is for.
Often confused with
BI vs data analytics
BI mostly answers "what happened and where?" with ongoing reports. Data analytics is broader and includes one-off investigations ("why did store 9 drop?") and forecasting. In practice the words overlap, and BI tools are often where analysis starts.
BI vs a spreadsheet
A spreadsheet can make the same chart once. BI keeps it connected to the data, so next week’s version needs a refresh, not a rebuild, and viewers can filter it themselves.
BI vs AI
BI shows numbers you define. AI tools can now draft summaries of those numbers or answer questions in plain English, but someone still has to define the measures. See artificial intelligence in the AI glossary.
Tips
- Start with one recurring question someone asks every week. Build that dashboard first.
- Write down how each number is defined (for example, "revenue excludes refunds and tax") and show it on the dashboard.
- Prefer a few charts people check daily over twenty charts nobody opens.
Related terms
Learn it in a free lesson
- What Is Business Intelligence? A Beginner’s Guide (about 8 minutes)
Questions about it
- Is Tableau free?: Yes, for learning: Tableau has free editions, but each has a catch. What Tableau Public, Desktop Public Edition and Free Edition can and…
- What does a BI analyst do?: A BI analyst turns business questions into trusted numbers and dashboards. What the job involves day to day, the skills it needs and how…
Related in the AI glossary
Frequently asked questions
- What does a BI analyst do?
- They connect business data, define the measures (what counts as revenue, churn and so on), build dashboards and reports, and help managers read them. Much of the job is checking that the numbers are right.
- Which BI tool should a beginner learn?
- Tableau and Power BI are the most requested in job posts. Tableau Public is free and is a good place to learn the ideas, and they carry over to Power BI and Looker Studio.
- Do I need SQL for business intelligence?
- Not to start. You can build useful dashboards from spreadsheets and CSV files. SQL helps later, when your data lives in a database.
All business intelligence terms, A to Z · Free business intelligence lessons