Alteryx MasterClass - Lets get started

Explore how Alteryx enables drag-and-drop data cleaning without coding, reducing the 80 percent data preparation workload and delivering faster, cleaner analytics for a competitive edge.

Explore the Alteryx interface by identifying the workflow canvas, tool ribbons, and configuration panes; drag, connect, run workflows, view results, and customize tiles with favorites, search, and annotations.

Explore how to get data into Alteryx using text input and input data tools, including manual entry, copy-paste, and drag-and-drop file connections.

Connect to a Microsoft SQL Server database in Alteryx with Quick Connect, test the connection, select the bike stores database, and run a query via the visual query builder.

Explore the browse tool to inspect cleaned data and view the full dataset, then save the prepared data with the output data tool to a file.

Explore the select tool in Alteryx masterclass to configure fields, change data types, rename and reorder columns, filter visible fields, and apply bulk operations like prefixes and sorts.

Use the auto field tool to automatically infer data types for all columns when importing data from csv or text files, assigning integers, dates, strings, and handling decimal separators.

Learn to use Alteryx's data cleansing tool to quickly clean messy inputs by removing nulls, empty rows and columns, punctuation, numbers, and extra whitespace, with live previews and run checks.

Explore the filter tool in Alteryx, mastering basic and custom filters, using operators like contains and greater than, and understanding true/false outputs and under-the-hood formulas.

Learn to use the formula tool in Alteryx to create and apply data transformations, including replacing values, handling strings, and converting to doubles.

Learn to use the generate rows tool to duplicate data rows with a loop, creating a date field from start to end dates.

Explore imputation to handle missing values in data preparation, choosing between average, median, mode or a user-specified value, and optionally add imputed indicators or new columns.

Explore how the multi-field binning tool bins numeric fields into tiles using equal records or equal intervals. Sort by tile and sales rep to see the distribution within each bin.

Explore applying the multi field formula tool in Alteryx to run a single expression across multiple text and numeric columns, including dynamic fields, with practical examples.

Use the multi row formula tool to fill missing country values by checking if the current row is empty and carrying forward the previous non-empty value, updating the country field.

Explore four data preparation tools in Alteryx—record, random sample, sample, and unique—and learn workflows to add an index-style column, deterministically sample data, select rows, group by fields, and extract unique values.

Explore data preparation in Alteryx by classifying data into tiles using equal sum, equal records, unique values, small tile, smart tile, and manual cutoffs, with tile numbers and sequences.

Explore how the union tool in Alteryx combines multiple data tables by name or position, with manual field configuration as needed, using a games dataset example.

Learn to use the find and replace tool in Alteryx as a dictionary-style mapper to abbreviate values in a data column, using manual or table inputs, with case sensitivity options.

Explore the append tool in Alteryx and learn when the Cartesian product can explode datasets; connect target and source, and use a single-entry second dataset to safely append columns.

Explore the make group tool in Alteryx (under join) and learn how it builds connected friend groups by chaining relations between a, b, and c, producing a grouped output.

Learn how to use the fuzzy match tool in Alteryx to identify spelling variations, compare records from the same source, configure matching fields, and read match scores.

Master joining in Alteryx by exploring left, right, and inner joins, and using join multiple to combine multiple data sources with specific fields or record position.

Master Alteryx parsing techniques by converting strings to date time with custom formats and using text to columns to split data by delimiters, including options for rows and columns.

Master the Alteryx regex tool to extract domain names from sample URLs, and apply replace, tokenized, and match outputs to clean data.

Learn to transform data in Alteryx by arranging and counting records, including transposing data into services and prices columns and using the count records tool.

Learn how to use Alteryx's transpose and crosstab tools to reshape data: convert monthly columns into date and sales pairs, then pivot back for dashboard-ready tables.

Learn to compute a running total (cumulative sum) in Alteryx, converting strings to numbers and using group by fields like country to get per-group totals.

Master the summarize tool to perform aggregation in alteryx, grouping by country and product, calculating total quantities, counts of distinct products, and minimum order dates.

Compute weighted averages across a dataset in Alteryx, using weight fields and grouping to obtain series-specific ratings, and experiment with equal versus differential weights.

Learn to use dynamic select and dynamic rename in Alteryx, accessed via the developer tab, to filter fields by data type or formula and set headers from a right input.

Learn to combine multiple Excel tabs into Alteryx by dynamically importing sheet names, applying a shared template, and merging data into one clean dataset for analysis.

Learn to web scrape exchange rates with an API in Alteryx, parsing JSON from the ECB's rates API, extracting currency names and euro values, and cleaning data for analysis.

Explore web scraping in Alteryx by extracting a website table with Python. Compare download tool and Python pandas approaches, install packages, and write the table to output.

Apply data cleaning and data operations on your own data, follow the end-to-end case study from messy data to a cleaned dataset, and visualize in Power BI or Tableau.