Business Intelligence and Data Warehouse

Question 1

is the practice of working with data to glean useful information, which can then be used to make informed decisions.

Answer 1

Data Analysis

Question 2

Organizations tend to grow and prosper as they gain a better understanding of their
environment.

Answer 2

Need for Data Analysis

Question 3

a term that describes a comprehensive,
cohesive, and integrated set of tools and
processes used to capture, collect, integrate,
store, and analyse data with the purpose of
generating and presenting information to
support business decision making.

Answer 3

Business Intelligence (BI)

Question 4

is a framework that allows a business to
transform data into information, information into
knowledge, and knowledge into wisdom.

Answer 4

Business Intelligence (BI)

Question 5

BI’s Framework

Question 13

the integrated processes of getting data from original sources into the data warehouse.

Answer 13

Extraction, Transformation, and
Loading (ETL)

Question 14

retrieving
data from original data sources

Answer 14

Extraction

Question 15

manipulating the data into an appropriate form

Answer 15

transformation

Question 16

storing the data in the data warehouse

Answer 16

loading

Question 17

a web-based system that presents key business
performance indicators or information in a single, integrated view with clear and concise graphics.

Answer 17

Dashboard

Question 18

a unified, single point of entry for information distribution.

Answer 18

Portal

Question 19

is stored in a relational database in which the structures (tables) tend to be highly normalized.

Answer 19

Operational Data

Question 20

is an arrangement of computerized tools used to assist managerial decision making

Answer 20

Decision Support System

Question 21

A decision support database is a specialized DBMS tailored to provide fast answers to complex queries

Answer 21

Decision Support Database Requirement

Question 22

It must support complex data representation.

Answer 22

Database Schema

Question 23

The decision support database is created largely by extracting data from the operational database and by importing additional data from external sources. Data-filtering capabilities must include the ability to check for inconsistent data or data validation rules.

Answer 23

Data Extraction and Filtering

Question 24

Decision support databases tend to be very large; gigabyte and terabyte ranges are not unusual

Answer 24

Database Size

Question 25

can be defined as integrated, subjectoriented, time-variant, non-volatile collection of data that provides support for decision making.

Answer 25

Data Warehouse

Question 26

data are being stored in a globally accepted fashion with consistent naming conventions, measurements, encoding structures, and physical attributes, even when the underlying operational systems store the data differently.

Answer 26

Integrated

Question 27

all relevant data about a subject is gathered and stored as a single set in a useful format such as customers, products and sales.

Answer 27

Subject-Oriented

Question 28

This provides a tracker to produce reports including the data changes done over time.

Answer 28

Time-Variant

Question 29

the data in data warehouse is a read-only where it can be loaded and accessed in the data warehouse.

Answer 29

Non-Volatile

Question 30

A data modelling technique used to map multidimensional decision support data into a relational database.

Answer 30

Star Schema

Question 31

the measurements (values) that measure a specific business aspect or activity.

Answer 31

Facts

Question 32

contains facts that are linked through their dimensions.

Answer 32

fact table

Question 33

are qualifying characteristics that provide additional perspectives to a given fact.

Answer 33

Dimension

Question 34

are often used to search, filter, or classify facts. Each dimension table contains attributes.

Answer 34

Attribute

Question 35

provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

Answer 35

Attribute Hierarchy