Aggregation of data is a process that we’re implicitly performing every time we drag a reporting dimension in the field Values. However, when you create complex reports, it is useful to use functions for aggregation (SUM, AVERAGE, COUNT) to create measures that will be used in the report. Once thought out measures may be used as a building block to create complex DAX expressions.
In one of the earlier „recipes“ I briefly described the statistical functions in Excel. My knowledge of statistics is quite modest (one of these days will probably take some additional lessons to improve my knowledge). However, I would like to dedicate one article to this area. On a practical case, the analysis of wages in a small company, I’ll show you how you can use these functions to make you come up with some interesting conclusions.
When making extensive reports, there is often a need to calculate subtotals by reporting categories. Subtotals are, most of the time, sums and they might also be an average, a minimum, a maximum, a product, or a count of articles within a report. Subtotals can be made manually and in this „recipe“ it will be about how to use Excel for automatically adding subtotals.
Iako Excel ima manje mogućnosti nego specijalizovani softveri za statističku obradu podataka kao što je SPSS, on poseduje mnoštvo statističkih funkcija što ga čini moćnim alatom. Njih možete da iskoristite za analizu poslovnih izveštaja, a imaju primenu i u svim drugim oblastima gde se statistika koristi kao alat za analizu podataka.
Aggregation is a term that signifies unification and calculation. It combines one or more data sets, which are given as function arguments, for performing a mathematical operation. This may be: summing up a series of data, counting, averaging, calculating the minimum or maximum value of a given set of numbers… Aggregate functions are very commonly used and should know them well.