Skip to content
EndsemNov 20242019 patternBE Comp

Business Intelligence SPPU Endsem Question Paper Nov 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
Nov 2024
Max. marks
70
Time
2½ Hours
Semester
VIII
Paper code
[6354]-506

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)

      Discuss the need for Data Grouping & Sorting, Filtering Reports for BI.

      Also asked:Nov 2025 ·May 2024 ·Nov 2023

      [6]
    2. b)

      What are the important BI reporting practices?

      Also asked:May 2024

      [6]
    3. c)

      Explain how multi-dimensional Data Model is suitable for analysis with a suitable example.

      [5]

  2. Q2

    1. a)

      Discuss the Scatter chart and Combination chart with diagram used for report.

      [6]
    2. b)

      What is data integration? Explain the two methods used for the same.

      [6]
    3. c)

      What is binning? How it is used for report creation?

      [5]

  3. Q3

    1. a)

      How Mean, Median and Mode are used during data cleaning.

      [6]
    2. b)

      What is data transformation? Why it is needed? Explain any one technique with example.

      Also asked:May 2024

      [6]
    3. c)

      Explain the need of data cleaning and different methods.

      [6]

  4. Q4

    1. a)

      Explain the working of PCA. Its application.

      [6]
    2. b)

      Explain the data discretization. What are two methods?

      [6]
    3. c)

      What is data reduction? Explain Dimensionality Reduction and Data Compression. 2

      Also asked:May 2024

      [6]

  5. Q5

    1. a)

      Explain the advantages and disadvantages of Naïve Bayes Classifier.

      [6]
    2. b)

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

      Also asked:May 2024 ·May 2023

      [6]
    3. c)

      Discuss the Parameter Tuning and Optimization.

      [6]

  6. Q6

    1. a)

      What is clustering? Explain K-mean clustering with a suitable example.

      [6]
    2. b)

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

      Also asked:May 2024

      [6]
    3. c)

      What is logistic regression? Discuss the types of logistic regression

      Also asked:Nov 2025 ·May 2024

      [6]

  7. Q7

    1. a)

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

      Also asked:Nov 2025 ·May 2024

      [5]
    2. b)

      What is the role of Analytics in Business Intelligence?

      Also asked:Nov 2025 ·May 2024 ·Nov 2023

      [6]
    3. c)

      Write short note on KNIME, Rapid Miner.

      [6]

  8. Q8

    1. a)

      Discuss the use of Business Intelligence in Finance.

      [5]
    2. b)

      Justify BI is useful for Telecommunications services.

      [6]
    3. c)

      Write short note on Business Intelligence and inventory management system. 

      [6]