Skip to content
EndsemMay 20232019 patternBE Comp

Business Intelligence SPPU Endsem Question Paper May 2023

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
May 2023
Max. marks
70
Time
2½ Hours
Semester
VIII
Paper code
[6004]-501

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)

      Explain in detail drill up & drill down.

      Also asked:Nov 2025 ·Nov 2023

      [6]
    2. b)

      Explain multidimensional data model with example.

      Also asked:Nov 2025 ·Nov 2023

      [6]
    3. c)

      What is data grouping and sorting? Write example of each.

      [5]

  2. Q2

    1. a)

      Explain different types of reports in detail?

      Also asked:Nov 2025 ·May 2025 ·Nov 2023

      [6]
    2. b)

      Explain relational data Model with example.

      Also asked:Nov 2025 ·Nov 2023

      [6]
    3. c)

      Write short note on filtering reports.

      [5]

  3. Q3

    1. a)

      Explain data exploration in detail with example.

      [7]
    2. b)

      Explain data transformation in detail with example.

      [5]
    3. c)

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

      Also asked:Nov 2025 ·Nov 2023

      [5]

  4. Q4

    1. a)

      Explain data reduction in detial with example.

      [7]
    2. b)

      Difference between univariate, Bivariate, Multivariate analysis.

      Also asked:May 2025

      [5]
    3. c)

      Write a short note on data discretization.

      [5]

  5. Q5

    1. a)

      What is the association rule mining? Explain the terms support, confidence, lift.

      [5]
    2. b)

      What is the difference between hierarchical clustering and partitioning method? 2

      Also asked:Nov 2025

      [5]
    3. c)

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

      [8]

  6. Q6

    1. a)

      Explain Bayes theorem in detail.

      [5]
    2. b)

      Different between classification and clustering.

      Also asked:Nov 2024 ·May 2024

      [5]
    3. c)

      Explain logistic regression with example.

      [8]

  7. Q7

    1. a)

      Explain BI application in CRM.

      Also asked:Nov 2025 ·May 2025 ·Nov 2023

      [6]
    2. b)

      Explain roles of Analytical tools in BI.

      Also asked:May 2025

      [6]
    3. c)

      Define business intelligence. List and explain any 03 tools for Business intelligence.

      Also asked:Nov 2025 ·Nov 2023 ·Feb 2023

      [6]

  8. Q8

    1. a)

      Explain applications of BI in telecommunication and banking.

      Also asked:May 2025

      [6]
    2. b)

      Explain BI application in Logistics and production.

      Also asked:May 2025 ·May 2024

      [6]
    3. c)

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

      [6]