Learning Outcomes

Tableau Prep is a game changer. If you clean a lot of data in Excel everyday then you need this tool. The very act of using it creates a program workflow which you can execute each day.

It's so simple to use and can save you hours if not days on your job so you have more time to do what's important.

  • Intuitive

    Data cleaning has traditionally been done on Excel where there is limited repeatability which means you have to do the same steps each day. Prep automates these cleansing steps to make your life easier.

  • Heaps of Connectors

    As with Tableau Desktop, Tableau Prep has heaps of connectors so you can connect to all sorts of data sets.

  • Visual Interface

    Visualize the individual cleaning steps so you can make adjustments on the fly. Perfect for data discovery.

Tableau Prep

    1. 08_01_Tableau Prep - Installion, Concept, Pricing

    2. 08_02_Raw Data Sets Explained - The Dirty Super Store

    3. 08_03_Loading your Data - Menu Explained

    4. 08_04_Cleaning Step - Interface Explained

    5. 08_05_Renaming Fields, Keep Only, Exclude, Data Types

    6. 08_06_Branches, Multiple Outputs, Outputting your Results - CSV, Hyper, Preview

    7. 08_07_Remapping a File to a New Location

    8. 08_08_Data Interpreter and NotePad Plus

    9. 08_09_Filtering Numbers and Strings

    10. 08_10_Grouping and Replacing

    11. 08_11_Ungrouping

    12. 08_12_Cleaning Text - Spaces, Letters, Numbers, Punct, REPLACE

    13. 08_13_Automatic and Custom Splitting

    14. 08_14_Replace with Null

    15. 08_15_Using Aggregates

    16. 08_16_Unpivotting

    17. 08_17_Introduction to Unions

    18. 08_18_Wildcard Unions

    19. 08_19_Join Types Explained Again and PDF Download

    20. 08_20_Single Join Example and your First Connection

    21. 08_21_Single Join - More Examples and Rebuilding Joins

    22. 08_24_Rounding Decimal Places, Intiger Function, Absolute

    23. 08_25_Left, Right, Mid and Concatenate

    24. 08_22_Multi-Joins and Troubleshooting

    25. 08_26_Find and Replace

    26. 08_23_If functions, isnull, not null, ifnull, and, or

    27. 08_27_Date Functions - Year, Month, Day, Now, Today

About this course

  • 27 lessons
  • 3.5 hours of video content
  • Easy Data Prep
  • Automation
  • Heaps of Connectors

What is Tableau Prep?

Visualization in the real world is always fun when you have clean data to work with. However, this is usually not the case.

Tableau Prep is a visual way to clean and prepare data that is far more efficient than standard Excel methods saving you heaps of time and automating your workflows.

Complete View of your Data

The intuitive interface gives you a complete view of your data making it easier to make data cleansing decisions.

You can clean data in seconds compared to Excel as many standard cleaning operations we perform as analysts are built in.

Instant Results

As you clean, the data updates instantly so you can see the impact of your changes. You can go back and forth, undo and redo and reorganize steps as you wish.

It's ultimately flexibility in a world where the data is constantly changing.

Test Each Step in Tableau Desktop

What better tool to use to assess your data than Tableau Desktop. In one click, you can preview the data at that individual step to ensure things are working correctly.

Like what you see? Want to become a Tableau Champion?

Simply click the link below to start your 14-day free trial

Start my 14-Day Free trial