iPAS Exam Preparation Notes - Operational Intelligence Analyst (Entry Level)
TLDR
- Operational Intelligence (OI): Integrates Business Intelligence (BI) into enterprise dynamic operational processes to support real-time decision-making.
- Project Management: The PERT expected time formula is
; the Critical Path Method (CPM) determines the shortest project duration. - Data Processing: ETL (Extract, Transform, Load) is suitable for traditional warehouses; ELT (Extract, Load, Transform) is suitable for cloud data lakehouses.
- Data Modeling: Star Schema allows fast queries but contains redundancy; Snowflake Schema reduces redundancy but requires more JOINs.
- Statistical Concepts: If the p-value is less than the significance level (e.g., 0.05), the null hypothesis is rejected; for skewed data, the median should be prioritized.
- Machine Learning: Supervised learning handles labeled data (classification/regression); unsupervised learning handles unlabeled data (clustering/association).
- Strategic Analysis: PESTEL analyzes the external environment; Porter's Five Forces analyzes industry competition; SWOT/TOWS are used for strategy formulation.
- Information Systems: ERP integrates internal resources; MES connects to the production floor; CRM manages customer relationships; SCM connects the supply chain.
- Change Management: BPR seeks radical process redesign; Lewin's three-stage model (unfreeze, change, refreeze) is key to successful change.
Fundamentals of Operational Intelligence
Operational Intelligence vs. Business Intelligence
Business Intelligence (BI) focuses on the integration and presentation of historical data; Operational Intelligence embeds analysis into enterprise dynamic systems, emphasizing real-time information flow and multi-dimensional decision-making.
KPI and Balanced Scorecard
The Balanced Scorecard (BSC) translates strategy into concrete metrics through four perspectives: financial, customer, internal processes, and learning and growth. The causal structure among these four is called a "Strategy Map."
Project Planning Tools
- PERT: Suitable when task duration is uncertain; calculates expected time using a weighted average.
- CPM (Critical Path Method): Identifies the longest activity path in a project; activities on this path have zero float and directly affect the total project duration.
Basic Data Analysis
Data Quality and Missing Value Handling
Data quality includes accuracy, reliability, consistency, completeness, and relevance.
- Handling Missing Values: If the missing ratio is extremely low, the entire row can be deleted; for numerical data, mean or median imputation can be used; for time-series data, linear interpolation is recommended to preserve trends.
Data Storage Architecture
- Data Warehouse: Uses a fixed schema to serve analytical needs (OLAP).
- Data Lake: Stores data in its raw format, defining the schema only during analysis (Schema-on-Read).
- Data Lakehouse: Combines the advantages of both, supporting ACID transactions and diverse formats.
Five OLAP Operations
- Roll-up: Aggregating from fine-grained to coarse-grained levels.
- Drill-down: Expanding from coarse-grained to fine-grained levels.
- Slice: Fixing a single dimension.
- Dice: Fixing multiple dimensions.
- Pivot: Adjusting the perspective of presentation.
Data Visualization Pitfalls
- Truncated Y-axis: Exaggerates small differences; when comparing absolute quantities, the Y-axis should start from zero.
- 3D Pie Charts: Perspective effects lead to distorted interpretation of proportions.
- Dual Y-axis: Easily implies non-existent correlations; a single baseline comparison should be used instead.
Statistical Testing
- t-test: Compares differences in means.
- F-test: Compares differences in variances (ANOVA also uses F-values).
- Chi-square test: Tests the association between categorical variables.
Fundamentals of Business Management
Competitive Strategy Analysis
- Porter's Five Forces: Evaluates suppliers, customers, potential entrants, substitutes, and existing industry rivalry to determine industry profitability.
- BCG Matrix: Classifies business units into Stars, Cash Cows, Question Marks, and Dogs based on market growth rate and market share.
- Ansoff Matrix: Plans market penetration, market development, product development, or diversification strategies through combinations of new and existing products and markets.
Marketing Mix (4Ps and 4Cs)
Marketing strategy should shift from the enterprise perspective of 4Ps (Product, Price, Place, Promotion) to the customer perspective of 4Cs (Customer value, Cost, Convenience, Communication).
Fundamentals of Digital Enterprise Information Tools
Information System Levels
- TPS (Operational Level): Processes daily transactions.
- MIS (Management Level): Generates routine reports.
- DSS (Management Level): Supports semi-structured decision-making.
- EIS (Strategic Level): Supports high-level strategic decision-making.
Manufacturing Information Systems
- ERP: Integrates core processes such as finance, production, and sales.
- MES: Connects production scheduling with shop-floor equipment, reporting progress in real-time.
- PLM: Manages engineering data from product design to retirement.
Customer Relationship Management (CRM)
- Operational: Automates front-line processes.
- Analytical: Performs customer segmentation and behavior prediction.
- Collaborative: Integrates multi-channel interactions.
- Customer Lifetime Value (LTV): Measures the total profit a customer brings during their tenure; the formula is "Monthly Marginal Profit × Expected Tenure in Months."
Business Process Reengineering (BPR)
BPR emphasizes fundamental and radical redesign of processes to achieve significant performance improvements. During the change process, Lewin's three-stage model (unfreeze, change, refreeze) is used to reduce organizational resistance and institutionalize new practices.
Change Log:
- 2026-06-11 Initial document created.