Mama Would be Proud!
This Intermediate Tableau Course takes you beyond the basics with data cleansing, advanced filtering, date analysis, and mapping. Gain the skills to solve complex problems and stand out as an advanced user.
Clean and structure data – fix text, numerical, and date issues for reliable analysis
Apply advanced logic – use IF functions, filters, and calculations to solve complex problems
Build powerful visuals – create maps, trends, and dashboards that deliver real business insights
Fix Text, Numerical, and Date Issues for Reliable Analysis
Learning to clean and structure data is essential for accurate, reliable analysis.
You’ll discover how to transform messy information into a format that’s ready for powerful Tableau visualizations.
Use IF Functions, Filters, and Calculations to Solve Complex Problems
Learning to apply advanced logic gives you the power to automate rules
and solve complex problems.
You’ll discover how to use formulas, filters, and calculations
to bring deeper intelligence into your analysis.
Instantly reveal trends, growth, and contributions with powerful one-click calculations
Learning to use Quick Table Calculations helps you uncover insights fast without writing complex formulas.
You’ll discover how to calculate growth, trends, and percentages with just a few clicks.
Introduction and Contents
Learning Resources 1
Data Inspection
Tableau Public Latest Version, Loading your Data, Quality Checks
Folder Structure and Governance
Replacing Data Connections, Replacing Field Referencing
Tableau Desktop - Refreshing, Regenerating Extracts
Packaged Workbooks and Exporting as Version
What is Data Cleansing
Splitting and Custom Splitting - A Deeper Look
Replace Function Cleaning, Changing Resulting Data Type, Double Quote Results
Left Right and Mid
Length, Dynamic Left and Right with Len
Contains, Endswith, Startswith
Find, FindNth, Str
Trim, LTrim, RTrim
Upper, Lower and Pseudo Proper
Assignment 1 - Questions
Assignment 1 - Answers
Agile vs Waterfall
Stakeholders
Managing the Scope
Impact and Inspiring Change
Affected
Baseline
Career
I'd love to hear what you think
Pivot vs Table - Performing Pivot
Advantages of the Table Structure
Pivot Advantages
Integers and Rounding
Ceiling, Floor, Absolute, Sign, Div
ZN Function
Mathematical Expressions
Learning Resources
Assignment 2 - Questions
Assignment 2 - Answers
Basic Concept of Boolean and If Functions
Boolean Functions in Tableau
Building If Function - Different Criteria Methods
If Condition with Dates, Using IIF
AND + OR Functions in Excel Explained
AND and OR Functions in Tableau
Combining AND-OR with IF
Nested IF Functions
Else If Function
Case Function
Quick If, Elseif, Case Function Creation using Excel and Notepad++
Mapping Out all Combinations using Excel - Quick IF Function Creation
Special If Functions - Ifnull, Isnull, Not, ="", <>"",
Tableau Conference, MakeOverMonday, Interworks, Tableau Public
Further Feedback 1
“
AMAZING TEACHER
I love your course and could listen for hours. You distill valuable advice clearly. Found you on YouTube while struggling with LOD expressions; examples helped immensely. Grateful for accessible pricing and free content—your teaching is engaging and generous.
Emeline Courcelle
“
GAME-CHANGING COURSE FOR FIRST-TIME TABLEAU USERS
This course is a must for first-time Tableau users intimidated by data. Jed simplifies Tableau with step-by-step guidance: setup, import data, navigate the UI, and create visualizations. Clear, encouraging teaching—confidence transformed and ready to build. Thanks for making Tableau accessible.
Adam Lockwood
“EXCELLENT COURSE
Jellyman is an excellent teacher! His content is interesting, applicable and well-explained.
He has clearly thought about the way people absorb information and doesn't gloss over any assumed knowledge like many other courses do. He has taken the time to go through methods & concepts step by step so it's almost impossible not to learn!
”
Elizabeth Deterding
“AMAZING COURSE
The course is great! Feels like studying with a friend :) Everything is explained very easily and I am looking forward to the next one!
”
Anastasiia Larina
“BEST TABLEAU TRAINING EVER
Totally clear and very well explained with a bunch of examples. All sensible topics – LOD, Actions and Calculated Fields are tackled.
Big Thank You!
”
Nicolaie Cozma
“I LOVE LEARNING TABLEAU WITH JED
The best teacher of Tableau I have ever found! I would love to meet Jed someday in real life. I like his sense of humor and the way he explains everything.
Jed much thanx for this course.
”
Emilia B Korycka
“JOINS WERE HOLDING ME BACK
Great – this was holding me back but not any more
”
Brian Sundermeijer
“STILL LEARNING THINGS
I was wondering why we were just now covering joins when it's something I felt essential enough to be a beginner subject. Then you delved into joins versus relationships versus blends and it became much clearer – this was more complex than an entry level subject.
Great explanations all around and I have a better understanding of when to use which tool.
Update: Just finished LODs. Mind continues to be blown! Can't recommend this course enough.
”
Bryan Nylander
“ONE OF THE BEST EDUCATORS ON PLANET TABLEAU
Jellyman is a fantastic teacher! His lessons are unlike others to say the least!!!
Hats off to his engineering personality and his koool sense of humour (A bit of contradiction there but definitely works like magic on our memory capacity to retain his fun lessons :)
”
“AMAZING!
Take this course even if you think you're an expert in Tableau
”
Kamirah Martin
No you don't! I designed it with Tableau Public Free Edition in mind. For places where I demonstrate capabilities in the Paid Version, I simply showcase it. But you don't need to repeat to proceed.
Yes, it’s recommended. The intermediate course builds on the core foundations like basic charts, filters, and data connections, which are covered at the beginner level.
Calculated fields let you create custom metrics by writing formulas. This gives you more flexibility and control over your analysis compared to standard fields.
Parameters are dynamic inputs—single values the user can change—to drive user-controlled calculations, filters, bins, and even reference lines. They power what-if analysis and flexible Top-N or scenario dashboards without editing the underlying data.
The beginner course focuses on foundations like building simple charts and cleaning data. The intermediate course takes the next step with calculated fields, parameters, and multi-data source analysis.
This is where your journey begins here at Jellyman Education. You'll get a quick feel for what Tableau is and why it's such an amazing tool.
Now that you've made it through the "Getting Started with Tableau" course, it's time to get stuck into the real training! Here you'll learn a strong foundation of tools used throughout Tableau that prepares you perfectly for the future.
Now it's getting really good! Intermediate covers everything from Data Cleansing, Project Management, Data Structure, Quick Table Calc's, Advanced Filtering and Advanced Maps. You'll be the star of the show with these skills!
You're now delving into some of the highest and most complex operations you'll find in Tableau. LOD's, Joins, Unions, Big Data, Blending, Parameters, Sets, Advanced Dashboards and Custom Visualizations. WOW INDEED!!!!
Now it's getting really fun. Think of Tableau Cloud as the digital cafe where you and your friends meet up to share stories, information, dashboards, data, results and more. It's the future of Data Sharing in the Industry today.
With Visualizations through Tableau Desktop and data sharing through Tableau Online, it's time to tackle Advanced Data Cleansing using Tableau Prep. This is one of the most enjoyable tools you'll find especially if you clean data all day long!
Master the essentials of data analysis with SQL, ChatGPT, AI-powered SQL, and project management. Gain practical skills to solve real problems and boost your career as a data analyst.
Perfect for job seekers and freelancers—these Tableau projects help you build a standout portfolio on Tableau Public. Showcase your data skills, design thinking, and storytelling in real-world scenarios that make sharing and impressing easy.
Learn how to land your dream data analyst job with a proven system: avoid common mistakes, craft powerful applications, ace interviews and testing, and turn rejection into growth. Build confidence, skills, and a portfolio that gets you hired.
