Now, let's move to the next topic of data analytics roadmap:

Types of Data ✍️

You work with three data types.

1. Structured Data
• Fixed rows and columns
• Easy to store and query
• Lives in databases and spreadsheets
• Examples: Sales table with date, product, revenue; Employee table with ID, department, salary
• Where you see it: Excel, SQL databases, CRM and ERP systems

2. Semi-structured Data
• No fixed table format
• Has tags or keys
• Needs parsing before analysis
• Examples: JSON from APIs, XML files, Log files
• Where you see it: Web applications, Mobile apps, Cloud systems

3. Unstructured Data
• No defined format
• Harder to analyze
• Needs advanced tools
• Examples: Text reviews, Emails, Images, audio, video
• Where you see it: Social media posts, Customer feedback, Call recordings

Why this matters to you
• Most analyst jobs start with structured data
• Semi-structured data appears in modern products
• Unstructured data leads to AI and NLP roles

Mini task for today
1. Open Excel. Create a structured table with 3 columns and 5 rows.
2. Download a sample JSON file from any API site. Identify keys and values.

Next topic: Tools used in data analytics.

Double Tap ♥️ For More