SGBAU · Third Year B.E. Artificial Intelligence and Data Science · NEP 2020
Business Intelligence
5AD223PE1 · Elective I · Semester V · 3 credits · IE 40 + ESE 60
One of the Elective I options.
Unit 1: Decision Support Systems and Business Intelligence
7 hoursSystems and the decision-making process, the evolution of information systems, decision support systems and their development, Simon's four stages and decision-makers' strategies; BI, its components and architecture, its future and users, data, information and knowledge, mathematical models, BI architectures and ethics.
Examined in the 60-mark end-semester paper
- Decision support systems
- Simon's decision-making process
- BI architecture and components
- Modelling in business intelligence
- The business intelligence value proposition
Unit 2: The Architecture of DW and BI
7 hoursBI and DW architectures and how they relate, OLAP definitions and architectures, data models and BI tools, DSS, EIS, MIS and dashboards, OLAP versus OLTP, dimensional analysis and OLAP models, and star, snowflake and fact-constellation schemas.
Examined in the 60-mark end-semester paper
- Data warehouse schemas
- Data marts and OLAP cubes
- Dashboards and performance management
- ETL and change data capture
Unit 3: Report Authoring
7 hoursReports on relational versus multidimensional models; list, crosstab, statistics, chart, map and financial reports; grouping, sorting, filtering, calculations, conditional formatting and summary lines; drill-up, drill-down and drill-through; running and scheduling reports and output formats.
Examined in the 60-mark end-semester paper
- Querying, reporting and self-service BI
- KPIs, metrics and briefing books
Unit 4: Data Preparation
7 hoursValidating incomplete and noisy data, standardisation and feature extraction, sampling, feature selection, PCA and discretisation; univariate, bivariate and multivariate exploration — graphs, central tendency, dispersion, outliers, correlation and contingency tables.
Examined in the 60-mark end-semester paper
- Data validation and transformation
- Data reduction
- Univariate and bivariate analysis
Unit 5: Machine Learning in the BI Process
7 hoursClassification problems and their evaluation, Bayesian methods and logistic regression; partition and hierarchical clustering and evaluating clusters; association rules and the Apriori algorithm.
Examined in the 60-mark end-semester paper
- Classification in BI
- Clustering in BI
- Evaluating clusters
- Association rules
Unit 6: BI Applications
7 hoursTools for BI and the role of analytical tools — case studies of WEKA, KNIME, RapidMiner and R; data analytics, business analytics and ERP.
Examined in the 60-mark end-semester paper
- BI applications
- ERP, CRM and business intelligence
Unit contents are summarised from the official SGBAU syllabus . AiCanCode.org is not affiliated with Sant Gadge Baba Amravati University (SGBAU).