Skip to content
EndsemNov 20252019 patternBE Comp

Business Intelligence SPPU Endsem Question Paper Nov 2025

All 8 questions from this SPPU endsem paper, as printed. Read them here or open the PDF.

Open the PDFMost repeated Business Intelligence questions
Subject code
410253 C
Pattern
2019 pattern
Exam
Endsem
Session
Nov 2025
Max. marks
70
Time
2½ Hours
Semester
VIII
Paper code
[6584]-89

Printed for: B. E. (Computer Engineering)

Instructions to the candidates

  1. Attempt Q1 or Q2, Q3 or Q4, Q5 or Q6, Q7 or Q8.
  2. Figures to the right side indicate full marks.
  3. Neat diagrams must be drawn wherever necessary.
  4. Assume suitable data, if necessary.

Questions

  1. Q1

    1. a)

      State the different types of reports with their applications.

      Also asked:May 2025 ·Nov 2023 ·May 2023

      [6]
    2. b)

      Explain the multidimentional data model with example

      [6]
    3. c)

      State the difference between relational and multidimentional data model.

      Also asked:Nov 2023 ·May 2023

      [6]

  2. Q2

    1. a)

      Suggest the use of Data grouping & Sorting, Filtering Reports.

      Also asked:Nov 2024 ·May 2024 ·Nov 2023

      [6]
    2. b)

      Explain the Relational data model with example.

      Also asked:Nov 2023 ·May 2023

      [6]
    3. c)

      Explain the detail Drill up and Drill Down.

      Also asked:Nov 2023 ·May 2023

      [6]

  3. Q3

    1. a)

      Explain data reduction in detail with example.

      [7]
    2. b)

      What is data Transformation? Explain Data transformation Process in details.

      Also asked:Nov 2023

      [5]
    3. c)

      Explain data validation, incompleteness, noise,inconsistency of quality of input data.

      Also asked:Nov 2023 ·May 2023

      [5]

  4. Q4

    1. a)

      What is Contingency Table? What is Marginal Distribution? Justify with suitable example.

      Also asked:Nov 2023

      [7]
    2. b)

      Write short notes on data discretization.

      [5]
    3. c)

      Explain the following Data Reduction technique:Sampling, Feature selection, Principal components analysis. 2

      Also asked:Nov 2023

      [5]

  5. Q5

    1. a)

      What is logistic regression? Discuss the types of logistic regression.

      Also asked:Nov 2024 ·May 2024

      [6]
    2. b)

      What is the difference between hierarchical clustering and partitioning method?

      Also asked:May 2023

      [6]
    3. c)

      What is decision tree? Explain with a case study.

      Also asked:May 2024

      [6]

  6. Q6

    1. a)

      Define - frequent item set, Minimum Support Count, Hierarchical Clustering, Regression.

      Also asked:May 2024

      [6]
    2. b)

      What are the association rules? How to evaluate them using support and confidence? Explain with Example.

      Also asked:Nov 2023

      [6]
    3. c)

      Explain the logistic regression.with example.

      [6]

  7. Q7

    1. a)

      Define Business Intelligence. List and explain any 3 tools for Business Intelligence.

      Also asked:Nov 2023 ·May 2023 ·Feb 2023

      [6]
    2. b)

      Write a note on BI Applications in CRM.

      Also asked:May 2025 ·Nov 2023 ·May 2023

      [6]
    3. c)

      What are the advantages of Business Intelligence in ERP.

      Also asked:Nov 2024 ·May 2024

      [5]

  8. Q8

    1. a)

      Justify how BI is useful for Customer Relationship Management.

      Also asked:May 2024

      [6]
    2. b)

      Explain the Role of BI in finance and marketing.

      Also asked:May 2025

      [6]
    3. c)

      State the role of Data Analytics in any business with example. ♦♦♦

      Also asked:Nov 2024 ·May 2024 ·Nov 2023

      [5]