No history yet

Data Fundamentals

What Is Data, Really?

At its core, data is simply a collection of facts. It can be numbers, words, measurements, or observations. Think about your contact list on your phone. Each entry—a name, a phone number, an email address—is a piece of data. Businesses rely on data for everything from tracking sales to understanding customer behavior.

Data generally falls into two main categories: structured and unstructured.

Structured data is highly organized and formatted in a way that makes it easily searchable. It fits neatly into rows and columns, like a spreadsheet or a database table. This organization makes it straightforward for computers to process and analyze.

Customer IDFirst NameLast NameEmail
101JaneSmithjane.s@email.com
102JohnDoej.doe@email.com
103AlexRayalex.ray@email.com

The table above is a perfect example of structured data. Each piece of information has a specific place and follows a consistent format.

Unstructured data, on the other hand, has no predefined model or organization. It's the messy, complex information that makes up most of the digital world. Think of emails, social media posts, photos, videos, and audio files. While it's rich with valuable insights, its lack of structure makes it more challenging to search and analyze.

Lesson image

Where Data Comes From

Data is generated from countless sources, which can be grouped into two broad categories: internal and external.

Internal sources are those that exist within an organization. This includes customer information from a CRM system, sales figures from financial records, and employee data from HR databases. This data is typically created through the company's own operations.

External sources come from outside the organization. Examples include market research reports, government statistics (like census data), social media feeds, and information from business partners. This data provides context about the world outside the company's walls.

Why Good Data Matters

Not all data is created equal. The usefulness of data depends entirely on its quality and integrity. Data quality refers to how reliable and fit for purpose the data is. There are a few key dimensions to consider:

  • Accuracy: Is the data correct? An incorrect customer address is inaccurate.
  • Completeness: Is all the necessary data present? A customer record without a phone number is incomplete.
  • Consistency: Does the data conflict with other data? If a customer's age is listed as 35 in one system and 53 in another, the data is inconsistent.
  • Timeliness: Is the data up-to-date? Using last year's sales figures to make decisions for this quarter is not timely.

Poor-quality data leads to flawed analysis, bad decisions, and wasted resources. It's a classic case of "garbage in, garbage out."

Data integrity goes a step further. It's about maintaining the quality and consistency of data throughout its entire lifecycle. This means protecting data from accidental or intentional changes, ensuring it remains accurate and trustworthy over time.

Handling the Flow of Data

To make data useful, it must be processed. This involves a few fundamental steps: collection, storage, and retrieval.

Data Collection is the process of gathering raw data from various sources. This can be done through manual entry (like filling out a form), automated sensors (like a thermostat), or by extracting it from websites or documents.

Data Storage is the next step. Once collected, data needs a safe and organized place to live. This could be a simple spreadsheet for a small amount of information or a complex database for large-scale operations. The goal is to store data in a way that keeps it secure and easy to access.

Database

noun

An organized collection of structured information, or data, typically stored electronically in a computer system.

Data Retrieval is the process of accessing the data from its storage location. When you look up a contact on your phone, you're retrieving data. For businesses, this might involve running a query to pull a sales report from a database. Efficient retrieval is key to making timely, data-informed decisions.

Fundamentals are key. Understanding the core principles of database technology, including data modeling, system architecture, and query languages, is crucial for anyone involved in designing, using, or implementing these systems.

Let's check your understanding of these core concepts.

Quiz Questions 1/5

Which of the following is the best example of unstructured data?

Quiz Questions 2/5

A company analyzes its own sales receipts from the past quarter to identify popular products. What type of data source is this?

These building blocks—understanding what data is, where it comes from, why its quality is critical, and how it's handled—form the foundation of all data management.