IT249 Business Intelligence
Business Intelligence notes
10 chapter notes, in syllabus order. Each starts with the key points.
Unit 1
Business Intelligence: Definitions, Systems & Strategic ValueUnit 1 of Business Intelligence introduces core concepts like BI definitions, its components (data, tools, techniques), types (descriptive, predictive, prescriptive), and how organizations use it for competitive advantage. Covers real-world applications, BI systems architecture, and key challenges in implementation.7 min readUnit 2
Decision Making & Decision Support Systems: Models, Types & ToolsUnit 2 of Business Intelligence explores how organizations make data-driven decisions, covering decision-making models (rational, bounded rationality, satisficing), decision support systems (DSS), group decision support systems (GDSS), and their applications in business analytics.10 min readUnit 3
Data Warehousing: Architecture, ETL, OLAP & Business UseUnit 3 of Business Intelligence explores data warehousing fundamentals—its architecture, ETL processes, OLAP cubes, and real-world applications in decision support. Learn how raw data transforms into actionable insights for businesses like Nabil Bank or Daraz.9 min readUnit 4
ETL Processes: Extraction, Transformation, Loading & BI PipelinesUnit 4 of Business Intelligence explores how raw data is cleaned, enriched, and moved into data warehouses—covering ETL architecture, tools, challenges, and real-world pipelines like those used by Ncell for customer analytics or Daraz for supply chain optimization.6 min readUnit 5
OLAP Cubes, Dimensions, Measures & Multidimensional AnalysisUnit 5 of Business Intelligence explores OLAP (Online Analytical Processing) architectures, multidimensional data models, cube structures, drill-down/roll-up operations, and their applications in business analytics—with real-world examples from Nepali and global companies.12 min readUnit 6
Data Mining for Business: Techniques, Applications & Real-World ImpactUnit 6 of Business Intelligence explores how organizations extract hidden patterns from data to drive decisions, covering classification, clustering, association rules, text mining, and ethical considerations—with Nepali and global case studies.5 min readUnit 7
Business Analytics & Predictive Modelling: Techniques, Tools & ApplicationsUnit 7 of Business Intelligence explores how organizations use historical data to predict trends, optimize decisions, and automate actions—covering descriptive, predictive, and prescriptive analytics, machine learning models (regression, classification, clustering), and real-world case studies from Nepalese and global 8 min readUnit 8
Data Visualization & Dashboards: Types, Tools & BI ImpactUnit 8 of Business Intelligence explores how to transform raw data into actionable insights through visual storytelling, covering dashboard design principles, visualization techniques, and real-world tools like Power BI and Tableau—essential for TU’s IT249 exam.14 min readUnit 9
Big Data & BI: Technologies, Challenges & ApplicationsUnit 9 of Business Intelligence explores how big data technologies (Hadoop, Spark, NoSQL) integrate with BI tools to solve real-world problems, covering scalability challenges, real-time analytics, and case studies from Nepali and global companies.10 min readUnit 10
BI Implementation: Strategies, Challenges & Case StudiesUnit 10 of Business Intelligence explores real-world deployment of BI systems, organizational change management, technical challenges, and success stories from Nepali and global companies—covering implementation frameworks, ROI analysis, and lessons learned from case studies like Nabil Bank’s fraud detection and Daraz’12 min read