Tableau Prep: Data Cleaning, Joins, Pivots & Flows

3-2: TABLEAU PREP

SOMETIMES THE DATA WE USE IS IN SUCH A BAD STATE, IT'S UNUSABLE.

TABLEAU PREP GIVES US ADVANCED CAPABILITY TO GET BACK ON TRACK TO DO WHAT WE DO BEST, CREATE ART!

Buy $99.00 QUICK PREVIEW

TESTIMONIALS

★★★★★ Benjamin H L.

This class is awesome and so well taught. Thank you for making me find a new passion

★★★★★ Alycia M T.

I love the way he teaches! I needed to understand this package quick, fast and in a hurry. I also needed the information to be delivered in a clear, concise, logical and complete manner. He accomplished all of the above! Prayers answered!

★★★★☆ Samyuktha S.

It was indeed a good course basics for beginners . easy to keep in mind and some humour in between to engage the audience. I really liked this course. Thank you

★★★★☆ Tanzina Nasrin T.

It is very helpful for me because it teaches how to use the Tableau and data analysis. So I am really thankful for this course.

★★★★★ Lee Boon F.

Friggin Cool! I'm learning Tableau hoping to get certified one day and bump up my salary with this tool. I like the way you speak!

★★★★★ Tijani Dada S.

Absolutely amazing stuff. Good job, this is Tableau made simple for beginners.

★★★★★ Weiling L.

Good match for a total beginner in Tableau like me :) Appreciate the patient and thoroughness

★★★★★ Richard B.

Definitely recommend this course for anyone starting to learn Tableau. Well explained and easy to follow

★★★★★ Thalia Renee Quijano C.

Yes, this is my first time using Tableau and this course sets the foundation to understand the essentials of this program.

★★★★★ Shweta R.

The course content was very easy to understand for a beginner level. The style of presentation is very interesting and user- friendly. This is my first tutorial to Tableau and I am already developing a very keen interest in the tool.

CONSIDER THE FULL COLLECTION AND SAVE $1,300

14 BONUS COLLECTIONS. LIFETIME ACCESS. ONE CONVENIENT PACKAGE.

TELL ME MORE ABOUT THIS EXCLUSIVE DEAL I'M READY TO SAVE $1,300

LEARNING JOURNEY

1. Tableau Prep Introduction
2. ChatGPT Support
1. 01_01_Introduction to Data Cleaning and Preparation - Demo
  FREE PREVIEW
2. 01_02_Downloading and Installing Tableau Prep (Links)
3. 01_03_The Trouble with Manual Cleaning in Excel
  FREE PREVIEW
4. 01_04_Excel vs Tableau Prep
5. QUIZ: Tableau Desktop vs. Prep
1. 02_01_Loading an Excel File - Interface Explained (Attachment)
  FREE PREVIEW
2. 02_02_Loading CSV Files - Interface and Delimitters (Attachment)
3. 02_03_CSV with Text Qualifiers
4. 02_04_Data Interpreter (Attachment)
  FREE PREVIEW
5. QUIZ: Data Interpreter Purpose
6. 02_05_Updating Connections (Attachment)
7. 02_05a_Special Note - Re-establishing Connections for Assignments
  FREE PREVIEW
8. 02_06_Building Our First Flow using Clean Step (Attachment)
9. 02_07_Tableau Ecosystem (Attachment)
  FREE PREVIEW
10. QUIZ: Benefit of Flow-Style Cleansing
1. 03_01_Beginner Data Set Explained
  FREE PREVIEW
2. 03_02_Reading the Clean Step Interface - Sorting, Reordering, Change Log
3. 03_03_Renaming Fields, Organising Steps, Renaming Steps and Providing Descriptions, Build Life Cycle
4. 03_04_Keep and Exclude Fields, Rearranging your Flow, More on the Change Log
  FREE PREVIEW
5. 03_05_Branching Basics, Upper, Lower and Title Case, Trimming, Removing Extra Spaces and Removing al
6. 03_06_Splitting Fields - Automatic vs Custom
  FREE PREVIEW
7. QUIZ: Benefit of Change Log
8. 03_07_Cleaning Text - Remove Letters, Numbers and Punctuation _ Duplicate Field
9. 03_08_Filtering Row Entries
  FREE PREVIEW
10. 03_09_Renaming Individual Rows, Manual Grouping, Ungrouping, Creating New Fields with Duplicate and
11. 03_10_Identifying Duplicate Rows - Important Factors to Consider
12. QUIZ: Aggregates for Duplicates
13. 03_11_Filtering Dates - Selected Values, Range of Dates, Relative Dates
  FREE PREVIEW
14. 03_12_Converting Dates - DatePart Calculation - Preview in Tableau Desktop
15. 03_12a_Filtering Numbers and Strings - Selected, Range, Wildcard
16. 03_13_Assignment - Custom Calculations (Problem)
  FREE PREVIEW
17. 03_14_Assignment - Custom Calculations (Solution) (Attachment)
1. 03_15_Getting Started with Calculated Fields - Basic Arithmetic
2. 03_15a_Rounding, Integer, Absolute, Sign
3. 03_16_Len, Find, Contains, Findnth
  FREE PREVIEW
4. 03_17_Left, Right, Mid
5. 03_18_Replace, Startswith, Endswith
6. 03_19_Date Functions - Day, Month, Year, Today and Now
7. 03_20_MakeDate, MakeTime, MakeDateTime - Nested Functions Theory
  FREE PREVIEW
8. QUIZ: Importance of Cleaning Data
1. 04_01_The Basic Concept of Aggregate Functions with an Excel Demo
  FREE PREVIEW
2. 04_02_Basic Aggregation Types in Tableau Prep - Creating multiple Branches - SUM, MAX, MIN, COUNT, D
3. 04_03_Grouping by More than One Field
4. 04_04_Aggregating Over Dates - Using Convert Dates Feature - Day(), Month(), Year()
5. 04_05_Comparing Two Aggregates - Building Full Flows - Multiple Aggregate Steps
  FREE PREVIEW
6. 04_06_Applying Aggregates in Interesting Ways - Aggregates of the Aggregate
7. QUIZ: Common Types of Aggregates
8. 04_07_Assignment 1 - Aggregates (Problem)
9. 04_08_Assignment 1 - Aggregates (Solution) (Attachment)
  FREE PREVIEW
10. 04_09_Assignment 2 - Aggregates (Problem)
11. 04_10_Assignment 2 - Aggregates (Solution) (Attachment)
1. 05_01_Pivot and Table Structure Explained - Advantages and Disadvantages
  FREE PREVIEW
2. 05_02_More Examples of Advantages and Disadvantages of Pivot vs Table
3. 05_03_Table to Pivot, Pivot to Table
4. 05_04_WARNING. Unpivoting can cause Numerical Duplicates and Errors
  FREE PREVIEW
5. 05_05_Pivoting off Calculated Fields - Learning Iteration Design
6. 05_06_Date Truncation followed by Pivot Analysis
7. 05_07_Multi-Level Pivot - HACK Methodology
  FREE PREVIEW
8. QUIZ: Advantage of Pivot Structure
9. 05_08_Assignment - Pivots (Problem)
10. 05_09_Assignment - Pivots (Solution 1)
11. 05_10_Assignment - Pivots (Solution 2)
  FREE PREVIEW
12. 05_11_Assignment - Pivots (Solution 3) (Attachment)
1. 06_01_Unions Theory - Excel Example in Action (Attachment)
2. 06_02_Data Sets Explained - Union in Flow (Attachment)
3. 06_03_Unions using Wildcard
  FREE PREVIEW
4. 06_04_Wildcard Method for Sheets inside an Excel File
5. 06_05_Unions on Load - Sub-Folders (Attachment)
6. 06_06_Mismatched Fields and Merging (Attachment)
  FREE PREVIEW
7. 06_07_Dealing with Mismatched Fields in a Union Flow Step
8. QUIZ: Unions in Tableau Prep vs Excel
9. 06_08_Assignment - Unions (Problem 1) (Attachment)
  FREE PREVIEW
10. 06_09_Assignment - Unions (Solution 1) (Attachment)
11. 06_10_Assignment - Unions (Solution 2) (Attachment)
12. 06_11_Assignment - Unions CURVEBALL - (Problem) (Attachment)
  FREE PREVIEW
13. 06_12_Assignment - Unions CURVEBALL - (Solution) (Attachment)
1. 07_01_Basic Join Theory (PDF Attach) - One to One Relationships
  FREE PREVIEW
2. 07_02_Simply One-to-One Join in Action - Data Set Explained (Attachment)
3. 07_03_Simply One-to-One Join in Action - Reading the Join Interface Summary
4. 07_03a_One to One, Many to Many and More
5. 07_04_Multi-Field Joins - Data Set Explained (Attachment)
  FREE PREVIEW
6. 07_05_Multi-Field Joins - Why Duplicates Generate (Excel Example) + Quality Analysis
7. 07_06_Quality Gates - Using Aggregates for Testing - Concatenate Trick
8. 07_07_Multi-Field Joins - Left, Inner and Right
9. 07_08_Multi-Field Joins - Left, Inner and Right - Building Flows to Handle Each
  FREE PREVIEW
10. 07_09_One to Many Joins (Attachment) - Error Build Up - Validation
11. 07_10_Many to Many Relationships (Attachment)
12. QUIZ: Considerations for Many-to-Many Joins
13. 07_11_Split Off to Aggregate and then Join back to Flow (Attachment)
  FREE PREVIEW
14. 07_12_Data Normalization (Attachment)
15. QUIZ: Types of Joins
16. QUIZ: Where to Perform Joins
17. 07_13_Assignment - Joins (Problem) (Attachment)
  FREE PREVIEW
18. 07_14_Assignment - Joins (Solution) (Attachment)
1. 08_01_Welcome to the Intermediate Section
1. 08_02_Project Brief - Part 1 (Attachment)
2. 08_03_Project Brief - Part 2
  FREE PREVIEW
3. 08_04_Unioning the Data Sets (Attachment)
4. 08_05_Full Name Concatenation and Cleaning Sign Up Date (Attachment)
5. 08_06_Phone Number Clean Up (Attachment)
6. 08_07_Unioning the Prod Data (Attachment)
  FREE PREVIEW
7. 08_08_Union Field Name Clean Up and Full Name Clean (Attachment)
8. 08_09_Cleaning Up Dates (Attachment)
9. 08_10_Mobile Number Clean Up - Part 1 (Attachment)
10. 08_11_Mobile Number Clean Up - Part 2 (Attachment)
  FREE PREVIEW
11. 08_12_Membership Level Customer Count Distribution (Attachment)
12. 08_13_Stage 2 - Aggregation Across Stores (Attachment)
13. 08_14_Creating the Segments (Attachment)
  FREE PREVIEW
14. 08_15_Stage 3 - Most Popular Drink (Attachment)
1. 09_01_Project Brief - Part 1 (Bonus Tableau Prep Advantages Over Excel)
  FREE PREVIEW
2. 09_02_Project Brief - Part 2
3. 09_03_Stage 1 - Cleaning Component ID and Assembly ID (Attachment) (Data Set)
4. 09_04_Cleaning Component Grade and Last Service Date (Attachment)
5. 09_05_Determining the Latests Service Events (Attachment)
  FREE PREVIEW
6. 09_06_Cleaning Service Intervals Data (Attachment)
7. 09_07_Cleaning Service Dates (Attachment)
8. 09_08_Latest Service Requirements (Attachment)
  FREE PREVIEW
9. 09_09_Overdue for Service Aircraft (Attachment)
10. 09_10_Stage 2 - Critical Components Prioritization (Attachment)
11. 09_11_Approaching Service Limit (Attachment)
12. 09_12_Stage 3 - Component Fail History - Initial Cleaning (Attachment)
  FREE PREVIEW
13. 09_13_Date Cleaning (Attachment)
14. 09_14_4 Analysis Questions (Attachment)
1. 10_01_Project Brief - Graduate to Senior Analyst Edition
  FREE PREVIEW
2. 10_02_Project Brief - Graduate Analyst (Attachment)
3. 10_03_Mid-Level Analyst Edition (Attachment)
4. 10_04_Senior Analyst Edition (Attachment)
  FREE PREVIEW
5. 10_05_Loading Data Sets and Performing the Union (Attachment)
6. 10_06_Cleaning the Unioned Results (Attachment)
7. 10_07_Stage 3 - Analytics Questions - Part 1 (Attachment)
  FREE PREVIEW
8. 10_08_Analytics Questions - Part 2 (Attachment)
1. 11_01_Welcome to the Expert Section
2. 11_02_Tableau Cloud Refresh + Publishing a Dashboard Demo
  FREE PREVIEW
3. 11_03_Publishing a Source and Connecting to It - Corporate Environment Situation
4. 11_04_How Tableau Prep Fits with Desktop and Cloud
5. 11_05_Publishing a Data Source using Tableau Prep (Attachment)
  FREE PREVIEW
6. 11_06_Deploying a Flow to Tableau Cloud - Traceability and Business Continuity
7. 11_07_Scheduling Flows with Data Management Add-On (Links)
8. 11_08_What is a Data Product - Creating a Specific Solution vs a Generalized One
  FREE PREVIEW
9. 11_09_Building Individual Tables (Attachment)
10. 11_10_Deploying the Data Sources to Cloud (Attachment)
11. 11_11_Making Changes to a Model Safely
12. 11_12_Deploying the Flow and Walking Away (Attachment)
  FREE PREVIEW
13. 11_13_Creating Flows in Tableau Cloud
14. 11_14_Congratulations and Data Analyst Essentials is Next
1. 12_01_Congrats and Data Essentials Next

WHAT YOU’LL UNLOCK

148 lessons
18 hours of video content
Clean Data Fast
Build Smart Flows
Automate Everything

TURN CHAOS INTO CLARITY

CLEAN, COMBINE AND SHAPE MESSY DATA FROM MULTIPLE SOURCES INTO ONE RELIABLE FLOW

SEE YOUR DATA TAKE SHAPE

VISUALISE EVERY CLEANING STEP, TRACK YOUR ACTIONS, AND MASTER UNIONS AND JOINS WITH CLARITY

BRING IT ALL TOGETHER

COMBINE DATA FROM MULTIPLE SOURCES INTO ONE CLEAN, CONNECTED FLOW

SET IT AND LET IT RUN

DEPLOY FLOWS TO TABLEAU CLOUD AND AUTOMATE YOUR DATA MODEL CREATION

START YOUR TRANSFORMATION TODAY

INVEST IN THE INDIVIDUAL COLLECTION OR AN EXCLUSIVE PACKAGE DEAL

BUY $99 CLICK HERE FOR AN EXCLUSIVE DEAL

BE SURE TO CHECK OUT THE FULL COLLECTIONS

ALL AVAILABLE THROUGH THE JELLYMAN COLLECTION

★★★★★ Benjamin H L.

★★★★★ Alycia M T.

★★★★☆ Samyuktha S.

★★★★☆ Tanzina Nasrin T.

★★★★★ Lee Boon F.

★★★★★ Tijani Dada S.

★★★★★ Weiling L.

★★★★★ Richard B.

★★★★★ Thalia Renee Quijano C.

★★★★★ Shweta R.

Introduction and ChatGPT Support -> Jellyman Helpline!

Beginner - Introduction

Loading Data

Custom Calculations

Dates, Text Cleansing and Numeric Cleansing

Aggregates

Pivots

Unions

Joins

Intermediate Introduction

Intermediate - Project 1

Intermediate - Project 2

Intermediate - Project 3

Expert

Congratulations and Data Analyst Essentials Next!

WHAT YOU’LL UNLOCK

1-1: FIRST STEPS With Tableau

2-1: Tableau Foundations

2-2: Tableau Practitioner

2-3: Tableau Artisan

3-1: Tableau Cloud

3-2: Tableau Prep

4-1: Data Analyst Essentials

5-1: Tableau Portfolio Creation for Job Seekers

5-2: Job Guide: Breaking Into Data Analytics