Building and Validating a Predictive Model - SkilBrill

Alteryx Training Building and Validating a Predictive Model

Alteryx Training

0% Completed

Module 1 — Alteryx Designer Foundations

The Designer Interface, Tool Palette and Canvas

The Configuration Pane, Results Window and Error Messages

Input and Output Data Tools

The Select Tool

Running and Saving a Workflow

yxdb Output for Fast Intermediate Storage

Module 2 — Data Preparation and Cleansing

Select and Data Type Changes

Sort, Unique, Filter and Sample

Summarize for Group-By Aggregation

The Data Cleansing Tool and DateTime Parsing

Null and Whitespace Handling

String Functions

Module 3 — Joins, Unions and Parsing

Join and Union to Match and Append Datasets

Transpose and Cross Tab Reshaping

Text to Columns and Find Replace

Parsing Nested JSON and XML Exports into Flat Rows

Module 4 — Record Operations and Formulas

Record Id, Test, Tile and Running Sum

Multi-Row Formula

Multi-Field Formula

Conditional Logic in Expressions

Working with Million-Row Extracts

Module 5 — Spatial Analytics

Spatial Objects and the Spatial Field

Create Points from Coordinates or Addresses

Distance and Trade Area with Rings and Drive-Time

Mapping Results for Reporting

Module 6 — Predictive and Machine Learning Tools

Linear and Logistic Regression

Forest and Boosted Models

K-Means Clustering

Test and Score Validation

Scoring a Holdout Dataset

Reading Model Reports and Validation Scores

Module 7 — Macros: Standard, Batch and Iterative

Standard Macros for Reusable Logic

Macro Interface Tools for Numeric, Text and Drop-Down Inputs

Batch Macros Driven by a Control Parameter

Iterative Macros That Loop Until a Condition Is Met

Saving and Sharing Macros (.yxmc)

Module 8 — Scheduling and Server Automation

Publishing a Workflow to a Private Gallery

Scheduling Daily and Weekly Runs

Job History and Failure Alerts

Analytic Apps with Interface Tools

Connections and Credentials on the Server

Module 9 — In-Database Tools and Performance

In-DB Connections

In-DB Join and In-DB Select

Pushing Processing into the Database and Reducing Data Volume Early

Profiling Fields in the Results Window

Output Formats for BI Tools

Module 10 — Capstone: Analytics Workflow End to End

Ingesting Messy Source Files

Cleansing and Joining the Source Data

Spatial Trade-Area Analysis

Building and Validating a Predictive Model

Wrapping the Scoring Step in a Macro

Scheduling the Workflow for a Weekly Run

Module 11 — Certification and Interview Prep

Alteryx Designer Core Exam Patterns

Workflow Debugging Questions

Explaining Tool Choices in an Interview

Portfolio of Your Workflows

Resume and LinkedIn Review

Mock Analyst Interview

Announcements Course Info