Introduction to Business Intelligence
CIS · Final · Spring 26
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