In this Skillpill, you will learn how to use Tableau Prep to organize, clean, and transform your data to be further used in analysis and visualizations.
Data comes in all shapes and sizes, especially of different quality, which sometimes proves challenging. Imagine you must work with survey results whose questions are populated horizontally along the table, or you encounter duplicate rows or misspelled values. Tableau Prep can help organize, clean, and transform your data for further analysis and visualization.
→ In Tableau Prep Builder, connect to Sample – Global Superstore data provided by Tableau.
→ Drag and drop the Orders tab onto the flow pane
→ Add a clean step and start cleaning your data:
Use Group Values by Spelling to correct the misspelled entries from the EMEA Market column;
Remove the unneeded Discount and Profit columns by selecting them and clicking “Remove column”;
Split the Customer ID column by using Automatic Split Values;
Change the City Column data role to a Geographic City Role.
→ Drag and drop the Returns tab onto the flow pane
→ Add a clean step to look over the individual month columns, select all the month columns
→ Add a pivot step to switch the columns into the Return Date column and Return quantity new columns
→ Add an output step to give the possibility to export your clean data to a local file, Tableau published data source or write the information in a database
Here you can see the results:
Orders transformations:
Returns from this:
To this:
Watch the video tutorial here:
About btProvider:
We hold all possible technical and sales certifications for all products:
Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, and Tableau Data Management.
With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will make intelligent and strategic decisions and quickly understand the data flow, numbers, and the results it produces. See other #skillpill video tutorials here:
How to display multiple insights on a dashboard in #Tableau
How to create Stacked Bars on Grand Totals in Tableau
How to create a Buffer Zoom in a Tableau Map
Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company?
See how Tableau works, by downloading a free trial here:
How to Retrieve and Process JSON Data from a REST API in Talend Are you working as a Data Engineer, and have you started using Talend? Maybe in one of your projects, you need to retrieve data from a REST […]
💡 Unlock the Power of Tableau for Smarter Data Decisions Are you ready to transform the way you see and use data? Tableau is more than just a data visualisation tool, it’s your gateway to interactive, intuitive, and impactful business […]
You are working at a Data Analytics company, and in one of your projects, you need to load data from a source into a target table using Talend. However, while running the Talend Job, the data will fail to load […]