Types of Data

Types of Data

Data is one of the most important resources used in modern organizations.
Before a data analyst can properly analyze a dataset, it is important to understand
the different types of data that may be collected and how each type can be handled.

Different types of data require different methods of collection, storage,
cleaning, analysis and visualization. Understanding data types therefore forms
one of the foundations of good data analysis.

1. What Is Data?

Data refers to raw facts, observations, measurements, records or values that
can be collected and used for analysis.

Examples include:

• A student’s age
• A customer’s name
• The price of a product
• The number of products sold
• A customer’s feedback
• A photograph
• A recorded interview
• A website visitor’s location

Data can appear in many different forms. It may be numbers, words, dates,
categories, images, audio, video or combinations of several formats.

2. Qualitative and Quantitative Data

One of the most common ways of classifying data is into
qualitative data and quantitative data.

Qualitative Data

Qualitative data describes characteristics, qualities, opinions or categories.
It normally answers questions such as:

• What type?
• Which category?
• What do people think?
• How do customers feel?

Examples include:

• Customer feedback
• Product category
• Gender category
• Customer satisfaction level
• Department name
• Type of complaint

Qualitative data may be represented using words, labels or categories.

Quantitative Data

Quantitative data represents measurable quantities and is generally expressed
using numbers.

Examples include:

• Age: 25
• Salary: ₦250,000
• Temperature: 31°C
• Number of students: 45
• Website visitors: 2,500
• Product price: ₦15,000

Quantitative data can be analyzed using mathematical and statistical methods.

3. Discrete and Continuous Data

Quantitative data can further be divided into discrete and continuous data.

Discrete Data

Discrete data consists of countable values. These values are usually whole
numbers.

Examples:

• Number of students in a classroom
• Number of cars in a parking lot
• Number of products sold
• Number of employees
• Number of customer complaints

For example, a company may have 50 employees. It would not normally have
50.7 employees.

Continuous Data

Continuous data can take any value within a range and is commonly associated
with measurements.

Examples include:

• Height
• Weight
• Temperature
• Distance
• Time
• Speed

For example, a person’s height could be 170 cm, 170.5 cm or 170.55 cm.

4. Nominal Data

Nominal data represents categories that do not have a meaningful numerical
order or ranking.

Examples include:

• Country
• Department
• Blood group
• Product category
• Operating system

For example, Windows, macOS and Linux are categories. There is no meaningful
mathematical ranking that makes one operating system “greater than” another
in the nominal sense.

5. Ordinal Data

Ordinal data represents categories that have a meaningful order or ranking,
although the distance between the categories may not be equal.

Examples include:

• Poor, Fair, Good, Excellent
• Beginner, Intermediate, Advanced
• Small, Medium, Large
• Low, Medium, High

For example, a customer may rate a service as Poor, Fair, Good or Excellent.
The categories have an order, but the difference between Good and Excellent
cannot necessarily be measured as a fixed numerical distance.

6. Numerical Data

Numerical data is data expressed using numbers. It can be used for calculations,
comparisons and statistical analysis.

Examples include sales revenue, age, number of products, profit, temperature,
distance and examination scores.

7. Categorical Data

Categorical data places observations into groups or categories.

For example, an online store may classify customers as:

• New Customer
• Returning Customer
• VIP Customer

Categorical data is particularly useful for grouping records and comparing
different segments.

8. Time-Based Data

Time-based data records information associated with dates or times.

Examples include:

• Transaction date
• Login time
• Monthly sales
• Daily website traffic
• Yearly revenue

Time-based data allows analysts to identify trends, patterns, seasonality
and changes over time.

9. Text Data

Text data consists of words, sentences, paragraphs or other written content.

Examples include:

• Customer reviews
• Emails
• Survey responses
• Social media comments
• Support tickets

Text data can be analyzed using techniques such as keyword analysis,
sentiment analysis and natural language processing.

10. Image, Audio and Video Data

Modern organizations also collect multimedia data.

Image data includes photographs, scanned documents,
medical images and product images.

Audio data includes telephone recordings, interviews,
podcasts and voice messages.

Video data includes security camera footage, training videos,
advertisements and social media videos.

These data types often require specialized tools and technologies for analysis.

11. Examples in Real-World Data Analysis

Consider a training organization such as Dwallnet Technologies.
The organization may collect the following information about students:

12. Why Data Types Matter

Understanding data types is important because the type of data determines how
the data should be stored, cleaned, analyzed and visualized.

For example, calculating the average of student ages makes sense because age
is numerical. However, calculating the average of student names does not make
sense.

Similarly, a chart showing the distribution of course categories may be more
appropriate than a line chart showing course names over time.

13. Data Types and Data Cleaning

Data analysts must identify incorrect data types during data cleaning.

For example, a dataset may contain the following values in an Age column:

25
31
28
"N/A"
42
Thirty

The analyst must determine how missing or invalid values should be handled
before performing calculations.

14. Data Types in Excel

Spreadsheet applications such as Microsoft Excel and Google Sheets commonly
work with several types of values including:

• Text
• Numbers
• Dates
• Times
• Boolean values
• Formulas
• Errors

Correctly identifying these values helps analysts perform calculations,
sorting, filtering and visualization correctly.

15. Data Types in SQL

Databases use specific data types when defining table columns.
Common SQL data types include:

• INTEGER
• DECIMAL
• VARCHAR
• TEXT
• DATE
• DATETIME
• BOOLEAN

Selecting an appropriate data type improves data integrity and helps databases
store and process information efficiently.

16. Data Types in Python

Python also provides several built-in data types that are useful for data analysis.

name = "Ade"
age = 28
salary = 150000.50
is_student = True
courses = ["Python", "Data Analysis", "Web Development"]

Here:

• name is a string.
• age is an integer.
• salary is a floating-point number.
• is_student is a Boolean value.
• courses is a list.

17. Choosing the Correct Analysis Method

The type of data influences the type of analysis an analyst can perform.

For numerical data, analysts may calculate:

• Mean
• Median
• Minimum
• Maximum
• Standard deviation

For categorical data, analysts may calculate:

• Frequency
• Percentage
• Category distribution
• Most common category

18. Practical Example

Imagine a company records the following customer information:

Name       Age    Gender     Product       Amount
Ade        28     Male       Laptop        450000
Chioma     32     Female     Phone         250000
John       24     Male       Tablet        180000
Grace      29     Female     Laptop        420000

An analyst can identify several data types:

• Name — Text
• Age — Numerical
• Gender — Categorical
• Product — Categorical
• Amount — Numerical

The analyst can then calculate average customer age, total sales,
average purchase amount and sales by product category.

19. Important Rule for Data Analysts

Never begin analysis without first understanding the data.

Before calculating statistics or building charts, ask:

• What does each column represent?
• What type of data is stored in each column?
• Are the values valid?
• Are there missing values?
• Are there duplicate records?
• Are numerical values actually stored as numbers?
• Are dates stored correctly?

Understanding these questions helps prevent incorrect conclusions.

20. Practical Exercise

Create a small dataset containing at least ten students. Include the following
columns:

• Name
• Age
• Gender
• Course
• Score
• Registration Date

For each column, identify its data type and explain why that type is appropriate.

Knowledge Check

1. What is qualitative data?
2. What is quantitative data?
3. What is the difference between discrete and continuous data?
4. What is nominal data?
5. What is ordinal data?
6. Give three examples of categorical data.
7. Give three examples of quantitative data.
8. Why is identifying data types important?
9. Give two examples of time-based data.
10. Why should a data analyst understand a dataset before analyzing it?

Key Terms

• Qualitative Data: Data describing qualities, categories or characteristics.
• Quantitative Data: Numerical and measurable data.
• Discrete Data: Countable data values.
• Continuous Data: Measurable values that can take many possible values within a range.
• Nominal Data: Categorical data without a meaningful order.
• Ordinal Data: Categorical data with an order or ranking.
• Categorical Data: Data organized into groups or categories.
• Numerical Data: Data represented using numbers.

Lesson Summary

Data can exist in many forms, and understanding its type is one of the first
skills every data analyst should develop.

The major classifications covered in this lesson include qualitative,
quantitative, discrete, continuous, nominal, ordinal, categorical, numerical,
time-based and multimedia data.

Correctly identifying data types helps analysts select appropriate tools,
clean data properly, perform valid calculations and create meaningful
visualizations.

In the next lesson, we will examine Structured and Unstructured Data
and learn how data is organized in databases, spreadsheets, files and modern
data systems.