Business Intelligence Basics for BI Analysts
Business intelligence basics cover how organisations collect data from source systems, store it in a warehouse and report on it through dashboards. This unit also defines KPIs, metrics and OKRs, which are the measures a BI analyst builds reports around. It is the vocabulary every later BI topic assumes.
Stage: BI Foundations · Part of the BI Analyst roadmap · Last reviewed 19 November 2026
What to learn in Business Intelligence Basics
- Draw the path from source systems through ETL and a warehouse to a dashboard
- Distinguish a metric, a KPI and an OKR with examples
- Write a KPI definition with formula, grain, owner and refresh frequency
- Tell leading indicators from lagging indicators for a sales process
- Choose a small set of KPIs that matches a business goal
Business Intelligence Basics interview questions
What is the difference between a metric and a KPI?
A metric is any measurement, such as page views or orders. A KPI is a metric chosen because it tracks progress toward a specific business goal, with a target and an owner. All KPIs are metrics, but most metrics are not KPIs.
What is the difference between OLTP and OLAP systems?
OLTP systems handle many small transactions such as placing an order, and are optimised for fast writes and consistency. OLAP systems are built for analysis, scanning large volumes of historical data to aggregate it. BI reporting normally runs against OLAP-style stores like warehouses.
Where Business Intelligence Basics fits in the BI Analyst roadmap
Business Intelligence Basics belongs to the BI Foundations stage (beginner level), which takes about 5 hours. The business of metrics.
Other units in this stage
Back to the full BI Analyst roadmap