Skip to content

Introduction to Business Intelligence

CIS · Final · Spring 26

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

Read the questions as text

Read off the PDF by AI, so it may have mistakes. The PDF is the original.

Daffodil International University Faculty of Science & Information Technology Department of Computing and Information System Final Examination, Spring-2026 Course Code: BI329, Course Title: Introduction to Business Intelligence Level: 3 Term: 2 Marks: 40 Exam Duration: 2 Hours Answer any 5 Questions out of the 6. Each Question contains 8 Marks. [The figures in the right margin indicate the full marks and corresponding course outcomes. All portions of each question must be answered sequentially.] 1. a) Write your thoughts on the data warehouse. Define KPIs. | 2 1. b) Give four examples of BI tools. Describe the evolution of Business Intelligence. | 2 1. c) Explain the ETL process with steps. Outline your thoughts on Business Analytics | 2 1. d) Define Descriptive Analysis. Explain Multivariate Testing. | 2 2. a) Define Structured, Unstructured and Semi-structured decisions. Define Decision Under Risk. | 2 2. b) Define Rational Decision-Making and Bounded Rationality. Write the name of the 5Vs. | 2 2. c) Define the Intelligence Phase in Simon's Model. What is the Design Phase in decision-making? | 2 2. d) Write the reason for the emergence of Big Data. Describe the SMART KPI with Examples. | 2 3. a) Describe ways to add multiple Pages in Looker Studio. Also, describe ways to change the Title of any Chart in Looker Studio. | 2 3. b) Explain the theme in Looker Studio. How does Looker Studio differ from Google Analytics? | 2 3. c) Describe custom visualisations in LookerStudio. Define any Four Controls of Looker Studio. Differentiate between Google Connectors and Partner Connectors when adding a Data Source. | 3 3. d) Define dimensions and metrics in LookerStudio. | 1 4. a) What are EBITDA, CAC, and CSAT? Write the Formulas and Give Examples. | 3 4. b) For a single customer, find the value of CLTV, where: Revenue = 400,000 Taka, Number of Orders = 500, Purchase Frequency = 24 / Year, Lifespan = 9 Years. | 2 4. c) What are Pipeline Value, Marketing ROI & Customer Churn Rate? Write the Formulas and Give Examples. | 3 5. a) What is ThoughtSpot? Elaborate on the concept of Search-Driven Analytics. | 2 5. b) Describe the role of Spotter in Thoughtspot? Explain your thoughts on ThoughtSpot Liveboards. | 2 5. c) What is SpotApps in ThoughtSpot? Describe ways to build forecasting for manufacturing demand in Thoughtspot. | 2 5. d) Define table relationships in ThoughtSpot? Explain synonyms and indexed search. | 2 6. a) Discuss user adoption in BI implementation. Describe data quality in BI systems. Define Decision Support System (DSS). | 3 6. b) Discuss best practices for successful BI implementation. Discuss the role of Data Science in BI. Outline your thoughts on Multivariate Testing. | 3 6. c) Differentiate between OLTP and OLAP systems. | 2