Unit 2 3.5 Data analysis tools (Graphs (Bar bar , Line line , Pie pie ),…
Unit 2 3.5 Data analysis tools
Removal of customer/data after 2 years, for example when a student leaves school they will remove data that is unwanted and unused by the student and that same for if someone was the leave a business.
Geographic information system / location mapping
Giving a visual form of data, for example when an uber is hired, the location is shown to the user were that car is and the location of the user is shown to the driver or a map showing the vegetation and water levels of Hyde park.
Trend and pattern identification
Analysis of statistics over time, this could be customers satisfaction rate over a week during the winter or attendance of students before summer break (line graph format).
Visualization of data
Using a map to find information about the location this could be crime rates, cyber attacks, etc.
For example column C can be hidden to not show the data on its column
Used to make a column not be able to be seen
Sorting by genre e.g. Adventure, Music, Platformer, Puzzle, MMO & RPG.
Sort A-Z / Z-A
Change the look of a value in order to highlight it
E.g. If a value is equal to 1 colour blue