Data Analytics: Foundations to Practice · Types and Sources of Data
Structured vs Unstructured Data
The organization, not the content, is what actually distinguishes these two categories, and the distinction determines how much preparation work a dataset needs before it can be analyzed at all.
Structured data is organized into a predefined, consistent format, typically rows and columns, where each column represents a specific, defined attribute and each row represents a specific record, such as a spreadsheet of customer transactions with columns for date, amount, and product category; this predictable organization makes structured data straightforward to sort, filter, and summarize.
Key Takeaways
- Structured data is organized into a predefined, consistent format (rows and columns), making it straightforward to sort, filter, and summarize.
- Unstructured data lacks predefined organization and generally requires additional processing to extract structured information before conventional analysis applies.
- Semi-structured data falls between the two, containing some organizational markers alongside unstructured content.
- The growing share of unstructured data (text, images, audio, video) means many analytics projects require more upfront preparation effort than structured data alone would.