Tableau Prep Masterclass

Name: Tableau Prep Masterclass
Rating: 3.9 (18 reviews)

Master Tableau Prep for Data Analytics step-by-step. Real-Life Exercises. Learn by doing!

Created bySiddharth Pawar

Last updated 1/2025

English

English [Auto],

What you'll learn

In this course, I'll walk you through the basics of Tableau Prep, from installing your free trial to connecting to various data sources, performing a complex transformation and developing multi-source workflows.
This course does not require any prior knowledge of Tableau Prep. You should be comfortable with data transformation and reporting, using tools such as Microsoft Excel, everything else you'll pick up with the way in this course.
This course is perfect to kickstart your path to becoming a Tableau Prep developer, you'll learn all the basics in this course, and will be able to apply your knowledge in the real world, immediately.

Course content

8 sections • 21 lectures • 2h 52m total length

Course Introduction5:43
This course introduction explains how unclean data wastes time and money and shows Tableau Prep as a solution for data preparation in analytics.
Technical specs, Installation and Pricing3:21
Discover Tableau Prep's technical specs and installation on Windows or Mac, explore 64-bit and 32-bit requirements, and review the evolving pricing options for individual and company use.
How Prep is different from other ETL tools4:59
Showcases Tableau prep as a drag-and-drop, no-code etl tool that differs from others by connecting to many data sources, writing back to databases, and enabling quick analysis.
Quick look on product features and Interface Walk-through23:13
Explore Tableau Prep features and interface through a quick walk-through, learning to join and union multiple data sources, clean and aggregate data, and preview results for ready analytics.

Introduction to Input Step11:03
Explore the input step in Tableau Prep, connecting to data sources like Excel, selecting fields, and applying unions and joins to prepare clean, ready-for-analysis data.
Data Interpreter8:16
Use data interpreter to clean and transform messy Excel data, auto-detect headers, remove whitespace, and structure multiple tables for analysis.
Union data from different data sources8:49
Master how to union data from different sources in Tableau Prep, combining files with the same structure across folders and years using wildcard unions and live previews.
Modify your data3:49
Master basic data modification in Tableau Prep by renaming columns, changing data types, and removing unwanted columns. Apply calculated fields for filtering and conditional logic.

Information about your data - Data types5:05
Select appropriate data types for each column to optimize the data source, using integers for IDs and quantities, decimals for money or discounts, and dates for date fields.
Search, Highlight and relevant values4:27
Explore search, highlight, and identify relevant values in Tableau Prep using a sample superstore to filter, sort, and examine distribution across regions and dimensions.
Filter and sort data5:05
Explore how to filter data by region and conditions, handle nulls, and apply top-to-bottom sorting and outlier detection in Tableau Prep Masterclass.
Profile pane6:10
the profile pane in tableau prep masterclass introduces data understanding and editing features, showing how to view, sort, explore distributions, identify outliers, and drag and drop to create new columns.

Introduction to cleaning step9:18
Learn how to clean and transform data in Tableau Prep's clean step, perform basic data transformations, rename and type cast fields, filter, rearrange columns, and output ready for analysis.
Pivot your data7:45
Pivot your data in Tableau Prep to transform unstructured data into a tidy format, consolidating fields into product and sales columns, then use clean steps to prepare output for charts.
Align data with Aggregate Step7:37
Explore how to aggregate data in Tableau Prep Masterclass to control level of detail, using aggregate functions to roll up sales, discount, and profit by country, state, or region.

Remove inaccuracy with Group and Replace7:13
Learn to clean data in Tableau Prep by using the group and replace feature to fix misspellings and pronunciation errors, with manual and automatic options to consolidate variants across sources.
Introduction to Union Step8:11
Learn to combine data with the union step in Tableau Prep, dragging and dropping two tables with matching structures, handling mismatches, and creating a unified view from sample superstore data.
Introduction to Join Step4:33
Explore joins in tableau prep, including inner and other join types, across multiple data sources. Drag tables into the join area, identify primary and foreign keys, and review results.

Requirements

This course is for everyone who is either completely new or a beginner with Tableau Prep.
Understanding of Tableau product family is defiantly an advantage.

Description

Tableau Prep is the latest product from Tableau, designed to simplify complex ETL (Extract, Transform, Load) tasks without the need for coding. This course is structured to provide extensive hands-on experience, which is crucial for quickly grasping new concepts and applying them effectively. By engaging with practical exercises, you'll be able to understand and master the various features and functionalities of Tableau Prep in a more intuitive and interactive manner.

One of the key benefits of this course is its focus on real-time problem-solving. Through project-based learning, you will be exposed to real-world scenarios that require you to apply the skills and knowledge you've acquired. This approach not only reinforces your learning but also equips you with the ability to tackle similar challenges in a professional setting.

By the end of the course, you will have a comprehensive understanding of how to use Tableau Prep to manage and streamline data preparation processes. Whether you are new to data analytics or looking to enhance your existing skills, this course will provide you with the tools and confidence needed to excel in the field. With Tableau Prep, you can efficiently handle data preparation tasks, making your data analysis workflow more efficient and effective.

The course is structured in such as way as to guide you step by step through the process of ETL data with Tableau Prep. We'll begin with connecting to your data and understanding basic steps. We'll look at the best ways of harmonizing data. We'll look at ways to analyse the data using data analytics. And we will put it all together into a project view.

For details on the full course, Please have look at Curriculum.

Let's decide if this course is right for you.

Have you recently started, or are you planning to start, using Tableau Prep at your work?
Are you looking to quickly build your skills in Tableau Prep?
Are you Tableau desktop developer ?

If you answered YES, then this course is for you!

Who this course is for:

Anyone who is completely new to Tableau Prep and ETL.
Anyone who is a beginner with Data analytics and would like to explore more of the tools available.

​Tableau Prep Masterclass

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 37min

Input step to identify the data that you want4 lectures • 32min

Understanding data4 lectures • 21min

Clean and transform data3 lectures • 25min

Combine and Merge data3 lectures • 20min

Save your flow1 lecture • 8min

Project/Introduction to the advanced business problem1 lecture • 19min

Best practices for unclean data1 lecture • 10min

Requirements

Description

Who this course is for:

Tableau Prep Masterclass