Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 11: Summarization (Summarize (typical functions used in each…
Chapter 11: Summarization
Summarize
can reduce both the number of columns and the number of rows
also known as group or group by
creates virtual buckets
can summarize more than one column
typical functions used in each bucket
count
sum
min
max
first
last
average
median
mode
Crosstab
uses content inside columns to create new columns
transform what is currently listed in rows to column-form
usually unknown specifically how data will be combined at the time of database design