Analytics anyone can use.
Data prep anyone can use.
Analytics for organizations.
Cloud analytics for organizations.
Tableau Prep is a brand-new product designed to help everyone quickly and confidently combine, shape, and clean their data for analysis. With all the features available in Tableau Prep, you may ask yourself, where do I start?
We sat down with Tableau Prep product managers, Arthur Gyldenege, Anushka Anand, and Isaac Kunen to review some fundamental features that will help you build a solid baseline for approaching flows in Tableau Prep: pivoting, group and replace, join and union, aggregations, and filtering.
A common issue that arises when cleaning data is the presence of multiple values that should be a single value (such as GB and Great Britain). To deal with this in Tableau Prep, leverage the group and replace feature in a cleaning step. This feature allows you to group multiple values and replace them with a single value—essentially realiasing. For more information on how to group and replace values in Tableau Prep, watch the free training video.
With Tableau Prep, there are two main ways to combine your data—unions and joins. Watch the free training videos on joins and unions for additional resources:
Aggregating your data helps you change the level of detail of a file or a table, and this makes it easier to combine with other files and tables. Aggregate values in Tableau Prep using the Aggregate Step. You can track the results of this step in the profile pane and if you decide you want to keep more of the original fields, you can click back into the Aggregate Step and add them to the Grouped Fields area. Learn more about how to aggregate and group values in Tableau Prep.
While preparing data for analysis, you often need to filter out unwanted values or restrict the range of data you're prepping. Tableau Prep has rich filter experiences to filter ranges of numbers or dates. You can filter values using a variety of methods: use a calculation filter, a range of values filter, a range of dates filter, or a relative data filter. Add a filter by simply clicking a drop-down arrow in the profile pane.