TABLEAU INTERVIEW QUESTION : WHAT IS DISAGGREGATION AND AGGREGATION OF DATA?
MOST FAQ TABLEAU INTERVIEW QUESTION:
Question : What is disaggregation and aggregation of data?
Answer:
Suppose I have data like
Eid Ename Salary Dept
1 abc 2000 Java
2 bbc 3000 .Net
3 Krishna 2500 Java
4 Madhu 300 .Net
5 Vamshi 3000 MainFrames
1 abc 1000 Testing
2 bbc 3000 Tableau
3 Krishna 5000 .Net
4 Madhu 7000 Testing
5 Vamshi 9000 Tableau
1 abc 11000 MainFrames
2 bbc 13000 Testing
3 Krishna 15000 Java
4 Madhu 17000 .Net
5 Vamshi 19000 .Net
Aggregation : To display aggregate data
sum/Avg salary by each individual employee
1) Drag ename on columns and salary on rows we will get sum(salary) of each and individual employee
2) Now change measure type as Avg
choose salary option--Choose measure type as "Avg"
Disaggregation : To display each and every transaction
When you 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 that you want to see the individual salary transactions for each employee . You can create a view like that by selecting Analysis > Aggregate Measures.
Question : What is disaggregation and aggregation of data?
Answer:
Suppose I have data like
Eid Ename Salary Dept
1 abc 2000 Java
2 bbc 3000 .Net
3 Krishna 2500 Java
4 Madhu 300 .Net
5 Vamshi 3000 MainFrames
1 abc 1000 Testing
2 bbc 3000 Tableau
3 Krishna 5000 .Net
4 Madhu 7000 Testing
5 Vamshi 9000 Tableau
1 abc 11000 MainFrames
2 bbc 13000 Testing
3 Krishna 15000 Java
4 Madhu 17000 .Net
5 Vamshi 19000 .Net
Aggregation : To display aggregate data
sum/Avg salary by each individual employee
1) Drag ename on columns and salary on rows we will get sum(salary) of each and individual employee
2) Now change measure type as Avg
choose salary option--Choose measure type as "Avg"
Disaggregation : To display each and every transaction
When you 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 that you want to see the individual salary transactions for each employee . You can create a view like that by selecting Analysis > Aggregate Measures.
Comments