Okuzeka
Data Science & Analytics vocabulary · SQL and Querying

Aggregate

Meaning in data science & analytics, with examples

/ˈæɡrɪɡeɪt/verbCore term

In data science & analytics, aggregate means: To combine many rows of data into summary values, such as totals, counts or averages, usually grouped by a category such as day, product or region.

In Turkish: toplulaştırmak, özetlemek, gruplayarak hesaplamak

How it is used

In SQL this is done with functions such as SUM, COUNT and AVG together with GROUP BY. You aggregate data by a category or to a level ('aggregate to weekly'). The nouns 'aggregate' and 'aggregation' are also common.

Example sentences

  1. Let's aggregate the events by day before we plot them.

  2. The dashboard shows aggregated numbers, so you can't see individual customers.

Common collocations

  • aggregate by
  • aggregate to monthly
  • aggregated data
  • aggregate function
  • SQLShort for Structured Query Language: the standard language for reading, filtering, combining and changing data stored in relational databases and data warehouses.
  • granularityThe level of detail in data, meaning what one row represents, for example one row per order, per customer per day or per store per month.
  • pivot tableA table that summarises a larger dataset by grouping rows and columns by categories and calculating totals, counts or averages for each combination.
  • summary statisticsA small set of numbers that describe a dataset at a glance, such as the count, mean, median, minimum, maximum and standard deviation of each column.

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: