The Complete Alteryx Bootcamp - Data Analytics Made Simple

Learn to connect to Excel and CSV data sources with Alteryx input data tool, configure sheets and headers, inspect data with browse, and output results to Excel, databases, or Tableau.

Leverage a single input tool with the dynamic input tool to import multiple Excel tabs using a template, aligning columns by header names or order for a single dataset.

Use a single input tool with a wildcard to import data from multiple Excel files with the same structure, including subdirectories, and observe results with a browse tool.

Explore methods to import data from multiple files using directory, dynamic input, and text input tools; learn to filter file paths, include subdirectories, and consolidate records across files.

Connect to databases in alteryx using the input data tool and odbc, then write and test sql queries joining customer and payments to bring data into workflows.

Use the text input tool to import data from files or paste from the clipboard, manage headers, rename columns, and append or edit rows for quick workflow data.

Learn to clean and prepare data in Alteryx using data cleansing tools to fix whitespace, null values, and mixed data types for reliable analytics.

Clean data with Alteryx's data cleansing tools to fix spaces, nulls, and unwanted characters. Use the select tool to rename, retype, and reorder fields, and manage unknowns for downstream workflows.

Use the autofill tool to automatically adjust string field types and sizes to the smallest needed for the dataset and its metadata. This reduces data footprint and boosts workflow performance.

Use the filter tool to split data into true and false streams by evaluating rows against Boolean conditions. Build basic and custom filters, including multi-condition expressions and string functions.

Learn to use the formula tool to fix data quality issues and create derived fields with conditional logic for enriching datasets in Alteryx.

Explore the sample tool in Alteryx by applying its six sampling types, including first and last rows, group by, skip first, one in every N, and first N percent.

Learn to sort data in Alteryx, handling numbers and strings with ascending or descending orders, including multi-column sorting. Explore column priorities, removal, and dictionary order effects.

Explore how the unique tool outputs one row per distinct value based on selected fields, routes duplicates to a duplicates stream, and how sorting and multi-column keys shape the results.

Explore how Alteryx joins data from multiple sources using tools—join, union, find and replace, and append fields. Understand inner, left, right, and full outer joins and how keys link tables.

Learn to join two datasets in Alteryx with the join tool, matching on user ID to perform an inner join and handle left and right joins and unmatched records.

Learn the Alteryx union tool to stack tables by name, by position, or manually, handle field differences, and pair with joins for left, right, and full outer results.

Explore how the find and replace tool uses a main data set and short-to-long mapping tables to replace abbreviations with full terms, with any-part-of-field matching and case-insensitive whole-word matching.

Learn how the append fields tool duplicates target records for every source record, creating a cartesian join, with options to switch inputs and customize data types and headers.

Transform data by counting records to support validation checks, using the count records tool with an input dataset, and compare to the summarized tool for zero record handling.

Compute a running total as a per-row cumulative sum on a numeric field, with optional grouping by attributes. Understand the impact of input order and time-based use cases.

transpose converts wide sales columns into a long format with month and sales values, keeping key columns fixed, enabling tidy data for time series analysis.

Learn how the summarised tool creates data summaries through group by, sum, and count distinct, illustrated with quiz game data to reveal team and individual winners.

Explore the cross tab tool to turn long data into wide format, pivot back from transpose, and configure group by, header changes, and value aggregation for clean dataset reassembly.

Explore the arrange tool in Alteryx to transpose data, maintain key fields, and create new columns that yield three records per user, featuring first name, birth date, and email.

Use the DateTime tool to convert strings to dates and dates to strings, applying predefined or custom formats, and output new columns for time series analysis.

Explore how the text to columns tool splits a single address field into multiple columns using delimiters like comma, space, and hyphen, with options for extra characters and prefixes.

Export data to excel files from Alteryx, learn to write to excel, create and overwrite sheets, and dynamically split results into city and month tabs.

Export results to a database to enable automated, live-updating analytics with Tableau dashboards. Learn to configure Alteryx to write to a database, including table creation and overwrite options.

Explore workflow best practices using comment boxes to describe sections, enable handovers, and enhance collaboration with color, shapes, fonts, and text alignment.

Discover how tool containers group and manage parts of an Alteryx workflow, enabling selective execution and easy reorganization. Label, style, and nest containers to improve clarity and control.

Cache large datasets to speed Alteryx workflow runs by locking input data in memory and reusing it during iterative builds. When inputs change, rehash the data and refresh the cache.

Explore the explorer box on the canvas to display web pages, directories, or files by dragging it in and configuring a path, then open items with their default programs.

Implement automated controls and validations in your Alteryx workflow to detect null values and invalid teams, triggering alerts and ensuring only red or blue teams win.

Discover what to expect in the Alteryx design core exam, including open-book format, two hours, and a mix of practical and multiple-choice questions.

Celebrate completing the alteryx fundamentals course by mastering data sourcing, preparation, joining, and transforming data, and apply these workflow best practices to real-world projects, plus explore Tableau and SQL basics.