Business analysis glossary
Aggregate Function
What it is
An aggregate function calculates one value from many rows, such as COUNT for the number of rows, SUM for a total, AVG for an average, MIN and MAX for the smallest and largest values. It is often used with GROUP BY to produce one result per group.
Why it matters
Almost every business metric is an aggregate: total sales, number of claims, average handling time. Analysts must know how each function treats empty values and duplicates, because COUNT of a column ignores NULLs while COUNT of all rows does not, which can change a reported number noticeably.
Example
Asked for the average refund amount, the analyst notices that AVG ignores refunds stored as NULL, which are pending refunds with no amount yet. She agrees with finance to report the average of completed refunds only, and states that rule clearly next to the number in the dashboard.