ALTERYX DESIGNER: ZERO TO HERO
Learn the fundamentals of Alteryx Designer, apply it right away to your biggest data challenges and start your journey to becoming an analytics hero!
What You'll Learn in this Course
Throughout the course we share examples that you can watch through, pause or rewind at your leisure, or follow along interactively using the same data and techniques!
Whatever your learning style – you’ll find inspiration and knowledge at your fingertips!
First Steps
To help you get the most out of the course, we’ll start off with an introduction to Alteryx (the company), the vision of analytics automation and a walkthrough of the nuts and bolts of Alteryx Designer itself.
We’ll finish this section by building out our first end-to-end workflows - Your success starts here!
Data – In Detail!
Next up, we’ll take you on a tour of the kinds of data that we see most often for new users in Alteryx Designer, including Microsoft Excel and CSV files.
We’ll be taking you through lots of examples of how Alteryx Designer will win your day back, with productivity tips for handling messy data, lots of files and much more!
Cooking with Data – Upskilling with Data Prep & Blend
Everything you need to know about working with data itself, including how to change the data arriving at one end of the workflow into something magical at the other end!
We’ll cover data types, data filters and data blending (where we bring two or more data sources together in powerful ways) and introduce many tools that will become staples of every single workflow you’ll ever build!
Building Powerful Business Logic with Expressions
Never get buried inside spreadsheet calculations ever again once you’ve experienced the elegant simplicity of Alteryx formulas as part of a visual, repeatable workflow.
Going Further with Data Transformation
Learn how to reshape your data without banging your head against clunky and inefficient pivot tables!
Learn how to apply powerful business logic to every row or column in your data, and finish the course with confidence!
Enroll Today!
Everything you need to continue your journey to Alteryx mastery is contained in these short, 'snackable' lessons that are available for you on-demand, at your pace, with all the files and details you need to follow along in the comfort of your personal 'genius zone'!
No pressure, rewatch as often as you'd like, and dip into the sections that drive YOUR curiosity.
You're only a workflow away...
from starting your analytic journey!
Course Curriculum
- Welcome to Zero to Hero! (2:50)
- Course Contents (3:09)
- Pre-Requisites for the Course (1:53)
- Course Structure (3:32)
- Getting to Know Alteryx Designer (6:55)
- At Your Fingertips with Global Search (9:21)
- Getting Started with Workflows (13:52)
- Building Out Our Analysis (8:39)
- Saving Your Work(flow) (12:58)
- Introduction to Alteryx Designer and Data Sources (1:32)
- Reading and Writing Data into Alteryx Designer (11:10)
- Hands on with Microsoft Excel and Alteryx (12:39)
- Alteryx and Spreadsheet Ranges (8:43)
- Alteryx and a Multitude of CSVs (7:52)
- A Solo Exercise with Designer (1:00)
- Solo Exercise - Walkthrough (4:23)
- Exporting Data from Alteryx (5:43)
- Output Data Challenge (1:11)
- Output Data Challenge - Walkthrough (2:57)
- Data Sources and Alteryx - Recap (2:12)
- Cooking with Data: Data Types, Part 1 (10:06)
- Data Types - Part 2 & The Select Tool (8:20)
- Data Preparation & Filters - Part 1 (6:10)
- Data Preparation & Filters - Part 2 (5:35)
- Quiz: Solution Recap (3:00)
- Introduction to Data Blending (8:00)
- Blending Challenge - Walkthrough (3:06)
- Introducing the Alteryx Join Tool (8:15)
- Blending Challenge - Walkthrough (4:21)
- Section Recap: Data Types & Blending (2:25)
- Getting Started with Formulas (9:25)
- Formula Challenge - Walkthrough (3:31)
- Formula Tool: Creating Conditional Expressions (4:44)
- Formula Challenge II - Walkthrough (8:40)
- Even More Preparation Tools (7:40)
- Data Preparation Challenge - Walkthrough (4:26)
- Working with Alteryx Formula Functions (3:57)
- Formula Functions Challenge - Walkthrough (7:51)
- Calculating Summaries, Percentages & Applying Formulas across Rows and Columns (4:51)
- Reshaping Data (5:04)
- The Summarize Tool (1:19)
- Summarize Challenge - Walkthrough (5:41)
- Other Types of Data Blending (6:10)
- Transformation Challenge - Walkthrough (2:51)
- Introduction to Multi Row Calculations (5:42)
- Introduction to Multi-Field Calculations (4:00)
- Wrapping Up the Course (3:30)
- Next Steps & Challenges
- Have Feedback? We'd Love to Hear Your Thoughts (Short Survey)
Hi everyone, this is Nick - welcome to Alteryx Designer: Zero to Hero!
I create upskilling products for people who are ready to take their first steps with data and analytics!
I give them the tools to have more confidence when they solve real-world business challenges and help them grow in their career and win their day back through self-service analytics!
I've got 6 years of experience working directly at Alteryx: including Customer Success, and Product Management and you'd always find me on the keynote stage when new features needed a demo!
When I'm not crafting new courses for datacurious.ai or spending time answering questions in the Alteryx Community, you'll find me cheering on my local ice hockey team (Guildford Flames) or chasing my whippet (Fingal) through the hills of South London!
If you're dying to know more, here are 3 things you don't know about me...
- I have a Ph.D. in Computer-Aided Drug Design and absolutely love to geek out with data science whenever possible!
- I volunteer with DataKindUK to help drive social change through better use of data.
- I have a large (and growing) collection of unusual electronic musical instruments. Honestly, I blame the pandemic...
I can't wait to see you join this course and start making transformational breakthroughs with Alteryx and self-service analytics!