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.

• Using Action Tool in Alteryx

• Using Append Fields Tool in Alteryx

• 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.

• Using Basic Data Profile Tool in Alteryx

• Using Browse Tool in Alteryx

• Using Poly-Build Tool in Alteryx

• Using Interactive Chart Tool in Alteryx

• Using Control Parameter Tool in Alteryx

• Using Count Records Tool in Alteryx

• Using DateTime Tool in Alteryx

• Using Field Summary Tool in Alteryx

• Using Filter Tool in Alteryx

• Using Report Footer Tool in Alteryx

• Using Formula Tool in Alteryx

• Using Report Header Tool in Alteryx

• Using Join Tool in Alteryx

• Using Report Header Tool in Alteryx

• Using Message Tool in Alteryx

• Using Numeric Up Down Tool in Alteryx

• Using Pearson Correlation Tool in Alteryx

• Using Random Sample Tool in Alteryx

• Using Record ID Tool in Alteryx

• Using Render Tool in Alteryx

• Using Report Map Tool in Alteryx

• Using Report Text Tool in Alteryx

• Using Running Total Tool in Alteryx

• Using Select Tool in Alteryx

• Using Dynamic Select Tool in Alteryx

• Using Sort Tool in Alteryx

• Using Spearman Correlation Tool in Alteryx

• Using Summarize Tool in Alteryx

• Using Table Tool in Alteryx

• 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.