What is aggregation and disaggregation of data?

Question

Accepted Answer

Aggregation is the process of combining data into a summary form, while disaggregation is the opposite, breaking down summary data into its individual components.

Aggregation involves grouping data and performing calculations on the grouped data.
Disaggregation involves breaking down summary data to reveal the individual data points.
Aggregation is useful for analyzing trends and patterns at a higher level.
Disaggregation is useful for exploring detailed data and identifying outliers or specific data points.
For example, aggregating sales data by month to calculate total sales for each month, and disaggregating it to analyze sales by individual products.

Accepted Answer

aggregation is the process of summarizing the data and viewing the single numeric value.

Example: sum/avg of salary for each employee.

Disaggregation is the process of viewing each transaction for analyzing all the measures both dependently and independently.

Example: individual salary transactions for each employee.

Accepted Answer

aggregation is the process of summarizing the data and viewing the single numeric value.

Example: sum/avg of salary for each employee.

Disaggregation is the process of viewing each transaction for analyzing all the measures both dependently and independently.

Example: individual salary transactions for each employee.

What is aggregation and disaggregation of data?

AGS Health Tableau Developer interview questions & answers

Popular interview questions of Tableau Developer