18. BI

Question 1

What is business intelligence?

Answer 1

Transforms raw data into meaningful and useful information

Question 2

The BI goal

Answer 2

BI is about using data to help enterprise user make better business decisions

Question 3

BI examples

Answer 3

Facebook collects and analyses over 700 TB of data every day
Netflix has over 45 million movie plays per day & 3-4 million ratings and searches every day
NASA were collecting 1.73 GB of data in 5 seconds (beginning of 2015)

Question 4

Data visualisation

Answer 4

Graphical representation of information and data

Question 5

Data warehouse

Answer 5

A logical collection of information gathered from many different operational databases that supports business analysis activities and decision making tasks

Question 6

Business benefits of data warehousing

Answer 6

Extend the transformation of data into information

Provides the ability to support decision making without disrupting day to day operations

Question 7

Extraction, transformation and loading (ETL)

Answer 7

A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loas the information into a data warehouse

Question 8

Data mart

Answer 8

Contains a subset of data warehouse information