Learning Outcomes

With the skills learned in the Beginner section you'll already be heads and shoulder above the rest. That's a fact I've seen and experienced in the industry.

It's now time to take it to the next level in this Intermediate course where we'll be tackling data cleansing problems, understanding the impact of data structures on analysis, development of logic functions and calculations and one of my favourites, Quick Table Calculations.

  • Data Cleansing

    Data Cleansing is the separator between basic analysts and the very best. Visualization is easy when data is clean but it's very rarely in a usable state in the industry. Time to learn the secrets!

  • Logic Functions and Calculations

    To extract and process data to find insight, you'll need to probe into it using calculations and logic functions.

  • Quick Table Calculations

    This is by far one of the best features and by itself makes Tableau significantly better than other Business Intelligence Tools. This includes Running Totals, Moving Average, Rank, Percentile and more.

Tableau Desktop/Public - Intermediate

    1. Introduction and Contents

      FREE PREVIEW

    2. Learning Resources 1

    3. Data Inspection

    4. Tableau Public Latest Version, Loading your Data, Quality Checks

      FREE PREVIEW

    5. Folder Structure and Governance

    6. Replacing Data Connections, Replacing Field Referencing

    7. Tableau Desktop - Refreshing, Regenerating Extracts

    8. Packaged Workbooks and Exporting as Version

      FREE PREVIEW

    9. What is Data Cleansing

    1. Splitting and Custom Splitting - A Deeper Look

      FREE PREVIEW

    2. Replace Function Cleaning, Changing Resulting Data Type, Double Quote Results

    3. Left Right and Mid

    4. Length, Dynamic Left and Right with Len

    5. Contains, Endswith, Startswith

    6. Find, FindNth, Str

      FREE PREVIEW

    7. Trim, LTrim, RTrim

    8. Upper, Lower and Pseudo Proper

      FREE PREVIEW

    9. Assignment 1 - Questions

    10. Assignment 1 - Answers

    1. Agile vs Waterfall

    2. Stakeholders

      FREE PREVIEW

    3. Managing the Scope

    4. Impact and Inspiring Change

    5. Affected

    6. Baseline

    7. Career

      FREE PREVIEW

    8. I'd love to hear what you think

    1. Pivot vs Table - Performing Pivot

    2. Advantages of the Table Structure

      FREE PREVIEW

    3. Pivot Advantages

    1. Integers and Rounding

      FREE PREVIEW

    2. Ceiling, Floor, Absolute, Sign, Div

    3. ZN Function

    4. Mathematical Expressions

    5. Learning Resources

      FREE PREVIEW

    6. Assignment 2 - Questions

    7. Assignment 2 - Answers

    1. Basic Concept of Boolean and If Functions

      FREE PREVIEW

    2. Boolean Functions in Tableau

    3. Building If Function - Different Criteria Methods

    4. If Condition with Dates, Using IIF

    5. AND + OR Functions in Excel Explained

    6. AND and OR Functions in Tableau

      FREE PREVIEW

    7. Combining AND-OR with IF

    8. Nested IF Functions

    9. Else If Function

    10. Case Function

    11. Quick If, Elseif, Case Function Creation using Excel and Notepad++

      FREE PREVIEW

    12. Mapping Out all Combinations using Excel - Quick IF Function Creation

    13. Special If Functions - Ifnull, Isnull, Not, ="", <>"",

    14. Tableau Conference, MakeOverMonday, Interworks, Tableau Public

    15. Further Feedback 1

Course Details

  • 93 lessons
  • 10 hours of video content
  • Data Cleansing
  • Formula Design
  • Dashboard Publication

Student Reviews

★★★★★ Awesome Work

Bilal Abu
I loved it

★★★★★ Excellent Starting Point For New Users

Michelle Bannon
This was a very good beginner training for getting started. While I am not a beginner, I wanted to go through this and see if there was additional tips/tricks I could learn and I did. Great job on this Jellyman!

★★★★★ This Was Absolutely Great!

Andrea Munoz
This is a great introduction to tableau. I enjoyed your course very much and can't thank you enough for having this up for free. I have an interview on Friday that requires Tableau exposure, so I feel 100 times more prepared now! Thank you!

★★★★★ Great Simple Introduction To Tableau

Margot Drewe
Finally a simple explanation to the why of Tableau. I have watched many tutorials on how to use Tableau but Jellyman was the first one that was able to explain to me why Tableau and not Excel. The explanations Jellyman uses to explain the how of Tableau was so easy to comprehend I'm confident to take Tableau to the next stage. Thanks Jellyman!

★★★★★ Great Starter Course For Tableau

Deepak Holla
Hi All, I really loved the way Jed has covered the topics of Tableau in this course. I knew a bit of Tableau when I started this course but I must say that I did learn few new things in this course. The USP of this starter course was the knowledge that he shared with respect to the general stuff of where each of the topics might be used e.g: Where we could actually make use of a Running total in the real world. I cannot wait to start the Advanced course. I recommend anyone who is new to Tableau to take up this ""Getting Started with Tableau"" course!!!! Regards, Deepak.

★★★★☆ Good

Taps Rale
Good

★★★★★ Excellent

Param Van


★★★★★ Outstanding Introduction

Mark Freeman
This course was so much fun that I couldn't wait to get up this morning and work on it over coffee. The instructor is engaging and personable while gently explaining exactly how to get started. I tend to be more of a book learning person, but that isn't so easy with such a complex application. This is the perfect combination of walkthrough and hands on exercises.

★★★★★ Super Stuff

Gokulakrishnan Selvam
Quick and compact review, easy understanding format. Covers all product uses and costs. Thank you so much ❤

Show me the full list of reviews

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