Alteryx for Beginners: Up & Running with Alteryx Designer

About this course

This is a hands-on, project-based course designed to help you build automated Alteryx workflows for extracting, cleaning, transforming and analyzing raw data.We’ll start by introducing and installing Alteryx Designer and exploring options for importing and exporting data from flat files, folders, text, and databases.Next, we’ll apply tools to prepare our data for analysis, including filtering, sorting, sampling, cleansing, and more. We’ll dive into data transformation, and use joining tools to combine data from multiple streams, parsing tools to modify and extract text, spatial tools to create maps and distance calculations, and transpose tools to aggregate, transform, and reshape our data into new formats.Last but not least we’ll use data visualization and automation to bring our Alteryx workflows to life, with custom layouts, interactive charts, maps, macros, and more.Throughout the course, you’ll play the role of Senior Alteryx Developer for MavenData, a company that collects and aggregates food and beverage data from retailers across the US. Your role? Help the company build automated workflows to prepare its raw data for reporting and data analysis.COURSE OUTLINE:Intro to Alteryx DesignerReview the Alteryx Designer workspace, tools, and engineData Import & ExportInput and output data to and from flat files, text, and databasesData PreparationSelect, clean, classify, sort, and create columns/rowsData TransformationLeverage tools to parse, join, transform, and summarize dataReports &

Course objectives

• provide hands-on experience with Alteryx Designer
• teach data cleaning and transformation techniques
• enhance skills in data visualization and automation