Learning Objectives
By the end of this chapter, you will be able to:
- Define Business Intelligence (BI).
- Describe the purpose of BI and the BI process.
- Identify the key technologies and tools used in BI.
- Explain KPIs and how dashboards support managers.
- Discuss the benefits and challenges of BI.
What is Business Intelligence (BI)?
Business Intelligence (BI) is a broad term that refers to the technologies, applications, and practices for the collection, integration, analysis, and presentation of business information. The purpose of BI is to support better business decision-making.
BI systems take large amounts of raw data and turn it into meaningful, actionable information. This is often presented to business users in the form of reports, dashboards, and data visualizations.
BI mainly answers questions about the past and present: What happened? Where? Why? More advanced analytics extends this to What will happen? (prediction).
The BI Process
flowchart LR
S[Source systems: POS, accounting, CRM, website] --> E[ETL: extract, clean, combine]
E --> W[(Data warehouse)]
W --> A[Analysis: queries, OLAP]
A --> D[Reports and dashboards]
D --> M[Managers make decisions]
Key BI Technologies and Tools
- Data Warehouses: BI systems rely on data warehouses to provide a central repository of clean, integrated, and historical data for analysis.
- ETL (Extract, Transform, Load): The process used to get data from various source systems into the data warehouse.
- OLAP (Online Analytical Processing): Lets users view data from different angles, for example sales by product, by month, and by branch, and drill down from yearly totals to daily figures.
- Reporting and Querying Tools: Allow users to ask questions of their data and create reports.
- Data Visualization and Dashboards: Tools like Tableau and Power BI are used to create interactive charts, graphs, and dashboards that allow users to explore the data visually.
Other common tools include Looker Studio (free, from Google) and Excel with PivotTables for smaller businesses.
KPIs and Dashboards
A Key Performance Indicator (KPI) is a measurable value that shows how well a business is achieving its goals. A dashboard displays the most important KPIs on one screen, usually with charts and color alerts.
| Department | Example KPIs |
|---|---|
| Sales | Monthly revenue, sales by branch, average bill value |
| Marketing | Website visitors, leads, cost per customer |
| Finance | Profit margin, overdue receivables, cash balance |
| Operations | Stock-out items, delivery time, order accuracy |
| HR | Staff turnover, absenteeism |
BI vs Operational Reporting
| Operational reporting (OLTP systems) | Business intelligence |
|---|---|
| Shows current transactions (today’s bills) | Analyzes trends over months or years |
| Used by front-line staff | Used by managers and analysts |
| Data from one system | Combines data from many systems |
| Fixed, routine reports | Interactive exploration, drill-down, and comparison |
Business Scenario
A supermarket chain with branches in Kathmandu, Pokhara, and Butwal records every sale in its POS system. Each night, ETL moves the sales into a data warehouse. The next morning, the manager’s Power BI dashboard shows that cooking-oil sales in Pokhara are falling while they rise in Butwal. Drilling down reveals a competitor’s discount in Pokhara, so the manager launches a matching offer there.
Banks in Nepal similarly use BI dashboards to track deposits, loans, and overdue accounts by branch and province.
Benefits and Challenges
Benefits
- Faster, evidence-based decisions.
- One version of the truth across departments.
- Early warning of problems (falling sales, rising costs).
- Identification of profitable customers, products, and regions.
Challenges
- Poor data quality leads to misleading dashboards.
- Building a data warehouse and ETL takes time, skills, and money.
- Managers need training to interpret data correctly.
- Too many KPIs can overwhelm instead of inform.
Summary
Business Intelligence is the process of turning raw data into actionable insights that can guide business decisions. Data flows from source systems through ETL into a data warehouse, is analyzed with queries and OLAP, and is presented through reports and dashboards that track KPIs. BI improves decisions and performance, but it depends on clean data, investment, and managers who can interpret what they see.
Key Takeaways
- BI is the process of analyzing data to support better business decisions.
- BI systems turn raw data into actionable information.
- The BI process: source systems → ETL → data warehouse → analysis → dashboards → decisions.
- Key BI tools include data warehouses, OLAP, and visualization tools such as Power BI and Tableau.
- KPIs on dashboards let managers monitor performance at a glance.
Discussion Questions
- What is the difference between raw data and “actionable information”?
- How can a BI dashboard help a sales manager?
- Why is a data warehouse an important foundation for a BI system?
Exam-Style Questions
Short answer
- Define Business Intelligence. Name two BI tools.
- What is ETL? Why is it needed?
- What is a KPI? Give two examples for a retail business.
Long answer
- Explain the components and process of a BI system with a suitable diagram.
- How can Business Intelligence help a Nepali bank or retail chain make better decisions? Discuss its benefits and challenges.
