in Technology by

What is aggregation and disaggregation of data?

1 Answer

0 votes
by

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.

Related questions

0 votes
    Explain the disaggregation and aggregation of data in Tableau?...
asked Nov 1, 2020 in Technology by JackTerrance
0 votes
    Which of the following query is not included in Aggregation query? (1)Timeseries (2)GroupBy (3)TopN (4)Time Boundary...
asked Aug 26, 2021 in Technology by JackTerrance
0 votes
    What is meant by Incremental Aggregation in Informatica?...
asked Jun 7, 2021 in Technology by JackTerrance
0 votes
    To implement a custom untyped user-defined aggregation function, the user has to extend the ... 2. UserDefinedAggregateFunction 3. UDFAggregateFunction 4. UserDefinedFunction...
asked Oct 22, 2020 in Technology by JackTerrance
0 votes
    I have two collection vmdetails and rsc_installtion_status , i want to select the documents from rsc_installtion_status ... Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 2, 2022 in Education by JackTerrance
0 votes
    Q.2 Which mode of IPsec should you use to assure the security and confidentiality of data within the same LAN? A. ESP ... AH transport mode C. AH tunnel mode D. ESP tunnel mode...
asked Mar 12, 2023 in Technology by JackTerrance
0 votes
    Views stores the data and you can refresh it on timely bases a. False b. True...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    How do you ensure data accuracy and consistency in BI systems?...
asked Feb 4, 2023 in Technology by JackTerrance
0 votes
    Can you explain the difference between Data Warehousing and Business Intelligence?...
asked Feb 4, 2023 in Technology by JackTerrance
0 votes
    Which of the following reads a data.frame and creates text output referring to the Google Visualization API? (a ... gvisTimeLine (c) gvisAnnotatedTimeLine (d) none of the mentioned...
asked Oct 5, 2021 in Technology by JackTerrance
0 votes
    The horizontal scaling approach tends to be cheaper as the number of operations, and the size of the data increases. 1. True 2. False...
asked Sep 6, 2021 in Technology by JackTerrance
0 votes
    ________ are used to represent data stores and compute resources that contains the connection strings. (1)Linked services (2)Pipeline (3)Dataset (4)Datastore...
asked Sep 1, 2021 in Technology by JackTerrance
0 votes
    ______ stores longer lived control data like component IP addresses and distributed locks. (1)Bulletin Board System (2)Consul (3)NATS (4)All the options...
asked Aug 24, 2021 in Technology by JackTerrance
0 votes
    What is big data and list its characteristics?...
asked Aug 2, 2021 in Technology by JackTerrance
0 votes
    A _________ in Kafka reads streams of data from input topics, processes this data and produces continual streams of ... Stream processor (2)Consumer (3)Consumer group (4)Producer...
asked Jun 16, 2021 in Technology by JackTerrance
...