Course Code : CST 457-3 QTSR/RW – 24 / 1785
Eighth Semester B. Tech. ( Computer Science and Engineering )
Examination
DATA WAREHOUSING FOR BUSINESS INTELLIGENCE
Time : 3 Hours ] [ Max. Marks : 60
Instructions to Candidates :—
All questions carry marks as indicated against them.
1. (a) Differentiate between structured, unstructured and semi-structured data. Provide
examples of each type and discuss their relevance in digital environments.
6(CO2)
(b) Illustrate the following data analytics techniques with suitable examples :
= Prescriptive Analytics.
= Predictive Analytics. 4(CO2)
2. (a) An insurance company, with branches all over the country, wants to develop
a data warehouse for effective decision-making about their insurance policies.
There are several different types of insurance like Auto insurance, Home
insurance, Industrial insurance, etc. The entire country is categorized into four
regions, namely, North, South, East and West. Each region consists of a
set of states. There may be different types of customers like individuals,
institutions, industry, etc. The data warehouse should record an entry for
each policy issued to each customer along with the premium paid.
With respect to the above use case, answer the following questions.
Necessary assumptions can be made to support your answer :
(i) Design a star schema for the data warehouse clearly identifying
the fact table(s), dimensional table(s), their attributes and measures
along with the primary key and foreign key relationships.
QTSR/RW-24 / 1785 Contd.
(ii) Write an SQL query by which you can display region - wise,
insurance - type - wise, year - wise total premium collected from your
schema.
(iii) Draw possible concept hierarchies for each dimension.
6(CO1)
(b) Give suitable examples for Additive, Semi-Additive and Non-Additive Facts
in Fact table of a data warehouse. 4(CO1)
3. (a) Explain the concept of data profiling in the context of schema integration.
How can data profiling tools assist in understanding the structure and content
of diverse schemas ? 5(CO2)
(b) Narrate the impact of incomplete data on data quality with suitable example.
What strategies can be employed to address and mitigate issues related
to incomplete data in a data warehouse ? 5(CO2)
4. (a) Define Business Intelligence architecture and explain its key components. How
does BI architecture support the process of transforming raw data into meaningful
insights for decision-making ? 6(CO3)
(b) "Laptop" cost in "Asia Region" is INR 55,000 against target of
INR 40,000.
Identify and discuss the following components of metric data for the above
scenario :
(i) Subject,
(ii) Stratum,
(iii) Quantum,
(iv) Applications. 4(CO3)
5. (a) Discuss the four perspectives of the Balanced Scorecard : Financial, Customer,
Internal Business Processes and Learning and Growth with suitable example.
5(CO3)
QTSR/RW-24 / 1785 2 Contd.
(b) Define Key Performance Indicators (KPIs) and explain their significance in
the realm of Business Intelligence.
A software development company aims to enhance its project management
processes. Recommend two KPIs related to project timelines and two KPIs
related to code quality that the company should track through its Business
Intelligence platform.
Explain how these KPIs contribute to successful project delivery.
5(CO3)
6. (a) Examine the impact of big data analytics on various industries such as healthcare,
finance and marketing. Provide specific examples of how organizations in these
industries have leveraged big data for business insights. 5(CO4)
(b) Explain the role of Apache Hadoop in big data processing. Discuss the
key components of the Hadoop ecosystem and their respective functions.
5(CO4)
QTSR/RW-24 / 1785 3 15