Alteryx - The Complete Masterclass

Import Excel files in a new Alteryx workflow by selecting the stores sheet, adjusting range and header options, and importing multiple files with subdirectories and wildcards to expand records.

Explore how annotations clarify what each tool does in an Alteryx workflow, distinguishing the tool name from the annotation and configuring visibility to improve readability.

Use the date time now input to capture date and time in your workflow. Choose output for hour, minute, second or date and day, and language options for text formats.

See how the auto field tool in Alteryx automatically detects field types and updates data types, addressing date format issues, blanks, and decimal separators before converting dates.

Use the date time tool to convert the date column into a date format with day, month, and four-digit year using forward slashes, producing a new date column.

Learn to compute a running total in Alteryx using the multi row formula, grouped by store, starting from zero for the first record to sum weekly sales across rows.

Learn to use the join tool to combine two data streams on a common field like store id, explore inner, left, and anti-joins, and handle data type mismatches.

Explore the summarize tool to transform and aggregate data, grouping by store and year, and compute sums, averages, and counts for weekly sales.

Calculate running totals on weekly sales in Alteryx by grouping by store and year (and department), and start a new total when a new store or year begins.

Combine table and charts into one record with the join multiple tool, then design a vertical or horizontal layout with the layout tool to render a cohesive PDF report.

Explore a beta visual layout tool as an alternative to join multiple, then drag tables and charts, manage layout, set a4 portrait, and render the final report.

Convert latitude and longitude to spatial points, create seven kilometer trade area polygons around schools, and identify houses for sale within those radii, visualizing centroids and polygons on a map.

Explore in-database tools in Alteryx, learn their benefits, and practice by downloading and installing a local database to work along with the instructor.

Leverage the filter in db tool to run a database level filter using SQL syntax, selecting records with record ID greater than five and previewing results with the browse tool.

Apply a formula in the in-database context to update an existing field, doubling weekly sales by entering an expression or using existing columns, then run to verify.

Learn to use the select tool to rename fields and drop unwanted columns, run the workflow, and troubleshoot tool connections when combining tools in an Alteryx workflow.

Learn to union data from two store tables in Alteryx using the union in-db tool, create a second table with SQL, and configure auto configuration by name or position.

Connect the IMDb data stream to a write data in database tool, choose append, overwrite, or create new, name the table sales store info, and verify results in the database.