Please enable JavaScript.
Coggle requires JavaScript to display documents.
Summarization (Summerize (Functions that can be applied to each bucket…
Summarization
Summerize
also called group/grouped by
select 1 or more columns
"Virtual bucket" for each unique group
EX: 1 Column= EmployeeID
9 unique employees
buckets for each employee
data available to be summarized
More columns= More buckets
Functions that can be applied to each bucket
Count
Sum
Min/Max
FIrst/Last
Average
Median
Mode
Std deviation
Crosstab
uses content inside columns to create new columns
Transform "skinny" data
makes data readable
common shape that data takes
Each event stored in row
no unit of analysis
must be summarized
Custumer table
Join w/ support table
new column =summary
customer support table
Reduces # of columns and rows