What you'll learn:
- Import and export data to and from different file formats
- Clean and organise data for analysis
- Combine and join datasets together
- Visualize your data to derive insights
- Group, sum, and count datasets together
- Parse data into a structured table
- Create repeatable tasks using a macro
- Create an FTE / employee forecast
- Automate a sales report and dashboard
- Create a cryptocurrency arbitrage identifier
Welcome to Alteryx Essentials!
My name’s Andrew Poon and I’m from Edgecate. I’ve been an IT consultant for 10 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.
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 organise data for analysis,
-JoinTools - 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 practise, everything you've learnt above, by solving 3 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 learnt the essential tools required to build intelligent and automated workflows that you can apply in the workplace, with 3 artifacts to back it up with.
