SPPU BE Computer syllabus

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.

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

    7 hours

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

    7 hours

    BI 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

  3. Unit 3: Reporting Authoring

    7 hours

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

    7 hours

    Validation 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
  5. Unit 5: Impact of Machine Learning in Business Intelligence Process

    7 hours

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

    7 hours

    BI 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.