Why Choose this Training Course?
Alteryx is a powerful data analytics platform that enables you to prepare, blend, analyze, and report on data from various sources. In this 5-day training course, you will learn how to use Alteryx Designer to build workflows that connect, transform, analyze, and visualize data. You will also learn how to create macros and apps that automate and share your workflows with others. You will also learn some advanced topics and tips for using Alteryx efficiently. By the end of this COPEX training course, you will be able to use Alteryx confidently and creatively for your own data analytics needs.
This training course will feature:
- Data visualization with alteryx
- Data preparation using alteryx
- Alteryx automation
- Alteryx workflow
- Advanced tips of alteryx
What are the Goals?
By the end of this COPEX training course, participants will be able to:
- To learn the basics of Alteryx and how it can enhance data preparation, analysis, and reporting
- To learn how to use various Alteryx tools to connect, transform, analyze, and visualize data
- To learn how to create and share workflows
- To learn how to create macros and apps to automate
Course Outline
Day One: Introduction to Alteryx
- What is Alteryx and why use it?
- Install and activate Alteryx Designer
- Navigate the Alteryx interface and use the canvas, tool palette, configuration window, results window, and workflow view
- Connect to various data sources and use the input data tool
- Browse, filter, sort, and summarize data using the browse, filter, sort, and summarize tools
- Join, union, and append data using the join, union, and append tools
- Exercises and examples
Day Two: Working with Data Preparation and Transformation
- The select tool to modify data types, field names, and field order
- The formula tool to create and edit calculations and expressions
- The text to columns tool to split data into multiple fields
- The transpose and cross tab tools to reshape data
- The sample tool to select a subset of records
- The unique tool to remove duplicate records
- Exercises and examples
Day Three: Working with Data Analysis and Reporting
- The find replace tool to replace values based on a reference table
- The fuzzy match tool to identify similar records
- The spatial tools to perform geospatial analysis and mapping
- The predictive tools to perform statistical analysis and machine learning
- The reporting tools to create charts, tables, maps, and dashboards
- Exercises and examples
Day Four: Working with Macros and Apps
- Macros and how to create them in Alteryx
- The macro input and macro output tools
- The action tool to modify tool configurations within a macro
- The interface tools to create user inputs and outputs for a macro
- Saving a macro as an app and run it in Alteryx Gallery or Server
- Exercises and examples
Day Five: Advanced Topics and Tips
- The dynamic input tool to change data sources at runtime
- The download tool to access web data using APIs
- The run command tool to execute external commands
- The Alteryx scripting tools, including Python and R1
- Optimizing your workflow for performance and best practices
- Troubleshooting common errors and issues in Alteryx
- Exercises and examples
The Certificate
- COPEX Certificate of Attendance will be provided to delegates who attend and complete the course
Material published by Copex shown here is copyrighted.
All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.
-
Duration:5 days
-
Format:Classroom
-
Language: English
-
Certificate:Yes
