LO3.5 DATA ANALYSIS TOOLS

LO3.5 DATA ANALYSIS TOOLS

1. DATA TABLE:

   • A WELL-STRUCTURED DATABASE USE SEPARATE DATA TABLES FOR DIFFERENT TYPES OF INFORMATION. FOR EXAMPLE, A DATABASE OF PATIENTS WOULD HAVE ONE TBALE THAT JUST HELD INFORMATION ABOUT PATIENTS

2. VISUALISATION

   • THIS IS A TOOL TO HELP PEOPLE UNDERSTAND THE SIGNIFICANCE OF THE DATA BY PUTTING IT INTO A VISUAL CONTEXT. PATTERNS, TRENDS AND CORRELATIONS ARE MUCH EASIER TO RECOGNISE WHEN DATA VISUALISATION IS USED

3. TRENDS AND PATTERN IDENTIFICATION

   • THIS IS SIMILAR TO THE VISUALISATION OF DATA WHERE YOU WOULD USE A COMPARISON LINE GRAPH TO ANALYSIS SALES OVER OVER A MONTH PERIOD FOR, SAY, THE LAST FIVE YEARS

4. DATA CLEANING

   • AN IMPORTANT PART OF DATA MANAGEMENT IS MAKING SURE THAT THE DATA THAT IS HELD IS RELEVANT AND UP-TO-DATE. SIMILARLY, PERIODIC CHECKS TO ENSURE THAT THE CORRECT ADDRESS IS HELD FOR EACH CUSTOMER IS ALSO GOOD PRACTICE.

5. GEOGRAPHICAL INFORMATION SYSTEM/LOCATION MAPPING

   • THE ABILITY TO TRACK THE GEOGRAPHICAL LOCATION OF STAFF OR ITEMS THAT ARE BEING SHIPPED AROUND THE WORLD CAN BE A REAL BENEFIT FOR AN ORGANISATION. STAFF CAN BR TRACKED SO THAT DELIVERY TIMES CAN BE CONFIRMED WITH ORGANISATIONS.