Skip to content
EndsemMay 20242019 patternBE Comp

Business Intelligence SPPU Endsem Question Paper May 2024

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
410253C
Pattern
2019 pattern
Exam
Endsem
Session
May 2024
Max. marks
70
Time
2½ Hours
Semester
VIII
Paper code
[6263]-102

Printed for: B.E. (Computer Engineering)

Instructions to the candidates

  1. Answer Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8.
  2. Neat diagrams must be drawn wherever necessary.
  3. Figures to the right indicate full marks.
  4. Assume Suitable data, if necessary.

Questions

  1. Q1

    1. a)

      What are the important BI reporting practices?

      Also asked:Nov 2024

      [6]
    2. b)

      Discuss the importance of drill up, drill-down and drill-through capabilities in report preparation.

      [6]
    3. c)

      Explain with examples the use of Data Grouping and sorting, Filtering is important in BI Reports.

      Also asked:Nov 2025 ·Nov 2024 ·Nov 2023

      [5]

  2. Q2

    1. a)

      Explain the multi-dimensional Data Model with a suitable case study. What are the Advantages of Multi-Dimensional Data Model?

      [6]
    2. b)

      What is importance of adding Conditional formatting and adding calculations in report

      [6]
    3. c)

      How the business report helps any organization?

      [5]

  3. Q3

    1. a)

      Discuss the need for data pre-processing and any 2 techniques used.

      [6]
    2. b)

      What is data transformation? Why it is needed? Explain at least 3 techniques.

      Also asked:Nov 2024

      [6]
    3. c)

      What is data reduction? Explain Dimensionality Reduction and Data Compression

      Also asked:Nov 2024

      [6]

  4. Q4

    1. a)

      Define dirty data. What are the reasons of dirty data.

      [6]
    2. b)

      Explain the working of binning with suitable example.

      [6]
    3. c)

      What is Bivariate analysis? Why it is important. Discuss the different types with example?

      [6]

  5. Q5

    1. a)

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

      Also asked:Nov 2025 ·Nov 2024

      [6]
    2. b)

      How the classification and clustering are different. Discuss use with example.

      Also asked:Nov 2024 ·May 2023

      [6]
    3. c)

      What is a decision tree? Explain with a case study.

      Also asked:Nov 2025

      [6]

  6. Q6

    1. a)

      What is the K-mean clustering? Explain the step-by-step working of the k-mean algorithm.

      [6]
    2. b)

      What is the Apriori Algorithm? Discuss the applications of this algorithm with example .

      Also asked:Nov 2024

      [6]
    3. c)

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

      Also asked:Nov 2025

      [6]

  7. Q7

    1. a)

      What are the advantages of Benefits of Business Intelligence in ERP.

      Also asked:Nov 2025 ·Nov 2024

      [5]
    2. b)

      What is the role of Analytics in Business Intelligence?

      Also asked:Nov 2025 ·Nov 2024 ·Nov 2023

      [6]
    3. c)

      Write short note on WEKA, Rapid Miner.

      [6]

  8. Q8

    1. a)

      Discuss the use of BI Applications in Logistics and Production.

      Also asked:May 2025 ·May 2023

      [5]
    2. b)

      Justify BI is useful for Customer Relationship Management?

      Also asked:Nov 2025

      [6]
    3. c)

      This part has equations that don’t show as text. Open the PDF to read it.

      [6]