Trifacta Wrangler was designed from the ground up to help reduce data cleaning and data preparation time for data mining and predictive analytics by enabling better assessment of data sources, offering smart extraction that learns preferences over time, and providing easy to use, intelligent, interactive, visual data analysis that improves data understanding for your entire organization. Data aggregation tools built into Trifacta’s Data Wrangler, include:
Roll-up or summary tools, which calculate summaries and report only those. This reduces the overall size of your dataset and makes it easier to share with others in the organization who can leverage it for their own insights.
Intermediate calculation tools, which allow you to calculate a value based on an aggregation and include that value in the dataset. For example, an analyst might use aggregation to determine the average cost of a transaction and then use that value to calculate the deviation between individual transactions and the average cost. The idea is to add the value to the existing dataset, instead of reducing the size of the data file, which is the purpose of the roll up tool.
To learn more about how Trifacta’s data aggregations tools can help you, download the Principles of Data Wrangling eBook.