in Technology by (1.9m points)

What is aggregation and disaggregation of data?

1 Answer

0 votes
by (1.9m points)

Suppose, we have data like below:

Eid Ename Salary Dept 2000 java 3000 .net
3.rama2500 java
Sanju 300
5.Vamshi 3000 mainframes 1000 testing 3000 tableau
4.Sanju7000 testing
vanshi 9000 tableau
1 abc 11000 Mainframes
2 bbc 13000testing
3 krishna 15000 java
4 Madhu 17000 .nte
5 vamshi

Aggregation: To display aggregate data
Sum/avg salary by each individual employee
Drag ename on column and salary on rows, and we will get the sum (salary) of each and individual employee
Now, change the measure type as Avg

Choose salary option: choose measure types as ‘Avg’

Disaggregation: To display each and every transaction

When we look at the aggregated data in the views above, each bar represents all transactions for a specific employee summed up or averaged into a single value. Now, say, we want to see the individual salary transactions for each employee. We can create a view like that by selecting Analysis > Aggregate Measures.