DATA ANALYSIS TOOLS

Question 1

Data tables

Answer 1

they are often split into tables to be easier to update, view and manipulate. Separating data into tables allows for simple editing and also allows the displays of basic patterns.
data tables allow for the most simple form of pattern discovery and are a good method of speedy, short term data analysis. However they present data in its current format and cannot show change or trends over time, for example a product may have a high stock level because it has just been ordered in rather than because no one is buying it.

Question 2

visualization of data

Answer 2

visualizing data makes it easier for an audience to see trends and patterns
makes it easier to understand and interpret
for example bar charts

Question 3

trend and pattern identification

Answer 3

links heavily to visualization of data in allowing trends and patterns to be viewed as a visual format.
statistical analysis allows data analysts to examine numerical data and if done correctly, can highlight relationships between different data elements
discovering links between variables is known as regression analysis

Question 4

data cleaning

Answer 4

ensures that any stored data is up to date and accurate, in accordance with the data protection act 2018. forms of data cleaning include removing customers who have not made a purchase in a certain amount of time and periodically checking that users addresses are up to date.
data cleaning would reduce the size of any data table by removing redundant, incorrect or unnecessary data. this would make it easier to work with the data table and would improve the data quality by removing irrelevant data.

Question 5

GIS/ location mapping

Answer 5

can be used to add geographic data to any analysis for example tracking the movement of ship containers.