6.4.2 The purpose of data analysis tools and their use in business

Question 1

Define:

Data Warehouse

Data Warehouses

Answer 1

Central location of key data, integrated into a pre-defined format and can be used across the business to make business-critical and evidence-based decisions

Question 2

Fill The Blank:

Data warehouses will have data from a ……………. of internal and external ………………

Data Warehouses

Answer 2

Range, Sources

Question 3

Fill The Blank:

Data warehouses will contain a range of …………. and will therefore need data …………. to convert the data into a standardised and pre-defined format

Data Warehouses

Answer 3

Formats, Cleaning

Question 4

Fill The Blank:

Data in a data warehouses does not …………… and cannot be …………….

Data Warehouses

Answer 4

Change, Edited

Question 5

Define:

Data Cleaning

Data Warehouses

Answer 5

Process of going through data looking for errors and correcting them, or excluding data where errors have been located

Question 6

Explain:

What data warehouses are used for by staff members

Data Warehouses

Answer 6

Used by specific business users to analyse and extract a particular meaning from the data

Question 7

Fill The Blank:

Data stored in a warehouse must be …………, ………………. and easy to …………… and easy to manage to enable data …………… to be carried out.

Data Warehouses

Answer 7

Secure, Reliable, Retrieve, Analysis

Question 8

Define:

Data Lake

Data Lakes

Answer 8

Data stores that hold data in an unstructured way with no defined format to the way the data is structured

Question 9

Fill The Blank:

The data is stored in a …….. state as it may not be processed

Data Lakes

Answer 9

Raw

Question 10

Fill The Blank:

Data in a lake is only converted into a predefined ………….. when it is ready to be analysed

Data Lakes

Answer 10

Format

Question 11

State:

3 advantages using data warehouses

Data Warehouses

Answer 11

• Faster data retrieval
• Easy integration
• Great performance
• Flexibility

Question 12

State:

3 disadvantages of data warehouses

Data Warehouses

Answer 12

• Time taking process
• Limited use of data
• High cost of data

Question 13

State:

3 advantages of data lakes

Data Lakes

Answer 13

• Variety and volume
• Fast processing
• Scalability

Question 14

State:

3 disadvantages of data lakes

Data Lakes

Answer 14

• Cloud preferences
• Lack of optimisation
• Skill gap and best practices

Question 15

Define:

Data Mining

Data Mining

Answer 15

Data mining is used by organisations to process and analyse raw data often used by companies to find unusual patterns that are not normally spotted. It is often done by a specialist third party.

Question 16

Define:

Data Reporting

Data Reporting

Answer 16

Takes data and converts it into information and can show an organisation what is happening right now and be analysed for understanding why things are happening. Data can be converted into graphs and charts