My name’s Andrew Poon, and I’m from Edgecate. I’ve been an IT consultant for ten years working in data and analytics projects in Australia.

I’ve created this course to turn Alteryx new starters into highly proficient users as quickly as possible.

What will you learn in this course?

You'll learn the following essential tools:

• In/Out Tools - Import and export data to and from different file formats
• Data Preparation Tools - Clean and organize data for analysis
• Join Tools - Combine and join datasets together
• Reporting Tools - Visualize your data to derive insights
• Summarize Tools - Group, sum, and count datasets together
• Parse Tools - Parse data into a structured table, and
• Batch Macro Tool - Create repeatable tasks using a macro

We'll then put into practice, everything you've learned above, by solving three unique business problems, ranging from novice, intermediate, and advanced:

• Support an FTE/employee forecast by splitting and consolidating reports by business unit
• Automate a sales report and dashboard by cleaning, and performing calculations on a sales report
• Create a cryptocurrency arbitrage identifier that takes advantage of price differences between crypto exchanges

At the end of this course, you’ll have learned the essential tools required to build intelligent and automated workflows that you can apply in the workplace, with three artifacts to back it up with.