PAHSU Final CSE syllabus

PAHSU · Final Year B.Tech. Computer Science and Engineering · NEP 2020

Business Intelligence

CSEPEC-04B · Programme Elective IV · Semester VII · 4 credits · End-semester 100 only

One of the Programme Elective IV options. Programme Elective IV: examined by a 100-mark end-semester exam only.

  1. Unit 1: Introduction to Business Intelligence

    8 hours

    BI concepts and evolution; BI architecture and components; BI applications; BI versus business analytics.

    Examined in the 100-mark end-semester paper

    • Business intelligence: components and architecture
    • BI applications across business functions
    • The BI life cycle
    • BI versus data warehousing and data mining
  2. Unit 2: Data Warehousing

    7 hours

    Data warehouse concepts and architecture; the ETL process; dimensional modelling; star and snowflake schemas.

    Examined in the 100-mark end-semester paper

  3. Unit 3: OLAP

    8 hours

    OLAP concepts and operations; MOLAP, ROLAP and HOLAP; OLAP versus OLTP; OLAP tools.

    Examined in the 100-mark end-semester paper

    • OLAP vs OLTP and data cubes
    • OLAP operations and ROLAP vs MOLAP
  4. Unit 4: Data Mining

    8 hours

    Data mining concepts; preprocessing; classification, clustering and association rule mining.

    Examined in the 100-mark end-semester paper

    • Data mining for BI
    • Data validation and transformation
    • Classification for BI: Bayesian methods and logistic regression
    • Clustering for BI
    • Association rules and Apriori
  5. Unit 5: Business Analytics and BI Tools

    7 hours

    Types of business analytics; dashboards and KPIs; BI tools such as Power BI and Tableau; future trends.

    Examined in the 100-mark end-semester paper

    • Predictive, descriptive and prescriptive analytics
    • Dashboards, EIS and MIS
    • KPIs and balanced scorecards
    • BI tools: Tableau and Power BI

Unit contents are summarised from the official PAHSU syllabus . AiCanCode.org is not affiliated with Punyashlok Ahilyadevi Holkar Solapur University (PAHSU).