0 votes
14 views

What is aggregation and disaggregation of data?

in Technology by (186k points)

1 Answer

0 votes

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 (186k points)

Related questions

0 votes
1 answer 17 views
0 votes
1 answer 42 views
0 votes
1 answer 14 views
14 views asked Nov 1, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 13 views
13 views asked Nov 1, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 10 views
10 views asked Oct 30, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 19 views
19 views asked Oct 29, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 21 views
0 votes
1 answer 21 views
0 votes
1 answer 15 views
15 views asked Oct 30, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 29 views
0 votes
1 answer 20 views
0 votes
1 answer 14 views
0 votes
1 answer 24 views
0 votes
1 answer 25 views
0 votes
1 answer 29 views
0 votes
1 answer 24 views
0 votes
1 answer 16 views
0 votes
1 answer 19 views
19 views asked Nov 1, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 17 views
0 votes
1 answer 14 views
0 votes
1 answer 24 views
24 views asked Oct 29, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 38 views
...