Back to catalogue
AnalyticsBeginnerFree
Alteryx Designer
Learn one of the best low code and no code data tools on the market
4.4 hrs·39 lessons·Beginner
What you will cover
- Find your way around Alteryx Designer and build workflows on a blank canvas with no code
- Bring in data from Excel, CSV files, databases and SQL, including many sheets or files at once
- Clean and prepare messy data quickly with the cleansing, select and auto field tools
- Filter, sort, sample and deduplicate data to get to the records you actually need
- Write formulas and expressions to create and transform fields
- Combine data from different sources with joins, unions, find and replace, and append
- Summarise and reshape data with summarise, cross tab, transpose and running totals
- Work with dates and text: parse dates, format them and split text into columns
About this course
Alteryx Designer is one of the most in demand low code data tools, and this course takes you from a blank canvas to building real, repeatable workflows. You will learn the interface, how to bring in data from Excel and other sources, and how to clean, join and shape it without writing any code. Every lesson is short and practical, so you build a skill you can use at work straight away.
Who this is for
- Analysts who want to automate data preparation without writing code.
- Finance, operations and data professionals who work with Excel and want a faster way.
- Beginners who want a step by step path into Alteryx Designer.
Requirements
- • No prior Alteryx experience is needed. You start from the interface and the basics.
- • Working with spreadsheets before will help you get up to speed quickly.
Curriculum
39 lessons · 4.4 hrs✓Why Learn Alteryx? | Automate, Analyse & Accelerate Your Data Skills02:40✓Alteryx Course Overview | Learn Alteryx Designer Step by Step02:46✓Alteryx Day 1 - Learn Alteryx Designer: Interface & Navigation Tutorial08:11✓Alteryx Day 2 - Load Excel & CSV Files into Alteryx | Input Data Tool Tutorial11:47✓Alteryx Day 3 - Import Multiple Excel Tabs in Alteryx | Multi-Sheet Data Tutorial04:52✓Alteryx Day 4 - Import Multiple Excel Sheets in Alteryx | Wildcard Import Tutorial05:03✓Alteryx Day 5 - Import Multiple Excel Files & Sheets in Alteryx | Dynamic Input Tool Tutorial12:04✓Alteryx Day 6 - Connect Databases to Alteryx | Input Data Tool & SQL Tutorial08:52✓Alteryx Day 7 - Text Input Tool Tutorial | Create Custom Tables & Prototypes04:35✓Alteryx Day 8 - Data Cleansing Tool Tutorial | Clean & Prepare Your Data Fast15:23✓Alteryx Day 9 - Select Tool Tutorial | Rename, Reorder & Change Field Types05:42✓Alteryx Day 10 - Auto Field Tool Tutorial | Automatically Optimise Field Types03:47✓Alteryx Day 11 - Filter Tool Tutorial | Split & Analyse Data with Conditions12:51✓Alteryx Day 12 - Formula Tool Tutorial | Create & Transform Data with Custom Expressions13:19✓Alteryx Day 13 - Sample Tool Tutorial | Select Rows & Create Data Subsets07:05✓Alteryx Day 14 - Sort Tool Tutorial | Organise Data by Fields & Values06:27✓Alteryx Day 15 - Unique Tool Tutorial | Find Distinct Records & Remove Duplicates06:32✓Alteryx Day 16 - Alteryx Joins Tutorial | Combine Data from Multiple Sources05:35✓Alteryx Day 17 - Alteryx Join Tool Tutorial | Merge Data with Keys & Joins09:15✓Alteryx Day 18 - Union Tool Tutorial | Combine Multiple Data Streams into One08:37✓Alteryx Day 19 - Find & Replace Tool Tutorial | Match & Replace Data Across Fields08:22✓Alteryx Day 20 - Append Fields Tool Tutorial | Attach Data from One Stream to Another04:46✓Alteryx Day 21 - Count Records Tool Tutorial | Quickly Count Rows in Your Data02:11✓Alteryx Day 22 - Transpose Tool Tutorial | Reshape Data from Wide to Tall07:41✓Alteryx Day 23 - Running Total Tool Tutorial | Create Cumulative Sums & Running Counts04:03✓Alteryx Day 24 - Summarise Tool Tutorial | Aggregate, Group & Analyse Data08:15✓Alteryx Day 25 - Cross Tab Tool Tutorial | Pivot Data from Rows to Columns09:35✓Alteryx Day 26 - Arrange Tool Tutorial | Reshape Data into Custom Table Layouts05:57✓Alteryx Day 27 - DateTime Tool Tutorial | Parse, Format & Transform Date Fields06:11✓Alteryx Day 28 - Text to Columns Tool Tutorial | Split Data into Multiple Fields04:57✓Alteryx Day 29 - Export Data to Excel in Alteryx | Output Data Tool Tutorial08:46✓Alteryx Day 30 - Export Data to Databases in Alteryx | Output Data Tool Tutorial08:00✓Alteryx Day 31 - Comment Tool Tutorial | Document & Organise Your Workflows04:09✓Alteryx Day 32 - Cache Data in Alteryx | Speed Up Workflows with Cached Datasets03:33✓Alteryx Day 33 - Tool Container Tutorial | Organise & Control Your Workflows04:35✓Alteryx Day 34 - Explorer Box Tutorial | Embed Files, Links & Notes in Workflows01:39✓Alteryx Day 35 - Alteryx Controls & Validations Tutorial | Build Reliable, Error-Free Workflows10:02✓Alteryx Core Certification Exam Prep | Study Guide & Tips04:35✓Next Steps in Your Alteryx Journey01:16
Your instructor
Dean Taylor
Finance & treasury educator
Built and run treasury and liquidity functions inside tier 1 international banks.
Teaches the practical mechanics, not just the theory.
Every lesson maps to something you can do on the desk.
What learners say
Sign in and enrol to leave a review.
No reviews yet. Be the first to share your take.
Frequently asked questions
Is this course free?+
Yes. The Alteryx Designer course is free. Set up a free account and begin with the first lesson.
Do I need to know how to code?+
No. Alteryx is a low code, visual tool, and the course is built for beginners who want to automate data work without programming.
What will I learn to do?+
You will learn to load data from Excel and other sources, clean and shape it, and build repeatable workflows, step by step across 39 lessons.
How long does it take?+
There are 39 lessons and about 4 hours of video, so you can build a solid foundation in a week or so.
Will I get a certificate?+
Pro members receive a certificate on completion. The course is free to take for everyone.
Can I learn at my own pace?+
Yes. The lessons are on demand, so you learn whenever it suits you.