This project aims to show capabilities of Alteryx software on the Kaggle data named "Superstore". The project includes creation of an analytic application, spatial analysis, creating report visualisations, exploratory data analysis, and a unique Alteryx approach to the traveling salesman problem.
- Using Alteryx Tools: Input Data Tool, Auto Field Tool, DateTime Tool, Join Tool, Union Tool, Formula Tool, Select Tool, Create Points Tool, File Browse Tool, Text Box Tool, Action Tool, Radio Button Tool, Summarize Tool.
- Using Alteryx Tools: Summarize Tool, Formula Tool, Sample Tool, Sort Tool, Join Tool, Union Tool, Filter Tool, and more.
- Using Alteryx Tools: Union Tool, Interactive Chart Tool, Layout Tool, and more
- Using Alteryx Tools: Union Tool, Interactive Chart Tool, Layout Tool, and more
- Using Alteryx Tools: Spearman Correlation, Pearson Correlation, and more.
- Using Alteryx Tools: Poly-Build Tool, Make Points Tool.
This iterative macro uses iterative process to find the nearest location using spatial analytics. This macro aims to solve the "Traveling Salesman Problem", but it needs an upstream macro that will run this process for other combination of starting points, which is further solved in "Shortest Route Batch" Macro.
- Using Custom Made Iterative Macro
- Investigating Custom Made Iterative Macro
This batch macro uses batch process to find the nearest location using spatial analytics. This macro aims to solve the "Traveling Salesman Problem", and it is used to produce many outputs using batches. It needs an upstream macro, that will actually find the most optimal route, using MIN function, which is tackled further in the "Shortest Route Checker" Standard Macro.
- Using Custom Made Batch Macro
- Investigating Custom Made Batch Macro
This standard macro feeds iterative and batch process to find the nearest location using spatial analytics. This macro aims to solve the "Traveling Salesman Problem", but it's limitation is the longer run times, depending on the amount of locations it needs to connect and check.
- Using Custom Made Standard Macro
- Investigating Custom Made Standard Macro
An analytic app containing the user interface, spatial, reporting, macros, and other advanced functionalities.
The folder contains screens of the workflow, as is in the file.
Tool Mastery | Alteryx Interface Tool Group | Action Tool
- Using Action Tool in Alteryx
Alteryx Help | Alteryx Join Tool Group | Append Fields Tool
- Using Append Fields Tool in Alteryx
Tool Mastery | Alteryx Preparation Tool Group | Auto Field Tool
- Screen-shot below presents the configuration of the auto filed tool. The metadata tab is selected on purpouse, as the tool will convert the string data types, as in the output anchor. The configuration of the tool comes down only to selection of the fileds, of which types we whish to adjust.
- Screen-shot below presents the output anchor of the auto field tool, with already converted file types. As seen, some types like double or byte were easily recognizable by the tool, and got changed from string.
Tool Mastery | Alteryx Data Investigation Tool Group | Basic Data Profile Tool
- Using Basic Data Profile Tool in Alteryx
Tool Mastery | Alteryx In/Out Tool Group | Browse Tool
- Using Browse Tool in Alteryx
Alteryx Help | Alteryx Spatial Tool Group | Poly-Build Tool
- Using Poly-Build Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Interactive Chart Tool
- Using Interactive Chart Tool in Alteryx
Alteryx Help | Alteryx Interface Tool Group | Control Parameter Tool
- Using Control Parameter Tool in Alteryx
Alteryx Help | Alteryx Transform Tool Group | Count Records Tool
- Using Count Records Tool in Alteryx
Alteryx Help | Alteryx Parse Tool Group | DateTime Tool
- Using DateTime Tool in Alteryx
Alteryx Help | Alteryx Data Investigation Tool Group | Field Summary Tool
- Using Field Summary Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Filter Tool
- Using Filter Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Report Footer Tool
- Using Report Footer Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Formula Tool
- Using Formula Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Report Header Tool
- Using Report Header Tool in Alteryx
Alteryx Help | Alteryx Join Tool Group | Join Tool
- Using Join Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Layout Tool
- Using Report Header Tool in Alteryx
Alteryx Help | Alteryx Developer Tool Group | Message Tool
- Using Message Tool in Alteryx
Alteryx Help | Alteryx Interface Tool Group | Numeric Up Down Tool
- Using Numeric Up Down Tool in Alteryx
Alteryx Help | Alteryx Data Investigation Tool Group | Pearson Correlation Tool
- Using Pearson Correlation Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Random % Sample Tool
- Using Random Sample Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Record ID Tool
- Using Record ID Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Render Tool
- Using Render Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Report Map Tool
- Using Report Map Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Report Text Tool
- Using Report Text Tool in Alteryx
Alteryx Help | Alteryx Transform Tool Group | Running Total Tool
- Using Running Total Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Select Tool
- Using Select Tool in Alteryx
Alteryx Help | Alteryx Developer Tool Group | Dynamic Select Tool
- Using Dynamic Select Tool in Alteryx
Alteryx Help | Alteryx Preparation Tool Group | Sort Tool
- Using Sort Tool in Alteryx
Alteryx Help | Alteryx Data Investigation Tool Group | Spearman Correlation Tool
- Using Spearman Correlation Tool in Alteryx
Alteryx Help | Alteryx Transform Tool Group | Summarize Tool
- Using Summarize Tool in Alteryx
Alteryx Help | Alteryx Reporting Tool Group | Table Tool
- Using Table Tool in Alteryx
Alteryx Help | Alteryx Join Tool Group | Union Tool
- Using Union Tool in Alteryx
The images used in this README are the property of Alteryx, Inc. and are used here for informational purposes only. All rights to these images are retained by Alteryx, Inc. No copyright infringement is intended.