Business Intelligence
Subject Overview
The fourth Elective-I option, covering BI concepts, framework and infrastructure, data integration and ETL basics, multidimensional data modeling with star/snowflake schemas and business metrics, and enterprise reporting through balanced scorecards and dashboards. A 4-credit elective theory paper.
Unit-wise Syllabus
4 units — click WhatsApp below to get the full notes for each
Unit 1: BI fundamentals
Digital data types (structured, semi-structured, unstructured), OLTP and OLAP (MOLAP, ROLAP, HOLAP), BI definitions, framework, data warehousing's role in BI, BI infrastructure components, process, technology, roles and responsibilities, business applications and best practices
Unit 2: Data integration and ETL basics
Data integration concepts, needs and advantages, common data integration approaches, metadata types and sources, data quality and profiling concepts, introduction to ETL
Unit 3: Multidimensional data modeling
Data and dimension modeling, ER modeling vs multidimensional modeling, dimensions/facts/cubes/attributes/hierarchies, star and snowflake schema, business metrics and KPIs, creating cubes using Microsoft Excel
Unit 4: Enterprise reporting
The Malcolm Baldrige quality performance framework, balanced scorecard, enterprise dashboard, balanced scorecard vs dashboard, enterprise reporting using MS Access/Excel, best practices in dashboard design