Other Data Terms Flashcards
What you normally think of when you hear data. It is columns and rows which a computer can easily search. It will usually contain things like dates, phone numbers, names, order ids, etc. It can easily be processed and analysed by data analysis tools.
Structured Data
What sources can Structured Data come from?
Humans or Machines
What formats can Structured Data come in?
CSV files, XML, Google Sheets
Give an example of Structured Data
Dates, phone numbers, credit card numbers, customer names
Does not easily put into a table, things like audio or video files, images for example. These are difficult for a machine to search but there are ways and methods of doing this. For example, you may have heard of facial recognition software - this can analyse this type of data using algorithms.
Unstructured data
What sources can Unstructured Data come from?
Humans or Machines
What formats can Unstructured Data come in?
images, audio, .txt files
Give an example of Unstructured Data
Text files, email messages, audio files, video files
Data owned by organisations and have trademarks on it. You can broadly divide into two categories- operational and administrative.
Internal Data
What sources can Internal Data come from?
Directly generated from the company with sales reports, financial documents, HR resources, or elsewhere
What formats can Internal Data come in?
Excel spreadsheets, HR tools, etc.
Give an example of Internal Data
HR data, payroll, purchase data
Any type of data that has been captured, processed, and provided from outside the company.
External Data
What sources can come from?
An external provider outside your organisation
What formats can come in?
Reports, CSV, Excel spreadsheets
Give an example of
You are running a campaign and purchase a list of emails from another business. You are looking at trends in the industry and you use data provided from another institution.
Data that describes qualities or characteristics and can be categorised.
Qualitative data
What sources can Qualitative data come from?
Questionnaires, customer feedback forms, reviews, interviews, focus groups, observations
What formats can Qualitative data come in?
Words, text, image, video, audio
Give an example of Qualitative data
Notes from a focus group, open-ended responses, answers to a survey that lists characteristics.
Data that is numerical and can be evaluated. Easy for a computer to read and be analysed with machine learning.
Quantitative data
What sources can Quantitative data come from?
Surveys, questionnaires, any platform that can export numerical data
What formats can Quantitative data come in?
Numbers, an Excel file, a table in a Word document, anything that can present numbers
Give an example of Quantitative data
The number of cars in a parking lot, the number of books you own, the temperature during the week.