AL-801 Business Intelligence - May 2026 Question Paper

Under each question, How to answer lists the points an answer should cover, outlined by CampusPrep from the syllabus. Check the details against your textbook.

1. 7 Marks
   aExplain Business Intelligence architecture and examine the advantages and limitations of Business Intelligence architectures in enterprise systems.
   How to answer

   • Definition and layers of BI architecture (data sources, ETL, warehouse/marts, OLAP, presentation).
   • Types of BI architectures in enterprise systems.
   • Advantages: integrated view, decision support, performance monitoring.
   • Limitations: cost, complexity, data quality and governance issues.
   • Diagram of BI architecture.
2. 7 Marks
   bDescribe the transformation process from data to information and knowledge with suitable examples and applications.
   How to answer

   • Define data, information and knowledge in DIKW hierarchy.
   • Explain transformation steps: collection, cleaning, integration, analysis, interpretation.
   • Give suitable examples e.g., sales transactions to reports to decisions.
   • Mention applications in business domains.
   • Diagram of DIKW pyramid.
3. 7 Marks
   aDescribe ad hoc querying and interactive reporting techniques with suitable examples and describe its application.
   How to answer

   • Define ad hoc querying and interactive reporting.
   • Explain techniques and tools with examples.
   • Steps for creating ad hoc queries and drill-down/roll-up reports.
   • Applications in sales, finance and operations.
4. 7 Marks
   bExplain alerts, notifications and visualization techniques in Business Intelligence systems and discuss their significance in decision support systems.
   How to answer

   • Define alerts, notifications and visualization in BI.
   • Types of visualization techniques: charts, dashboards, gauges.
   • Working of proactive alerting and event notification.
   • Significance for monitoring KPIs and decision support systems.
5. 7 Marks
   aDefine efficiency measures in Business Intelligence systems and the role of analytical efficiency models in organizational management systems.
   How to answer

   • Define efficiency measures in BI context.
   • Types of efficiency: operational, analytical, organizational.
   • Role of analytical efficiency models in performance measurement.
   • Use in organizational management systems with examples.
6. 7 Marks
   bAnalyze the architecture and working principles of the CCR model with suitable examples and applications.
   How to answer

   • Overview of CCR model concept and components.
   • Architecture diagram and working principles.
   • Mathematical/analytical basis with example calculation.
   • Examples and business applications.
7. 7 Marks
   aDescribe inventory optimization, transportation planning and supply chain management models in details and show there use cases.
   How to answer

   • Define inventory optimization, transportation planning and SCM models.
   • Key components and modelling approaches.
   • BI role in demand forecasting and logistics optimization.
   • Use cases with examples.
8. 7 Marks
   bExamine the role of predictive analytics and data driven decision making in modern business systems.
   How to answer

   • Define predictive analytics and data-driven decision making.
   • Techniques: regression, classification, forecasting.
   • Role in modern business: risk reduction, personalization, planning.
   • Examples from retail, finance, manufacturing.
9. 7 Marks
   aDescribe natural language processing, sentiment analysis and text mining techniques with suitable examples and applications.
   How to answer

   • Define NLP, sentiment analysis and text mining.
   • Explain pipeline: preprocessing, feature extraction, classification.
   • Examples: opinion mining, document clustering.
   • Applications in customer feedback and social media analytics.
10. 7 Marks
    bCritically examine the advantages and limitations of emerging Business Intelligence technologies in organizational analytics environments.
    How to answer

    • List emerging BI technologies: AI, cloud BI, self-service BI, IoT.
    • Advantages: real-time insights, scalability, democratization.
    • Limitations: security, cost, skill gap, data governance.
    • Critical evaluation in organizational analytics environment.
11. 7 Marks
    aExplain pattern matching and cluster analysis in Business Intelligence systems and discuss their significance in analytical environments.
    How to answer

    • Define pattern matching and cluster analysis.
    • Explain algorithms e.g., k-means, hierarchical clustering.
    • Significance for segmentation and anomaly detection.
    • Examples in analytical environments.
12. 7 Marks
    bDescribe real world applications of Business Intelligence in marketing, logistics and production systems with examples.
    How to answer

    • Overview of BI role in marketing, logistics and production.
    • Marketing: campaign analysis, customer segmentation.
    • Logistics: route optimization, inventory tracking.
    • Production: quality control, predictive maintenance with examples.
13. 7 Marks
    aExplain effective and timely decisions in Business Intelligence and discuss their significance in organizational management systems.
    How to answer

    • Define effective and timely decisions in BI context.
    • BI capabilities enabling speed and accuracy: dashboards, alerts.
    • Significance for organizational management and competitiveness.
    • Examples of improved decision outcomes.
14. 7 Marks
    bAnalyze the roles of operational users, tactical users and strategic users in Business Intelligence systems with suitable examples.
    How to answer

    • Define operational, tactical and strategic users.
    • Information needs and BI tools for each level.
    • Roles with suitable examples e.g., shop-floor vs middle vs top management.
    • Significance for hierarchical decision making.
15. 14 Marks
    Write short notes on any **two** of the following:

    1. a)Dashboards, Scorecards and Geographic Visualization
    2. b)Marketing Models and Production Models in Business Intelligence
    3. c)BI Search, Text Analytics and Future Beyond Technology
    How to answer

    • Select any two topics for short notes.
    • Define key terms and components for each chosen topic.
    • Explain working with examples and diagrams.
    • Mention business applications and benefits.