Course Details

With the skills learned in the Beginner course, you’re already ahead of most. Now it’s time to go deeper. This Intermediate Tableau Desktop course will strengthen your ability to handle messy data, design smarter logic, and unlock powerful built-in tools.

We start with Data Cleansing — the hidden skill that separates good analysts from great ones. Clean data is rare in the real world, and knowing how to fix it is crucial. You’ll learn how to identify and solve structural issues, reformat fields, and get your data analysis-ready.

Next, we focus on Logic Functions and Calculations. These allow you to ask better questions of your data, derive new insights, and solve problems using IF statements, CASE logic, and more.

Finally, you’ll unlock the full power of Quick Table Calculations — a Tableau-exclusive feature that lets you perform advanced analytics like Running Totals, Moving Averages, Percentile Ranks, and more — with just a few clicks.

  • Pre-requisite Knowledge / Skills

    This course is designed for learners who have completed a Beginner-level Tableau course or have equivalent experience building basic dashboards, using filters, sorting, and simple calculated fields. You should already feel comfortable navigating Tableau and be ready to level up your analytical skills.

  • Software Requirements

    You’ll need a licensed or trial version of Tableau Desktop installed. This course uses advanced functions and features available only in the full desktop version. A stable internet connection is helpful for downloading resources and following along with data sets.

  • Course Outcomes

    By the end of this course, you’ll be able to perform data cleansing for real-world datasets, use logic functions to develop complex calculations, and apply Quick Table Calculations such as Running Totals, Rank, and Percent of Total — all critical tools for professional-level analysis.

Course Curriculum

    1. Introduction and Contents

    2. Learning Resources 1

    3. Data Inspection

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

    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

    9. What is Data Cleansing

    1. Splitting and Custom Splitting - A Deeper Look

    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

    7. Trim, LTrim, RTrim

    8. Upper, Lower and Pseudo Proper

    9. Assignment 1 - Questions

    10. Assignment 1 - Answers

    1. Agile vs Waterfall

    2. Stakeholders

    3. Managing the Scope

    4. Impact and Inspiring Change

    5. Affected

    6. Baseline

    7. Career

    8. I'd love to hear what you think

    1. Pivot vs Table - Performing Pivot

    2. Advantages of the Table Structure

    3. Pivot Advantages

    1. Integers and Rounding

    2. Ceiling, Floor, Absolute, Sign, Div

    3. ZN Function

    4. Mathematical Expressions

    5. Learning Resources

    6. Assignment 2 - Questions

    7. Assignment 2 - Answers

    1. Basic Concept of Boolean and If Functions

    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

    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++

    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

There are Several Tableau Courses Available

This covers Tableau from Start to Finish. From Designing Dashboards, to Cleaning Data and then to Publish Workbooks to the Cloud

View more products