3.5 Data of Analysis

Question 1

What was the 5th stage of data analysis?

Answer 1

Select the most appropriate tool

Question 2

Data tables

Answer 2

Databases are split into tables to allow for:

Easier viewing

Easier to update

Easier to manipulate

Separating data into tables allows for:

Simpler editing

Display of basic patterns

Question 3

Data tables part 2

Answer 3

Allow for the most simplest form of pattern discovery

Good method of speedy, short term analysis

However

It presents data in its current format and cannot show changes or trends overtime

Question 4

Visualisation of Data

Answer 4

Producing bar charts or graphs

Makes it easier to see trends and patterns

Bar Charts allow for quick interpretation

Question 5

Trend & Pattern identification

Answer 5

Links to visualisation of data as it allow for:

Trends and patterns to be viewed as a visual format e.g a line graph of stocks

Question 6

Trend & Pattern identification

What does statistical analysis allow for?

What happens if it’s done correctly?

Answer 6

Allows data analysts to examine numerical data

Can highlight relationships between different data elements (price of a product and how many have been sold)

Discovering links between variables is also known as regression analysis

Question 7

Data cleaning

Answer 7

Ensures that any stored data is up to date and accurate

Question 8

What does data cleaning do?

Answer 8

Reduces the size of any data table by removing:

Redundant, incorrect or unnecessary data

This makes it easier to work with the data table, Improving the data quality by removing irrelevant data

Question 9

GIS / Location mapping

Answer 9

Used to add geographic data to any analysis

E.g an organisation can track the geographical location of items or staff (tracking the movement of shipping containers)