CORK INSTITUTE OF TECHNOLOGY INSTITIÚID TEICNEOLAÍOCHTA CHORCAÍ
Semester 1 Examinations 2012/13
Module Title: Business Intelligence
Module Code: COMP8016
School: Science and Informatics
Programme Title: Bachelor of Science (Honours) in Cloud Computing, Higher Diploma in Sceince in Cloud Computing,
Higher Diploma in Sceince in Cloud & Mobile Software Development.
Programme Code: KCLDC_8_Y4 KCMSD_8_Y4 KCLCO_8_Y4
External Examiner(s): Dr David White
Internal Examiner(s): Mr Karl O’Connell, Mr Aengus Daly
Instructions: Answer question one and any two other questions
Duration: 2 hours
Sitting: Winter 2012
Requirements for this examination:
Note to Candidates: Please check the Programme Title and the Module Title to ensure that you are attempting the correct examination.
Q.1 Compulsory Question - Total 40 Marks – Answer any 4 parts.
a) Explain what is meant by CRISP-DM. Detail 2 of the steps
involved. 10 Marks
b) Write a brief note explaining what Business Intelligence is. You may give its historical progression and some of its various categories.
10 Marks
c) Briefly explain what a Data Warehouse is, outlining some of the
key steps involved in developing one. 10 Marks
d) Why are visualisation techniques important in Business
Intelligence? Outline some techniques and some technologies used in this area.
10 Marks
e) Explain what anomaly detection is, giving some of its uses and
some of the data mining techniques involved. 10 Marks
Answer any 2 of the remaining 5 questions (all questions carry equal marks) Q.2 Data Warehousing – Total 30 Marks
a) In the early definitions of data warehousing by Inmon(1993) the following were used to define data:- subject-oriented, integrated, time-variant and non-volatile.
Briefly explain the terms.
4 Marks
b) Outline in detail a typical architecture of a data warehouse and explain the major components that contribute to the architecture of the data warehouse.
13 Marks
c) In relation to data warehousing tools and technologies, discuss the
ETL process. 7 Marks
d) Briefly explain the term Data Mart and list 5 reasons for creating
one. 6 Marks
Q.3 Online Analytical Processing – Total 30 Marks
a) Discuss OLAP Benchmarks and make reference to JIT & AQM. 8 Marks
b) Dimensionality modelling is a logical design technique that aims to present that data in a standard, intuitive form. Explain
dimensionality modelling making reference to Star & Snowflake schema.
6 Marks
c) OLAP servers are categorised according to the architecture used to store and process multidimensional data. List the four main categories and explain any 2 in detail.
10 Marks
d) Discuss the OLAP extension to SQL – Feature T611 – Elementary OLAP operators.
Q.4 Data Mining and Data Quality – Total 30 Marks
a) Explain the term data mining. 4 Marks
b) In relation to data mining, the 4 main operations are:
Predictive Modeling, Database Segmentation, Link Analysis & Deviation Detection.
Discuss any 2 in detail.
12 Marks
c) List and explain the important characteristics of data mining tools. 8 Marks
d) Discuss how data integration is important for ensuring data quality and explain two of the techniques for achieving data integration.
6 Marks
Q.5 Applied Business Intelligence – Total 30 Marks
David is the IT Manager of a medium sized car rental company, CarDeal. With a staff of 360, a fleet of 500 vehicles and 5 nationwide branches; the company is looking to expand.
CarDeal has 2 commercial relational database systems and a separate finance IT system. CarDeal have a history of bringing in outside consultants for large IT projects.
David has asked you for advice on Data Warehousing (DW) and OLAP. You may make any reasonable assumptions to compliment your answer as well as giving details of appropriate technologies.
a) Explain to David what the key benefits are of implementing a DW and
OLAP system in relation to Business Performance Management. 10 Marks
b) Explain what is meant by ELT and why it is important. 10 Marks
Q.6 Applied Business Intelligence – Total 30 Marks
Jennifer is the CEO of a small airline company, AIRO, which has a fleet of 50 planes and a staff of 260. The company has been in operation for 16 years.
Jennifer is interested in strengthening her business using data analytics. She studied mathematics in college, some 18 years ago and would like to be given some mathematical/statistical information where relevant. She would also welcome some technology advice where relevant. Currently AIRO has are two separate IT systems.
You may make any assumptions that are reasonable.
a) Jennifer is interested in the area of prediction and forecasting of her airline customer numbers, outline a data analytics technique in this area and how it would benefit her business.
15 Marks
b) Jennifer would like a way of finding her best profit generating customers and offering them incentives etc to strengthen their loyalty to the
company. Using a data mining technique such as Decision Trees (or any other), briefly explain to Jennifer how it works, how it could be used to address her needs and any other business ideas which would help her here.
15 Marks