Chp Flashcards
(20 cards)
What is Business Intelligence (BI)?
A technology-driven process for analyzing data and presenting actionable information.
What are the main components of BI?
Data warehouse, Business Analytics, BPM (Performance Management), and UI (Dashboards).
How does BI differ from ERP?
BI is strategic and analytical (OLAP); ERP is operational and transactional (OLTP).
Outline the BI architecture flow.
Input → Data Warehouse → BI Tools (Analytics) → Output (Dashboards/Reports)
Brief history of BI evolution?
1970s MIS → 1990s BI term introduced → Now: real-time BI with AI.
What is a Decision Support System (DSS)?
A system that helps in complex decision-making using data, models, and rules.
List the types of DSS.
Data-driven, Model-driven, Knowledge-driven, Document-driven, Communication-driven.
What does SITN stand for in data warehouses?
Subject-oriented, Integrated, Time-variant, Non-volatile.
What are the stages in the ETL process?
Extract, Transform, Load.
Difference between DW and traditional DB?
DW holds historical data for OLAP; traditional DB supports daily OLTP.
What is OLTP?
Online Transaction Processing - fast, real-time, small transactions (e.g., ERP, POS).
What is OLAP?
Online Analytical Processing - analyzes large historical data sets (e.g., dashboards).
Key differences between OLTP and OLAP?
OLTP: Normalized, live updates. OLAP: Denormalized, deep analysis.
Name 4 OLAP operations.
Drill-down, Roll-up, Slice, Dice (plus Pivot, Drill-through, Drill-across).
Give an example of 3D OLAP model.
Year × Region × Product.
What are the four perspectives of a Balanced Scorecard?
Financial, Customer, Internal Process, Learning & Growth.
Types of report layouts?
Tabular, Matrix, Chart, Gauge.
What is the purpose of dashboards?
Real-time KPI monitoring.
Types of dashboards?
Enterprise, Divisional, Customer Support.
Reporting best practices?
Clarity, Brevity, Correctness, Completeness.
