What is aggregation and disaggregation of data?

1.	What is aggregation and disaggregation of data?
Answer» Aggregation of data means displaying the measures and dimensions in an AGGREGATED form. The aggregate functions available in the Tableau tool are: SUM (expression): Adds up all the values used in the expression. Used only for NUMERIC values. AVG (expression): Calculates the average of all the values used in the expression. Used only for numeric values. Median (expression): Calculates the median of all the values ACROSS all the RECORDS used in the expression. Used only for numeric values. Count (expression): Returns the number of values in the SET of expressions. Excludes null values. Count (distinct): Returns the number of unique values in the set of expressions. Tableau, in fact, lets you alter the aggregation type for a view. Disaggregation of data means displaying each and every data field separately.

Answer»

Aggregation of data means displaying the measures and dimensions in an AGGREGATED form. The aggregate functions available in the Tableau tool are:

SUM (expression): Adds up all the values used in the expression. Used only for NUMERIC values.
AVG (expression): Calculates the average of all the values used in the expression. Used only for numeric values.
Median (expression): Calculates the median of all the values ACROSS all the RECORDS used in the expression. Used only for numeric values.
Count (expression): Returns the number of values in the SET of expressions. Excludes null values.
Count (distinct): Returns the number of unique values in the set of expressions.

Tableau, in fact, lets you alter the aggregation type for a view.

Disaggregation of data means displaying each and every data field separately.

Discussion