Alteryx Tutorial for Beginners

Explore how Alteryx simplifies data cleaning, enables predictive analysis through data mining, predictive modeling, and machine learning, supports self-service workflows, and connects with 80+ data sources via drag-and-drop automation.

Install Alteryx using the typical version, start a free trial or license key, and explore the interface by dragging tools onto the workflow canvas, configuring them, and running analyses.

Learn how to import Excel files into Alteryx and connect to data sources using the input data tool, with step-by-step guidance for selecting sheets, named ranges, and previewing data.

Learn how to save an Alteryx workflow and import multiple CSV files using wildcards, handle comma-delimited data, and verify the source with the output file name.

Explore the five data types in Alteryx: string, numeric, date time, boolean, and spatial objects, and learn how auto field and select tools assign and modify them.

Explore the browse tool in Alteryx, learning how to view data profiles, statistics, and data quality from a connected tool using the sample superstore dataset.

Use Alteryx data manipulation and data cleanse to remove leading whitespace and fix inconsistencies. Then use the output data tool to create multiple Excel sheets by category.

Explore how the directory tool lists files with details and subdirectory search, and how the date time now, text input, and map input tools create data and maps in Alteryx.

Explore preparation tools in Alteryx, focusing on the auto field and data cleansing tools, and demonstrate the filter tool with basic and custom filters and true/false outputs.

Discover how to use the formula, sample, and sort tools in Alteryx for beginners to create new columns, conditionally transform data, sample rows, and sort results.

Learn three key Alteryx data preparation tools: the unique tool for identifying duplicates, the imputation tool for replacing nulls, and the multi field binning tool for creating numeric bins.

Learn to use the append fields tool in the join tab to perform a cartesian join, appending a source table to a target with configurable field types and renaming options.

Explore using the Alteryx find and replace tool to locate and substitute values, then join datasets with the union tool by name or position.

Explore the Alteryx join tool to combine two inputs by record position or common fields, and master inner, left outer, right outer, and full outer joins using the union tool.

Master how to configure the radix tool using regular expressions in Alteryx to parse, match, or replace data, and apply the text-to-columns tool to split by a delimiter.

Master the count records tool to tally all records, with or without filters. See how cross tab and transpose pivot data, converting orientations and comparing row and column outputs.

Add and use the reporting tab in Alteryx, configure the table tool to create basic or pivot tables, customize fields, apply formatting rules, and render reports to Excel.

Learn to create visual data representations in Alteryx with the table tool and interactive chart tool, using bar charts and pie charts to display sales by category.

Create batch charts in Alteryx by grouping data by category (and subcategory) to generate three pie charts in one view, then render them to png or pdf.