SUK · Third Year B.Tech. Computer Science and Engineering · NEP 2020
Business Intelligence System
CSE3204-3 · Elective II · Semester VI · 3 credits · ISE 10 + mid-semester 30 + ESE 60
One of the Elective II options.
Unit 1: Introduction to Business Intelligence
6 hoursThe history and evolution of BI, its segments, information versus intelligence, the BI value chain, the factors of a BI system, real-time BI and BI applications.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Business intelligence: components and architecture
- Decision support systems
- The BI life cycle
Unit 2: Essentials of Business Intelligence
6 hoursCreating a BI environment; the BI landscape, types and platforms; applications in business analytics; roles and challenges; BI tools; modern and enterprise BI; information workers.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- BI applications across business functions
- BI and analytics tools: WEKA, KNIME, RapidMiner and R
- BI tools: Tableau and Power BI
Unit 3: BI Implementation
6 hoursKey drivers, KPIs and operational metrics; BI architecture and frameworks; best practices; business decision making; business analytics, web analytics and web intelligence; customer relationship management.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- KPIs and balanced scorecards
- BI and data warehouse architectures
- Developing a BI system and its success factors
Unit 4: Business and Corporate Performance Management
6 hoursDashboards and scorecards; business activity monitoring; Six Sigma; big data and BI, social networks, mobile BI and emerging trends; managerial, strategic and technical issues in BI and data warehouse design, implementation and use.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Dashboards, EIS and MIS
- Ethics in business intelligence
Unit 5: Data Warehousing
5 hoursData marts; data warehouse architecture, components and implementation options; metadata and information delivery; ETL: extraction and transformation by conditioning, scrubbing and merging.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Data warehouse concepts and architecture
- Enterprise warehouses and data marts
- ETL and the metadata repository
Unit 6: Dimensional Modelling, OLAP and Data Mining
7 hoursFacts, dimensions and measures; star and snowflake schemas; slowly changing dimensions; OLAP versus OLTP, multidimensional databases, ROLAP, MOLAP and HOLAP; data mining concepts and rules; machine learning in BI.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Star, snowflake and fact constellation schemas
- OLAP vs OLTP and data cubes
- OLAP operations and ROLAP vs MOLAP
- Data mining for BI
Unit contents are summarised from the official SUK syllabus . AiCanCode.org is not affiliated with Shivaji University, Kolhapur.