Skip to content
EndsemNov 20232019 patternBE Comp

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

Printed for: B.E. (Computer Engineering)

Instructions to the candidates

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

Questions

  1. Q1

    1. a)

      State different types of reports with their application.

      Also asked:Nov 2025 ·May 2025 ·May 2023

      [6]
    2. b)

      What are the best practices in dashboard design?

      [6]
    3. c)

      State the difference between relational and multidimensional data model.

      Also asked:Nov 2025 ·May 2023

      [6]

  2. Q2

    1. a)

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

      Also asked:Nov 2025 ·Nov 2024 ·May 2024

      [6]
    2. b)

      What is a File Extension? Explain the structure of CSV file.

      [6]
    3. c)

      Explain in detail Drill up and Drill Down.

      Also asked:Nov 2025 ·May 2023

      [6]

  3. Q3

    1. a)

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

      [7]
    2. b)

      What is data Transformation? Explain Data Transformation Process in Detail.

      Also asked:Nov 2025

      [5]
    3. c)

      Explain univariate, bi variate and multivariate analysis with example and applications. 2

      [5]

  4. Q4

    1. a)

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

      Also asked:Nov 2025

      [7]
    2. b)

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

      Also asked:Nov 2025 ·May 2023

      [5]
    3. c)

      Explain following Data reduction technique: Sampling, Feature selection, Principal component analysis.

      Also asked:Nov 2025

      [5]

  5. Q5

    1. a)

      Write a difference between classification and clustering with applications.

      Also asked:May 2025

      [6]
    2. b)

      Write a short note on Logistic Regression.

      [6]
    3. c)

      The database has shown transactions. Let min_support = 02 and min_confidence = 70%. Find all frequent item set using Apriori algorithm and generate strong association rules

      [6]

  6. Q6

    1. a)

      What are association rules? How to evaluate them using Support and Confidence? Explain with Example.

      Also asked:Nov 2025

      [6]
    2. b)

      State different formulae for Evaluation of classification models.

      [6]
    3. c)

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

      [6]

  7. Q7

    1. a)

      State and explain different Tools for Business Intelligence.

      Also asked:Nov 2025 ·May 2023 ·Feb 2023

      [6]
    2. b)

      State and Elaborate similarities & differences in ERP and Business Intelligence.

      [6]
    3. c)

      Write a note on: BI Applications in CRM.

      Also asked:Nov 2025 ·May 2025 ·May 2023

      [5]

  8. Q8

    1. a)

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

      Also asked:Nov 2025 ·Nov 2024 ·May 2024

      [6]
    2. b)

      Comment “How might you implement business intelligence findings within an organization?”

      [6]
    3. c)

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

      [5]