Course Code: bspalteryx
Duration: 14 hours
Prerequisites:

Bespoke course

Overview:

This is a bespoke course for Akeso and Co

Course Outline:

Part 1 (7 hours)

This part will be an introduction to Alteryx and the various tools it offers.

  • What you will learn?

    • Develop Alteryx workflows

    • Create ETL (Extract, Transform and Load) processes

    • Perform predictive analytics functions

    • Build custom data transformations

    • Develop repeatable Alteryx macros

    • Embed custom R code inside Alteryx

    • Use Alteryx in your professional day job

  • Course Content

    • Introduction

      • Overview

      • Installation

      • Interface walkthrough

    • Input tools

      • Introduction to input tools

      • Connect to .csv, .xlsx, compressed files and sql server

      • Text input

      • Directory

      • Output data - write to excel, sql server

      • Data time now

      • Browse

    • Preparation tools

      • Select

      • Data cleansing

      • Filter

      • Formula (Multi-Field / Multi-Row)

      • Sort

      • Record ID

      • Unique

      • Sample

      • Random % Sample

      • Auto Field

      • Imputation

      • Tile

      • Generate rows

    • Join tools

      • Join / Join multiple

      • Union

      • Append

      • Find replace

      • Fuzzy match

      • Make group

    • Transform tools

      • Summarize

      • Running total

      • Weighted average

      • Transpose

      • Cross tab

      • Arrange

    • Parse tools

      • DateTime

      • RegEx

      • Text to columns

    • Reporting tools

      • Intro

      • Table

      • Interactive chart

      • Report text

      • Report header

      • Report footer

      • Report layout

      • Render

    • In-Database tools

      • Intro

      • Connect In-DB & Data Stream Out

      • Browse In-DB

      • Select In-DB

      • Filter In-DB

      • Formula In-DB

      • Join In-DB

      • Data stream in

      • Summarize In-DB

      • Sample In-DB

    • Documentation tools

      • Comment

      • Explorer Box

      • Tool container

    • Macros

      • Intro

      • Workshop - Creating a standard macro

Part 2 (7 hours)

This part will mostly contain exercises and real world use cases.

  • What you’ll learn through real world exercises?

    • Create averages with outliers

    • Create dynamic concatenations

    • Create robust regular expression formulas

    • Understand types of joins and how they work

    • Parse data using text to columns

    • Create percentage format

    • Convert date to strings format and string to date formats

    • Create generate rows for loop expressions

    • Work with transposing and appending data

    • Perform log transformations

    • Create time differences

    • Combine merged strings

    • Create running averages

    • Determine distance using spatial tools

    • Find missing values

    • Create batch macros

    • Create In-DB collection

    • Create In-DB joining and aggregation

    • Work with Fuzzy matching

    • Count keywords

    • Combine files from single input

    • Create multi row formulas

    • Perform data cleansing

    • Create dynamic variables

  • Course Content

    • Real-life exercises

      • Average ignoring zeros

      • Dynamic concatenation

      • Date parsing

      • Time conversion

      • Sample size summarized

      • Repeating unique

      • First day month

      • Time difference

      • Dynamic variables

      • String identifiers

      • Character count

      • Transforming data

      • Summarize time segments

      • Log transformation

      • Percentage format

      • Rearranging columns

      • Filtering price differences

      • Merged strings

      • Parse numbers and strings

      • Fuzzy matching

      • Previous value check

      • Grouped regular expressions

      • Missing values

      • Quiz

    • Real-life use cases

      • Join to area

      • Count keywords

      • Data parse method

      • Delimiter cleansing

      • Running averages

      • Standardize dates

      • Spatial distance

      • Quiz

    • Excel to Alteryx series

      • Combining files from single input

      • Data cleansing and multi-row formulas

      • Date calculations

      • Calculating rates

      • Quiz

    • Batch macros

      • Batch macro multiplier

      • Quiz

    • In-Database

      • In-Database connection

      • In-Database joining and aggregation

      • Quiz