SGBAU TY AI & DS syllabus

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.

All notes for this subject
  1. Unit 1: Decision Support Systems and Business Intelligence

    7 hours

    Systems 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
  2. Unit 2: The Architecture of DW and BI

    7 hours

    BI 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
  3. Unit 3: Report Authoring

    7 hours

    Reports 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
  4. Unit 4: Data Preparation

    7 hours

    Validating 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
  5. Unit 5: Machine Learning in the BI Process

    7 hours

    Classification 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
  6. Unit 6: BI Applications

    7 hours

    Tools 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).