Data and Its Structure

Data is everywhere—streaming from our phones, stored in business spreadsheets, and quietly recorded every time we swipe a loyalty card. Before we can make sense of any of it, we need to understand what a dataset actually looks like up close. This chapter is your first step into statistical thinking. We’ll learn to see data not as a mess of numbers, but as a carefully structured collection of stories waiting to be told.

The Big Picture#

Think of a dataset as a well-organized filing cabinet. Each drawer, each folder, each piece of paper inside has a purpose. If you don’t understand how the cabinet is arranged, you’ll never find what you need—and you might draw the wrong conclusions from what you do find. This chapter gives you the map. We’ll look at the essential questions that frame any dataset, the building blocks called cases and variables, and the different flavors of variables that dictate what we can and cannot do with them. We’ll also explore how data is collected over time, the hidden notes that give data its credibility, and the modern fields that turn raw data into decisions. By the end, you’ll have a solid mental toolkit for approaching any dataset with confidence.

The W’s of a Dataset#

Every dataset has a backstory. Ignoring that story is like reading a stranger’s diary without knowing who wrote it, when, or why—you might completely misinterpret what’s written. To avoid that, statisticians ask a set of simple questions known as the W’s:

• Who – Who or what are the individual items described by the data? These are the rows in a table, the things we are studying (people, animals, companies, transactions, etc.).
• What – What characteristics or measurements were recorded for each item? These are the columns, the pieces of information we collected.
• When – Over what time period were the data collected? Was it a single snapshot or tracked over many years?
• Where – In what geographical or organizational setting were the data gathered? This can affect whether the findings apply to other places or groups.
• Why – What was the purpose of collecting the data? Was it a scientific study, a business report, a government census? The “why” often reveals potential biases or limitations.
• How – By what method were the data collected? Survey? Sensor? Web scraping? The “how” determines data quality.

The W’s: A set of guiding questions (Who, What, When, Where, Why, How) that provide the essential context for any dataset.

Imagine a dataset containing customer purchases from an online store. Without the W’s, we just see rows of numbers. With the W’s, we know each row is a single order (Who), the columns include item price and shipping method (What), the data cover the last quarter (When), all orders shipped to Canada (Where), the purpose is to improve marketing (Why), and the data come directly from the website’s database (How). Now the numbers have meaning.

Asking these questions protects you from drawing silly conclusions. If you don’t know the data only cover winter months, you might think swimsuit sales are always low. If you don’t know the “how” was a voluntary online poll, you might trust results that are hopelessly biased. Always start with the W’s.

📝 Section Recap: The W’s (Who, What, When, Where, Why, How) give a dataset its context and help you avoid misinterpreting the information. Without them, data is just meaningless numbers.

Cases and Variables: The Rows and Columns of Data#

A dataset is usually a rectangular table. In statistics, we give special names to the rows and columns.

• A case (also called a record or row) is one individual thing we have information about. If you survey 100 people, each person is a case. If you track 50 companies’ stock prices, each company is a case.
• A variable is a feature that can differ from case to case. In a survey, age, income, and favorite color are variables. Each variable forms a column in the table.

Case: The individual unit in a dataset—one row of the data table. Variable: A characteristic recorded for each case—one column of the data table.

For a concrete example, picture a spreadsheet of five used cars for sale:

Here, each car is a case. The variables are Make, Year, Mileage, Price, and Color. The Car ID column is a special kind of variable we’ll discuss soon.

Notice that some variables are numbers we can do arithmetic with (price, mileage), while others are labels (color, make). This distinction is the heart of the next section.

📝 Section Recap: A dataset is made of cases (rows) and variables (columns). Cases are the individuals we study; variables are the attributes that differ across them.

Types of Variables: Categorical, Quantitative, and Identifiers#

Variables come in different flavors, and the flavor determines what kind of analysis makes sense. We’ll break them into three main families.

Categorical Variables#

A categorical variable puts each case into a group. The values are words or labels, not numbers that measure an amount. In the cars dataset, Make and Color are categorical. If you survey people about their preferred streaming service, the responses (“Netflix”, “Hulu”, “Disney+”, etc.) form a categorical variable.

Categorical variables split further into two subtypes:

• Nominal variables are categories with no natural order. Color (blue, red, green) and Make (Toyota, Honda, Ford) are nominal. There’s no “greater than” relationship among them—blue isn’t more than red in any numerical sense.
• Ordinal variables have categories with a clear order, but the gaps between them aren’t equal or measurable. A common example is a satisfaction rating: “Very dissatisfied”, “Dissatisfied”, “Neutral”, “Satisfied”, “Very satisfied”. You know “Satisfied” is better than “Neutral”, but you can’t say it’s exactly twice as good. Another example is education level (high school, bachelor’s, master’s, doctorate). The order exists, but the “distance” between levels isn’t a fixed number.

Nominal variable: A categorical variable whose categories have no inherent ranking (e.g., eye color, country). Ordinal variable: A categorical variable whose categories have a natural order, but the differences between categories are not defined numerically (e.g., letter grades, survey ratings).

Quantitative Variables#

A quantitative variable records a measurable amount for each case. The values are numbers on which arithmetic operations—adding, averaging, finding differences—make sense. In the cars table, Year, Mileage, and Price are quantitative. You can compute the average price or the difference in mileage between two cars.

Quantitative variables are further divided into discrete and continuous types, though we’ll explore that detail more when we study data analysis later. For now, the key is: if you can do meaningful math with the values, it’s quantitative.

Quantitative variable: A variable whose values are numbers representing a measurable quantity, where arithmetic operations like addition and averaging are meaningful.

Identifier Variables#

Some columns in a dataset look like variables but serve a very different role. An identifier variable is a label that uniquely identifies each case. In the cars table, Car ID is an identifier. Student ID numbers, social security numbers, and transaction codes are other examples. Identifiers are not analyzed statistically—you wouldn’t compute the average student ID number, because the numbers are just names. They are categorical in nature (nominal), but their sole purpose is to pick out individual rows. We keep them separate because treating them as regular variables can lead to nonsense.

Identifier variable: A variable that uniquely labels each case and is not used for statistical analysis.

Why does the variable type matter? Because it dictates the tools you can use. You can calculate a mean price (quantitative), but you cannot calculate a mean car color (categorical). You can count how many cars are red (categorical), but it makes no sense to find the average of ordinal categories without careful conversion. Recognizing variable types is a fundamental skill that prevents statistical errors.

📝 Section Recap: Variables are classified as categorical (nominal or ordinal), quantitative, or identifiers. The type determines what calculations and summaries are appropriate.

Cross-Sectional and Time Series Data#

Data can be collected in two very different ways, depending on how time is involved.

• Cross-sectional data capture a snapshot of many cases at a single point in time (or over a very short, irrelevant time window). The cars dataset is cross-sectional: we look at several cars right now. A survey of 1,000 voters’ opinions taken on one day is cross-sectional.
• Time series data track a single case (or a few cases) over many time points. For example, recording the daily closing price of one stock over five years gives a time series. The rows are dates, and the variable is the price. Another example is a country’s monthly unemployment rate over a decade.

Cross-sectional data: Data collected from many cases at approximately the same point in time. Time series data: Data collected from a single case (or a few) over many time periods, showing how something changes through time.

Some datasets combine both ideas. A panel dataset (or longitudinal data) follows the same set of cases over time. For instance, tracking the same 200 companies’ annual revenue for ten years gives a panel: each company is a case, and we have repeated measurements across years. This structure is powerful because it lets us see both differences between companies and how each company evolves.

Understanding how time is involved is crucial. With cross-sectional data, we can compare cases to each other but cannot see trends over time. With time series data, we can spot trends, seasonal patterns (like higher sales every December), and cycles, but we can’t compare many different individuals at once. The analysis techniques are different, so identifying the structure is step one.

📝 Section Recap: Cross-sectional data are a snapshot of many cases at one time; time series data follow one case over many time points. Panel data combine both by tracking multiple cases through time.

Metadata and Data Provenance#

A dataset never arrives with a perfect memory of its own origins. That’s where metadata comes in. Metadata is “data about data”—the descriptive information that explains what the variables mean, how they were coded, who collected them, and when the dataset was last updated. For example, a column labeled “Q3_Resp” might mean nothing until metadata tells you it’s the response to question 3 on a survey, coded as 1 = Yes, 0 = No.

Metadata: Information that describes the content, structure, context, and source of a dataset, making it understandable and usable.

Closely related is data provenance (or data lineage). Provenance is the recorded history of a dataset: where it came from, who has modified it, what transformations were applied, and when. If you receive a spreadsheet that’s been passed through three departments, provenance tells you the original source and every cleaning step along the way. Without provenance, you might unknowingly use data that was incorrectly filtered or merged.

Data provenance: The documented history of a dataset’s origins, ownership, and modifications, ensuring transparency and trustworthiness.

Why do these matter? Imagine analyzing sales figures for a report, only to discover later that the “sales” column actually included refunds as negative values because of a coding decision made two years ago. Metadata would have told you that. Provenance would show who made that decision and when. In professional settings, ignoring metadata and provenance can lead to expensive mistakes and damaged reputations. Always look for the data dictionary, the codebook, or the README file that accompanies a dataset. If none exists, ask for it—or create one yourself as you work.

📝 Section Recap: Metadata describes what a dataset contains, while data provenance traces its history. Both are essential for trusting and correctly interpreting data.

Data Mining, Predictive Analytics, and Business Analytics#

Once you understand the structure of data, you can start putting it to work. Three terms often appear in modern data-driven fields: data mining, predictive analytics, and business analytics. They are not the same as basic statistical analysis, but they build directly on the concepts we’ve covered.

Data mining is the process of exploring large datasets to discover patterns, relationships, or anomalies that weren’t previously known. It’s like sifting through a mountain of ore to find nuggets of gold. Data mining uses many of the same statistical tools we’ll learn, but often on a massive scale and with less initial hypothesis—it’s more about letting the data reveal surprises. For example, a supermarket might mine transaction records to find that people who buy diapers on Friday evenings also tend to buy beer. That’s a pattern no one may have predicted.

Data mining: The exploratory analysis of large datasets to uncover hidden patterns, correlations, and insights without a pre-specified hypothesis.

Predictive analytics goes a step further: it uses historical data to build models that forecast future outcomes. While data mining might find that certain customer behaviors are linked, predictive analytics builds a formula to estimate the probability that a new customer will churn next month, or the expected sales next quarter. It’s naturally forward-looking and relies heavily on the structure of variables we’ve discussed—especially quantitative and categorical predictors.

Predictive analytics: The use of statistical models on historical data to make predictions about future events or unknown outcomes.

Business analytics is the broader umbrella that covers both, applied specifically to business decision-making. It involves collecting, cleaning, analyzing, and interpreting data to guide strategy, improve efficiency, and increase profit. A business analyst might use data mining to segment customers, then apply predictive analytics to forecast lifetime value, all while carefully documenting metadata so the whole team trusts the results.

Business analytics: The systematic use of data, statistical analysis, and quantitative methods to drive business planning and decisions.

These fields are not separate from statistics—they are built on top of it. The foundation, however, is always the humble dataset. No matter how advanced the algorithm, if the cases are misidentified, the variables are misclassified, or the provenance is murky, the results will be unreliable. That’s why this chapter is where everything begins.

📝 Section Recap: Data mining finds hidden patterns, predictive analytics forecasts future outcomes, and business analytics applies these tools to business decisions. All depend on a well-structured, well-understood dataset.

Summary#

We’ve taken a first, careful look at what a dataset really is—not just a grid of numbers, but a structured story with characters (cases), attributes (variables), a timeline, and a backstory. You now know to ask the W’s before diving in, to distinguish between categories and quantities, to spot identifiers that shouldn’t be analyzed, and to read the hidden notes that give data its credibility. These skills are the bedrock of every statistical analysis you’ll ever do, whether you’re summarizing a simple survey or building a predictive model for a business. Keep this mental checklist handy, and you’ll always start on solid ground.