SUK TY CSE (AI&DS) syllabus

SUK · Third Year B.Tech. Computer Science and Engineering (Artificial Intelligence and Data Science) · NEP 2020

Business Intelligence System

AI&DS3204 · Elective II · Semester VI · 3 credits · ISE 10 + mid-semester 30 + ESE 60

One of the Elective II options.

  1. Unit 1: Introduction to Business Intelligence

    5 hours

    Leveraging data and knowledge; BI components, dimensions and the information hierarchy; BI and business analytics; the BI life cycle; data issues and data quality for BI.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • BI architecture and components
    • The business intelligence value proposition
    • Data quality and validation
  2. Unit 2: BI Implementation

    7 hours

    Key drivers, KPIs and operational metrics; BI architectures and best practices; business decision making; business analytics, web analytics and intelligence, CRM.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • KPIs, metrics and briefing books
    • Strategic, tactical and departmental BI
    • Decision support systems
    • ERP, CRM and business intelligence
  3. Unit 3: Business and Corporate Performance Management

    6 hours

    Dashboards and scorecards, business activity monitoring and Six Sigma; big data, social networks, mobile BI and emerging trends; managerial, strategic and technical issues of BI and data warehouses.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Dashboards and performance management
    • Mobile and cloud BI
  4. Unit 4: Data Warehousing

    6 hours

    Data marts and warehouse architecture, components and implementation options; metadata and information delivery; ETL: extraction, transformation (conditioning, scrubbing, merging), loading, staging and data quality.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Data warehouse architecture
    • Data marts and OLAP cubes
    • ETL and change data capture
  5. Unit 5: Dimensional Modelling and OLAP

    6 hours

    Facts, dimensions and measures; star, snowflake and fact-constellation schemas and slowly changing dimensions; OLAP versus OLTP, multidimensional databases, ROLAP, MOLAP and HOLAP.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Data warehouse schemas
    • Fact and dimension tables, factless facts and granularity
    • OLTP versus the data warehouse
    • ROLAP, MOLAP and HOLAP
  6. Unit 6: Business Analytics and Data Mining

    6 hours

    Descriptive, diagnostic, predictive and prescriptive analytics; data-mining concepts and tasks; classification, clustering, association rules and time series.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Types and phases of data analytics
    • Classification in BI
    • Clustering in BI
    • Association rules

Unit contents are summarised from the official SUK syllabus . AiCanCode.org is not affiliated with Shivaji University, Kolhapur.