Course Detail

In this course on Alteryx, you will develop expertise in various aspects such as Alteryx Designer, data joining from different sources, restructuring data processing, data handling, Alteryx macros, and much more. Analyzing, blending, and preparing data using a repeatable process with Alteryx Analytics is straightforward for analysts.

The Alteryx training course aims to equip you with the skills needed to handle all tasks within the Alteryx tool effectively. You will also learn about different Alteryx concepts, such as creating workflows on demand using new data and conducting predictive, statistical, and spatial analytics without the need for coding. By the end of the course, you will be proficient in creating visually appealing dashboards, reports, manipulating data, creating workflows and analytic applications, and sharing them with others. Practical exercises on all Alteryx concepts and their real-world applications are included in this course.

Highlights:

• Working with various types of data inputs
• Renaming fields, changing data types, and sorting
• Data blending in Alteryx
• Creating filters, formulas, and samples
• Understanding different types of joins, unions, and appending data
• Working with tools like Fuzzy Match, Make Group, and Find & Replace
• Converting string to date/time formats and vice versa
• Using regular expressions and text to columns
• Pivoting data orientation with tools like Crosstab, Transpose, and Arrange
• Creating running totals, record counts, and different aggregations
• Generating reports using multiple tools in the Reporting tool palette

IN/OUT Tab:

• Importing data from Excel and CSV files
• Appending all CSV files
• Using tools like Browse, Output, Directory, and Text Input
• Handling date and time data

Preparation Tab:

• Auto Field Tool
• Data Cleansing Tool Part 1
• Data Cleansing Tool – Part 2
• Filter Tool (Text Example)
• Filter Tool (Number Example)
• Filter Tool (Date Example)
• FORMULA TOOL (Basic Example)
• FORMULA TOOL – (Multiple Examples)
• GENERATE ROWS TOOL
• IMPUTATION TOOL
• MULTI-FIELD BINNING TOOL
• MULTI-FIELD FORMULA
• MULTI ROW FORMULA
• RANDOM % SAMPLE TOOL
• SAMPLE TOOL
• RECORD ID TOOL
• SELECT TOOL
• SORT
• CREATE SAMPLE TOOL
• TILE TOOL
• UNIQUE TOOL

Join Tab:

• APPEND FIELDS TOOL
• FIND AND REPLACE TOOL
• FUZZY MATCH TOOL
• JOIN TOOL
• JOIN MULTIPLE TOOL
• UNION TOOL
• REGEX TOOL
• Text to Columns

Transform Tab:

• CROSS TAB Tool
• TRANSPOSE Tool
• RUNNING TOTAL Tool
• SUMMARIZE TOOL

Projects:

• Multiple application projects for in-depth industry knowledge of Alteryx applications.