Types of Data in Analytics
Structured vs unstructured, qualitative vs quantitative, discrete vs continuous, and the 4 measurement scales — with real Indian examples and why it matters for analysis.
Structured vs Unstructured Data
The most fundamental distinction in data analytics is between structured and unstructured data. It determines the tools you use, the difficulty of the analysis, and how much preparation the data needs before you can work with it.
Between the two extremes sits semi-structured data — it has some organisation but does not fit a rigid table. JSON and XML files are examples. A customer API response from Razorpay or Paytm that contains a mix of text fields, nested objects, and arrays is semi-structured. It requires some transformation before it becomes a clean table for analysis.
Qualitative vs Quantitative Data
Within structured data, every column is either quantitative (numeric, measurable) or qualitative (categorical, descriptive). This distinction determines which calculations make sense and which charts to use.
Discrete vs Continuous Data
Quantitative data has a further subdivision — discrete (countable, whole numbers) and continuous (any value within a range, including decimals).
Countable values that cannot be split into smaller meaningful parts. You can have 5 orders or 6 orders, not 5.3 orders.
- Number of orders placed per day
- Number of employees in a branch
- Number of customer complaints per week
- Number of items in a cart
Can take any value within a range — including fractions and decimals. Measured rather than counted.
- Revenue (₹14,327.50 — decimal values are valid)
- Temperature in a warehouse (28.4°C)
- Delivery time in hours (1.7 hours, 3.25 hours)
- Customer age (can be expressed as 24.5 years)
The 4 Measurement Scales — Nominal, Ordinal, Interval, Ratio
The measurement scale of a variable determines which mathematical operations are valid. This matters both for choosing the right calculation and for avoiding misleading results.
Categories with no order or ranking. The values are just labels.
Categories that have a meaningful order — but the gap between ranks is not equal or known.
Numeric scale with equal gaps between values, but no true zero point. Zero does not mean "none of the thing."
Numeric scale with equal gaps AND a true zero point. Zero means "none of the thing."
What Data Types Look Like in a Real Indian Dataset
Here is a sample e-commerce orders table — the kind of data you would find in a Flipkart or Myntra internal database. Notice how each column has a different data type, and that data type determines exactly what you can do with that column.
Frequently Asked Questions
What is the difference between structured and unstructured data?
Structured data is organised in a predefined format — rows and columns in a database or spreadsheet. Every entry follows the same structure: a sales record has an order ID, date, amount, and city. Unstructured data has no fixed format — customer reviews, WhatsApp messages, call centre recordings, photos, and emails are all unstructured. Structured data is easy to query with SQL and analyse in Excel. Unstructured data requires text analysis, natural language processing, or image recognition tools. About 80% of business data worldwide is unstructured, but most data analyst roles today work primarily with structured data.
What is the difference between qualitative and quantitative data?
Quantitative data is numeric and can be measured — revenue, temperature, delivery time, number of orders. You can add, subtract, average, and compare quantitative data with mathematical operations. Qualitative data is descriptive and categorical — customer feedback, product category, city name, employee department. Qualitative data tells you what type or category something belongs to. In analytics, quantitative data is used for aggregation and trends, qualitative data is used for segmentation and grouping. Most datasets have both — for example, a sales table has quantitative columns (amount, quantity) and qualitative columns (city, category, sales rep name).
What are the 4 measurement scales in data analytics?
The 4 measurement scales are: (1) Nominal — categories with no order (city names, product categories, gender). You can count and compare frequencies but not rank them. (2) Ordinal — categories with a meaningful order but unequal gaps (satisfaction rating: Poor / Average / Good / Excellent). You can rank but not calculate the exact difference between ranks. (3) Interval — numeric scale with equal gaps but no true zero (temperature in Celsius, year). You can add and subtract but not meaningfully divide. (4) Ratio — numeric with equal gaps AND a true zero (revenue, weight, delivery time in minutes). All mathematical operations apply. Most analyst work involves nominal, ordinal, and ratio data.
Why does the type of data matter for analysis?
The type of data determines which analysis methods and visualisations you can use. You cannot calculate the average of a nominal variable like city name — but you can count frequencies and show a bar chart. You can calculate the average of a ratio variable like revenue and show a trend line. Choosing the wrong analysis method for the data type produces misleading results — for example, averaging ordinal satisfaction scores (treating "Poor/Average/Good/Excellent" as 1/2/3/4) is a common mistake that distorts insights. Understanding data types is also essential for knowing how to clean data — a revenue column that contains text values like "NA" or "₹" signs needs different cleaning than a category column with typos.
EVIKA ACADEMY · NOIDA SECTOR 51
Learn analytics from scratch with live guidance
SQL, Python, Power BI, and real projects — structured training for Indian job market. Free demo class available.
Book Free Demo Class →