Okuzeka
Data Science & Analytics vocabulary · SQL and Querying

Filter

Meaning in data science & analytics, with examples

/ˈfɪltər/verbCore term

In data science & analytics, filter means: To keep only the rows of data that meet certain conditions, such as orders from 2024 or users in Turkey, and leave out the rest.

In Turkish: filtrelemek, süzmek, filtre

How it is used

In SQL you filter with WHERE, or with HAVING after grouping; in dashboards users choose filters from drop-down menus. You filter by something and filter out what you don't want. Also a noun: 'add a filter'.

Example sentences

  1. Filter out test accounts before you calculate the conversion rate.

  2. The dashboard is filtered to last month by default.

Common collocations

  • filter by
  • filter out
  • apply a filter
  • date filter
  • SQLShort for Structured Query Language: the standard language for reading, filtering, combining and changing data stored in relational databases and data warehouses.
  • queryA request for specific data from a database, usually written in SQL; as a verb, to ask a database or dataset for that data.
  • dashboardA screen that shows the most important charts and numbers about a business or system in one place, usually updated automatically.
  • segmentA group of customers or users who share certain characteristics, such as country, device or buying behaviour; as a verb, to divide data into such groups.

This word in other fields

The same English word can have a different meaning in another field:

More terms: SQL and Querying

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: