Reshape the Data That Fuels Your Creations.
Move beyond foundational Tableau skills. Clean, reshape and validate difficult data while mastering calculations that transform your first visualizations into meaningful analytical masterpieces.
From Messy Data to Masterpiece.
Reliable analysis begins with reliable data. Follow a repeatable process for inspecting, cleaning, reshaping and validating information before it reaches the final visualization.
Inspect the Data
Locate gaps, missing information and structural problems.
Clean the Values
Remove inconsistencies and standardize important fields.
Reshape the Structure
Pivot and reorganize data into an analysis-ready format.
Validate the Result
Confirm that Tableau interprets every field correctly.
Data Quality Before Data Beauty.
A beautiful dashboard cannot repair unreliable data. Inspect missing information, compare source metrics, organize projects and manage multiple connections before building visualizations people can trust.
Clean and Transform Raw Text.
Use Tableau’s built-in functions to split, repair, standardize and restructure difficult fields before they interfere with your calculations and visualizations.
Split a Combined Field
Guinto
Turn one combined name into separate first-name and surname fields.
Replace Incorrect Text
Find an incorrect value and replace it with consistent, usable text.
Standardize With Upper
Convert inconsistent capitalization into one standardized text format.
From Flat Tables to Flexible Pivot Structures.
The structure of your data controls what analysis is possible. See how a wide table becomes a longer structure designed for flexible comparisons and scalable Tableau analysis.
Standard Wide Table
Advantage: Easy for people to compare monthly values side by side.
Long Pivoted Table
Advantage: Easier to filter, aggregate, chart and extend.
Make Your Data Think. Control the Answer With Logic.
Use IF logic, Boolean checks and conditional calculations to turn multiple possibilities into one clear answer that responds directly to the choices made by the user.
The flowchart demonstrates how a simple question can branch through different decisions before arriving at one final recommendation.
Master the Date Toolbox.
Dates become far more useful when you can construct them, compare them and move through time. Build calculations that answer practical questions about performance, deadlines and changing business activity.
DatePart
Extract years, quarters, months, weeks and days from a date.
MakeDate
Construct valid dates from separate year, month and day values.
DateDiff
Measure the difference between two dates using your chosen interval.
DateAdd
Move a date forward or backward by a defined amount of time.
Today
Use the current calendar date inside dynamic calculations.
Now
Reference both the current date and the current time.
Fiscal Years
Align Tableau’s calendar with organizational reporting periods.
Week Starts
Control which day Tableau uses to begin each reporting week.
Instant Insights. Zero Wait.
Use Tableau’s fastest analytical calculations to compare performance, measure contribution, expose movement and analyse growth in seconds rather than hours.
Filter Beyond the Basics.
Move beyond simple checkboxes and focus analysis on the records that matter most using rankings, conditions, formulas and flexible text matching.
Tell Better Stories With Maps.
Go beyond plotting locations. Use layers, regions, shapes, density, dual axes and annotations to create geographical analysis with greater context and clarity.
Practitioner Complete. Expert Time, Baby.
Leave Practitioner able to clean difficult data, build stronger calculations and answer more sophisticated questions. Next comes advanced modelling, LODs, parameters and customized visualizations.
