0
What is aggregation and disaggregation of data?

Open 1 Answers 24 Views Technology

What is aggregation and disaggregation of data?

1 Answer

0

Suppose, we have data like below:

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

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.

by (250k points)
...