Overview of Business Intelligence, Decision Support & Value Chain
Idea in plain words
Business Intelligence (BI): Comprehensive umbrella term encompassing architectures, applications, data warehouses, and query tools to support strategic business decisions.
Exam tip
High-yield exam topic (High).
Explanation
Modern enterprises generate massive transaction logs across ERP, CRM, and web platforms. OLTP databases are optimized for fast transaction processing and consistency (ACID), making them unsuitable for complex analytical queries that scan millions of historical rows. BI systems extract data from operational sources, transform it into unified dimensions and facts, and load it into analytical repositories. Executives utilize interactive dashboards to track Key Performance Indicators (KPIs) and drive data-backed commercial decisions.
Key points
- Decision Support Systems (DSS): Interactive computer-based systems that assist decision-makers in utilizing data and models to solve semi-structured problems.
- Operational vs Analytical Systems: OLTP (high volume, granular, normalized, transactional) vs OLAP (historical, consolidated, denormalized, analytical).
- BI Value Chain: Data Acquisition -> Data Storage & Processing -> Analytics & Mining -> Business Insight & Strategic Action.
- Four levels of analytics: Descriptive (What happened?), Diagnostic (Why did it happen?), Predictive (What will happen?), Prescriptive (How can we make it happen?).
Example
Example
A retail bank uses OLTP to execute ATM fund transfers in milliseconds, while using an OLAP data warehouse to analyze 5-year loan default trends across demographic regions.
Code examples
/*
OLTP vs OLAP Architecture Comparison:
Attribute | OLTP (Operational) | OLAP (Analytical / BI)
Primary Use | Daily day-to-day business| Decision support, strategic analytics
Data Schema | Highly normalized (3NF) | Denormalized (Star / Snowflake)
Queries | Fast simple reads/writes | Complex aggregate analytical scans
Time Horizon | Real-time / Current | Multi-year historical snapshots
*/
Exam questions
- [8 Marks] Differentiate between OLTP and OLAP systems across schema design, query patterns, and business objectives.
- [6 Marks] Explain the four levels of analytics (Descriptive, Diagnostic, Predictive, Prescriptive) with relevant business scenarios.