13 Mar 2020

Course Description:

This course will cover Alteryx Designer for intermediate and experienced Alteryx users who require more advanced features.

The student is provided with data sources and hands-on exercises to cover the course content. The material provides tips throughout as well as challenges to allow the students to put into practice the concepts taught in each module.

Audience:

Anyone who currently works with or analyses data, including business analysts, data analysts and developers.

Approach:

Tell me, show me, and let me do it.

Business Needs:

  • I have an Excel spreadsheet which has multiple tabs and would like to combine the data from a selection of these tabs and create a new spreadsheet or combine multiple Excel spreadsheets but exclude a specific sheet?
  • Do you have to match Customer data using fuzzy match logic?
  • Are there times when you have wide data such as survey data, but you need to rearrange it so that you can use it in a BI tool?
  • Do you need to download and parse data from the internet?
  • Do you have large volumes of database data to process?
  • Do you need to use the PSMA Geocoded National Address Files for location and address now that the data has been made public and would you like to store the data in the Calgary database?
  • Do you need to parse Java Script Notation text?
  • Do you have the need to create and use Macros!
  • Have you the need for Time Series Forecasting? Or Predictive Analytics?

Course Content:

Excel Multiple Sheets

Dynamically input Excel data, both with multiple sheets and multiple workbooks with the option to exclude nominated sheets using the following tools:

  • Text Input
  • Dynamic Input
  • Output Data
  • Dynamic XSLX
  • Browse

Fuzzy Match

Explore the Fuzzy Match options, Purge and Merge, along with tutorial and challenge, introducing:

  • Input Data
  • Fuzzy Match
  • Join
  • Union
  • Sort
  • Filter
  • Unique
  • Summarize

Survey Data

Find out how to prepare survey data for your BI tool, including a challenge, while introducing:

  • Transpose
  • Select
  • Text To Columns
  • Tableau Workbook Macro
  • Tableau TWBX
  • Formula
  • Running Total

Download Data and XML Parse

Download data from websites and parse for output. Follow me and challenges introducing:

  • Sample
  • Download
  • Auto Field
  • Tool Container
  • Multi-Field Formula
  • RegEx
  • XML Parse
  • RecordID
  • Cross Tab
  • Dynamic Rename
  • Dynamic Select
  • Data Cleansing

InDB Processing

Process data in your database to enhance performance introducing:

  • Connect In-DB
  • Formula In-DB
  • Summarize In-DB
  • Data Stream Out

GNAF and Calgary Database

Explore Geocoded National Address file data, both at location and address level and placing that data into a Calgary Database. Retrieving and joining the data to business data, including challenges, introducing:

  • Calgary Loader
  • Calgary Input
  • Calgary Join

JSON Parse

How to parse Java Script Notation (JSON) data using:

  • JSON Parse
  • Create Points

Macros

Create and use a macro with challenge, introducing:

  • Macro Input
  • Detour
  • Detour End
  • Macro Output
  • Drop Down
  • Action
  • Numeric Up Down
  • Check Box
  •  List Box

Time Series Forecasting

Explore Time Series data and create Time Series Forecast models to compare the results and create the forecast, introducing:

  • TS Plot
  • ETS
  • ARIMA
  • TS Compare
  • TS Forecast

Predictive Analysis

Investigate new donor data to determine who is most likely to donate, predict and score the results, introducing:

  • Basic Data Profile
  • Association Analysis
  • Contingency Table
  • Distribution Analysis
  • Field Summary
  • Scatterplot
  • Violin Plot
  • Create Samples
  • Decision Tree
  • Lift Chart
  • Score