SECAI Core · phase 3 of 15 · noun

Data profiling

Determining the volume of data, the types of data and quality of the data.

The Explain card

Plain English
Data profiling is taking stock of a dataset: how much there is, what types it contains, and how good the quality is, before you build anything on it.
Example
Before training on a log archive, an engineer profiles it and discovers a month of missing records, three timestamp formats and unmasked credit card numbers.
Why it matters
Profiling finds sensitive fields that should never reach a model, and it establishes a baseline so that future poisoning or drift shows up as a change in the profile.
Hook
Inventory the warehouse before you start cooking with what is in it.

Word knowledge

How the word is built, where it came from, and what it sits beside in memory.

In a sentence

The ETL job runs data profiling on the warehouse table so the training pipeline sees null rates, mixed date formats, and unexpected enums before any weights are fit.

Why these words
  • data Latin data, things given, plural of datum names the given records the outline is drawn of, rather than a face or a person
  • profiling Italian profilo, a side-view outline, from Latin pro- plus filum, a thread supplies the outlining action, a side-view sketch of a table instead of a sitter
Where it came from
Origin
English computing collocation from Latin data (things given, plural of datum) and Italian profilo (a side-view outline), from Latin pro- (forward) plus filum (a thread)
Entered the language
late 1990s
What changed
Data had meant things given, then facts granted in an argument, then the records a machine keeps. Profiling had meant drawing a face in side view, then a biographical sketch, then a statistical outline of a person or a group. Data-warehouse vendors of the late 1990s joined the two words for the scan that inventories a table before anyone trains on it.
How it is spelled
Pattern
data stays the Latin plural of datum, even when English treats it as a mass noun
Pattern
drop silent e before -ing: profile becomes profiling
Pattern
i-e spells the long /aɪ/ in profile, as it does in file and smile
Pattern
-ing turns a verb into a noun of activity
Breaks the pattern
the noun phrase stays two words; a hyphen appears only when some styles treat it as a modifier
Breaks the pattern
data looks plural but computing English often treats it as a mass noun
Breaks the pattern
French profil gained a silent e in English, then profiling dropped it again
Breaks the pattern
phile words such as bibliophile look like cousins and are not; they come from Greek philos, lover

Spelled like

  • filing
  • compiling
  • database
  • training
Broken into chunks
  • data
    • datum
    • metadata
    • database
  • pro
    • proceed
    • propose
    • provide
  • fil
    • filament
    • filigree
    • fillet
  • ing
    • training
    • computing
    • reasoning
What it sits beside

Same subject

Same shape

Data compounds

Profiling compounds

  • DNA profiling
  • criminal profiling
  • user profiling

Where it sits in the deck

Phase 3: Data Fundamentals: Types, Pipelines, and Preparation

Models are only as good as their data — understand the raw material and the engineering that shapes it before covering how it flows or breaks.

Neighbours in this phase