Tableau Prep is very useful when it comes to quick analyzing data. It is much more easier than Alteryx and it can take you less than 5 minutes to do everything.
Today, I wanted to recreate the following youtube video to check how many minutes it will take me to aggregate some measures. It took me less than 3 minutes to aggregate the measures.
I first started by connecting the data (created by me) in Tableau Prep. Then I've opened a Clean Step to view the data.
![](https://www.thedataschool.co.uk/content/images/2022/08/image-380.png)
This is how my data looked after adding the Clean Step:
![](https://www.thedataschool.co.uk/content/images/2022/08/image-384.png)
After analyzing the data (checked for any errors/ mistakes) I've opened an Aggregate field and put the Region on the Grouped fields and the Sales in the Aggregated Fields.
![](https://www.thedataschool.co.uk/content/images/2022/08/image-381.png)
You can see that Tableau Prep did a very good job in calculating the sum of sales for each region.
![](https://www.thedataschool.co.uk/content/images/2022/08/image-444.png)
You can also group by two or more fields while aggregating measures. In the example from above I clicked on the aggregated amount (150,000) to check which grouped fields it belongs. For example, the 150,000 sales belongs to the East Region and the sales person was Addy.
![](https://www.thedataschool.co.uk/content/images/2022/08/image-445.png)
You also have the Sum, Average, Median, Count etc. functions in your Aggregated Fields.