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 E...

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.

Related

TABLEAU INTERVIEW QUESTIONS 5049952212531241979

Post a comment

emo-but-icon

Follow Us

Recent

Comments

Donate

Side Ads

Text Widget

Connect Us

Sql Server 2017 Interview Questions
Sql Server Basic Interview Query Set-1
Sql Server Basic Interview Query Set-2
Sql Server Date-Time Interview Query SET-3
Sql Server Salary Interview Query SET-4
Sql Server Group By Interview Query SET-5
Sql Server Join Interview Query SET-6
Sql Server Tricky Join Interview Query SET-7
Sql Server DDL Interview Query SET-8
Small but very Tricky Sql Server Query SET-9
Very Much Tricky Query (not 4 fresher)SET-10
Sql Server Complex Interview Query SET-11
Sql Server Datatype Interview Questions
Sql Server View Interview Questions
Sql Server Index Interview Questions
TCS Tricky Sql Interview Queries
HCL Sql Interview Queries
Sql Server SP Interview Questions
Sql Server Trigger Interview Questions
Sql Server Temp Table Interview Questions
Sql Server 2016 Interview Questions
Sql Server Performance Tuning Interview Q.
Sql Server Constraints Interview Questions
Sql Server Storage/Size Interview Questions
Sql Server Very Basic Interview Questions
Sql Server Quiz for Fresher
Sql Server Icon Quiz for All
Sql Server 300+ Theoretical Interview Questions
Sql Server Complete Set

ASP.NET AND JQUERY INTERVIEW QUESTION
ASP.NET: Web Config Interview Question
ASP.NET: View State Interview Question
ASP.NET: Session Interview Question
ASP.NET: Session Interview Question 
ASP.NET: Security Interview Question
ASP.NET: Catching Interview Question
C# OOPS Interview Question
MORE Interview Question
JQUERY: Interview Question Set-1
JQUERY: Interview Question Set-2
JAVA-SCRIPT: Interview Question Set-1
JAVA-SCRIPT: Interview Question Set-2
ASP.NET MVC: Interview Question Set-1

POPULAR POSTS
10 MOST DIFFICULT INTERVIEW QUESTIONS
5 BEST INTERVIEW TIPS
YOUR 10 MISTAKE DURING INTERVIEW
2016 TOP 20 GROUP DISCUSSION TOPICS
HOW SQL PERFORMANCE AFFECTED BY DATATYPE
item