What Is Business Intelligence? A Beginner’s Guide
Updated · By Robert Breen
The problem
Every Monday, Priya, an operations analyst at a 40-person wholesale company, exports last week’s orders from the order system, pastes them into a spreadsheet, rebuilds three pivot tables and emails screenshots to her VP. It takes about three hours, and by Wednesday someone asks for the same numbers split a different way.
What you’ll be able to do
By the end you will know what a BI tool actually does differently, which parts of Priya’s Monday it removes, and the four building blocks (data source, dimensions, measures, dashboard) that every later lesson uses.
BI in one sentence
Business intelligence is the practice of connecting to your business data once, defining how it should be summarized, and publishing charts that update themselves when the data changes. The tool does the repetitive summarizing; people do the interpreting.
A spreadsheet can do the summarizing too. The difference is what happens next week. In a spreadsheet you redo the copy, paste and pivot. In a BI tool the data source is connected, the dashboard is already built, and refreshing it pulls in the new rows.
Priya’s Monday, before and after
| Step | Spreadsheet (before) | BI tool (after) |
|---|---|---|
| Get the data | Export a CSV, paste into a tab | Connected once; refresh pulls new rows |
| Summarize | Rebuild 3 pivot tables | Saved charts recalculate automatically |
| Share | Screenshots in an email | One dashboard link everyone opens |
| Follow-up question | "Can you split it by product?" means another hour | Viewer clicks a filter and splits it themselves |
| Time each week | About 3 hours | About 10 minutes to review |
The four building blocks
Data source: where the rows come from: a spreadsheet, a CSV export or a database. Priya’s is the weekly orders export, about 1,200 rows with order date, region, product, quantity and revenue.
Dimensions: the columns you group or slice by, such as region or product. Measures: the numbers you add up or average, such as revenue or quantity. Lesson 2, Dimensions vs measures, covers this split, because almost every beginner mistake in BI comes from mixing them up.
Dashboard: several charts on one screen with shared filters. Priya’s ends up with three: revenue by week, revenue by region and the top 10 products.
What BI does not do for you
A BI tool will happily chart bad data. If the export double-counts cancelled orders, the dashboard double-counts them too, only faster. Before you build anything, check three things in the raw rows: one row means one thing (one order line, not a mix of orders and totals), dates are real dates, and numbers have no text mixed in, like "1,200 USD".
BI also does not decide what matters. Agree on the question first ("Are we on track for the quarter, by region?") and the right charts follow. A dashboard built without a question becomes a wall of charts nobody opens.
Popular BI tools
Tableau, Microsoft Power BI, Looker Studio (free, from Google) and Qlik are the best known. They share the same ideas, so what you learn here transfers. This course uses Tableau Public because it is free and runs in a browser or as a desktop app. The catch: anything you save to Tableau Public is public, so practice with sample data, never real customer data.
Check your understanding
What is the main thing a BI tool saves Priya each week?
Show the answer
Rebuilding the same summaries from a fresh export. The data source and charts are set up once, so refreshing replaces the copy, paste and pivot routine. Deciding what matters and fixing bad data are still people jobs.
In Priya’s orders data, which column is a measure?
Show the answer
Revenue. Revenue is a number you add up. Region and product are labels you group by, so they are dimensions.
Why practice in Tableau Public with sample data only?
Show the answer
Everything saved there is public. Tableau Public publishes what you save to the public web, so keep real customer or company data out of it.
Terms in this lesson
Questions this lesson answers
- 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…
Do this with AI
Want a quick first look before you build a dashboard? The free Stepthrough lesson on analyzing a spreadsheet with ChatGPT shows how to ask AI for a first summary of the same kind of export.
Open the free AI lesson