SPPU · Final Year Computer Engineering · 2019 Course (Revised)
Business Intelligence
410253C · Elective VI · Semester VIII · 3 credits · In-semester 30 + end-semester 70
One of the Elective VI options.
Unit 1: Introduction to Decision Support Systems and Business Intelligence
7 hoursSystems, the decision-making process, evolution of information systems, DSS and its development, Simon's four stages; BI components and architecture, data, information and knowledge, mathematical models, ethics.
Marks: 15 in the in-semester exam
- Decision support systems
- Simon's decision-making process
- Business intelligence: components and architecture
Unit 2: The Architecture of DW and BI
7 hoursBI and DW architectures; OLAP and its architectures; DSS, EIS, MIS and dashboards; OLAP vs OLTP, cubes, drill-down and roll-up, slice and dice; ROLAP vs MOLAP; star, snowflake and fact constellation schemas.
Marks: 15 in the in-semester exam
- BI and data warehouse architectures
- OLAP vs OLTP and data cubes
- OLAP operations and ROLAP vs MOLAP
- Dashboards, EIS and MIS
- Star, snowflake and fact constellation schemas
Unit 3: Reporting Authoring
7 hoursRelational vs multidimensional reports; list, crosstab, chart, map and financial reports; grouping, sorting, filtering, calculations, conditional formatting, summaries; drill-through; scheduling and output formats.
Marks: 17–18 in the end-semester exam
- Building BI reports
- Report features: grouping, filtering and calculations
- Drill-through, scheduling and report output
Unit 4: Data Preparation
7 hoursValidation of incomplete and noisy data; transformation and standardisation; sampling, feature selection, PCA, discretisation; univariate, bivariate and multivariate exploration.
Marks: 17–18 in the end-semester exam
- Data validation and transformation
- Data reduction: sampling, feature selection and PCA
- Univariate analysis
- Bivariate and multivariate analysis
Unit 5: Impact of Machine Learning in Business Intelligence Process
7 hoursClassification and its evaluation, Bayesian methods, logistic regression; partition and hierarchical clustering and their evaluation; association rules and Apriori.
Marks: 17–18 in the end-semester exam
- Classification for BI: Bayesian methods and logistic regression
- Clustering for BI
- Association rules and Apriori
Unit 6: BI Applications
7 hoursBI tools: WEKA, KNIME, RapidMiner and R; data and business analytics; ERP; BI in operations, inventory, HR, CRM, marketing, logistics, finance, banking, telecom and sales.
Marks: 17–18 in the end-semester exam
- BI and analytics tools: WEKA, KNIME, RapidMiner and R
- BI applications across business functions
Unit contents are summarised from the official SPPU syllabus . AiCanCode.org is not affiliated with Savitribai Phule Pune University.