Jellyman Education

Intermediate Introduction

ChatGPT Support

05_01_What is Data Cleansing

05_02_Data Inspection - Gaps, Missing Data, Pivot Structures (Attachment)

05_03_Data Exploration with Tableau - Metric Comparison to Ensure Tableau Reads Correctly

05_04_File Storage and Project Tracking (MANDATORY)

05_05_Ooooopssss.....I forgot to explain the actual data set story - Customers Requesting Compensation

05_06_Managing Multiple Connections - Replace Data Source, Replace References (Attach)

QUIZ: The Importance of Cleaning Data in Tableau

QUIZ: Is Tableau Desktop a Data Cleansing Tool?

06_01_Data Splitting, Automatic, Custom, Underlying Formula Explaining, Split off a Split

06_02_Don't forget to save to Tableau Public

06_03_Replace Function

06_04_Left and Right Functions

06_05_Length Function + Bonus discussion on Discretes and Dimensions

06_06_Mid Function

06_07_Mid Function + Length Function

06_08_Find Function

06_09_Find + Left

06_10_Findnth, Contains, Swtartswith, Endswith

06_11_Trim + Lower + Upper

06_11a_Proper Function

06_12_LTrim and RTrim

Assignment - Numerical and Text-Based Cleansing (Problem) (Attachment)

Assignment - Numerical and Text-Based Cleansing (Solution) (Attachment)

07_01_Pivot vs Table Structure Theory - Physical Explanation of the Conversion

07_02_Extension Problem of Pivots - Be Careful with Aggregates

07_03_Setting up 2 Connections - Pivotted and Unpivotted

07_04_Pivot vs Table - What You Can and Can't Do

QUIZ: Difference Between a Standard Table and a Pivot Table in Tableau

08_01_Integers and Rounding

08_02_Ceiling,Floor, Absolute and Sign

08_03_Exponent, Power, Sin, Cos, Tan, Degrees, Radians, Logs, square root, square, pi

09_01_The Basics of Logic and IF Functions

09_02_Boolean Examples - =, , for String, Measures and dates

09_03_IF vs IIF Syntax and Writing your first Functions

09_04_Applying to Row or Aggregate Level

09_05_AND and OR Function Examples

09_06_Nested IF Functions

09_07_Else If Function

09_08_Case Function

09_09_Special Logic Functions zn, ifnull, not, , isnull

Assignment - IF Function (Problem) (Attachment)

Assignment - IF Function (Solution) (Attachment)

QUIZ: The Purpose of IF Functions in Tableau