Superstore-Reporting

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.

Iterative Macro used in the "Superstore" project.

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

Batch Macro used in the "Superstore" Project.

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

Standard Macro used in "Superstore" project.

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

Project "Superstore" - Analytic Application only.

An app containing the user interface, spatial, reporting, macros, and other advanced functionalities.

Workflow-Screens Folder

The folder contains screens of the workflow, as is in the file.

Action.png - Alteryx Interface Tool Group: Using Action Tool in Alteryx

Append.png - Alteryx Join Tool Group: Using Append Fields Tool in Alteryx

Auto1.png - Alteryx Preparation Tool Group: Using Auto Field Tool in Alteryx - Input

Auto2.png - Alteryx Preparation Tool Group: Using Auto Field Tool in Alteryx - Output

BasicDataProfile.png

• Alteryx Data Investigation Group
• Using Basic Data Profile Tool in Alteryx

BatchMacro.png

• Alteryx Custom Made Macro Group
• Using Custom Made Batch Macro

Browse.png

• Alteryx In/Out Group
• Using Browse Tool in Alteryx

BuildingSequenceLine.png

• Alteryx Spatial Group
• Using Poly-Build Tool in Alteryx

Chart.png

• Alteryx Reporting Group
• Using Interactive Chart Tool in Alteryx

ControlParameter.png

• Alteryx Interface Group
• Using Control Parameter Tool in Alteryx

Count.png

• Alteryx Transformation Group
• Using Count Records Tool in Alteryx

CustomMacro.png

• Alteryx Custom Made Macro Group
• Using Custom Made Standard Macro

CustomMacro2.png

• Alteryx Custom Made Macro Group
• Using Custom Made Batch Macro

CustomMacro3.png

• Alteryx Custom Made Macro Group
• Using Custom Made Iterative Macro

DateParse.png

• Alteryx Parse Group
• Using Date Parse Tool in Alteryx

FieldSummary.png

• Alteryx Data Investigation Group
• Using Field Summary Tool in Alteryx

Filter.png

• Alteryx Preparation Group
• Using Filter Tool in Alteryx

Foot.png

• Alteryx Reporting Group
• Using Report Footer Tool in Alteryx

Formula.png

• Alteryx Preparation Group
• Using Formula Tool in Alteryx

Head.png

• Alteryx Reporting Group
• Using Report Header Tool in Alteryx

IterativeMacro.png

• Alteryx Custom Macro Group
• Using Custom Made Iterative Macro

Join.png

• Alteryx Join Tool Group
• Using Join Tool in Alteryx

Layout.png

• Alteryx Reporting Group
• Using Report Header Tool in Alteryx

Msg.png

• Alteryx Developer Tool Group
• Using Message Tool in Alteryx

NumericUpDown.png

• Alteryx Interface Tool Group
• Using Numeric Up Down Tool in Alteryx

Pearson.png

• Alteryx Data Investigation Group
• Using Pearson Correlation Tool in Alteryx

Random.png

• Alteryx Data Preparation Group
• Using Random Sample Tool in Alteryx

Record ID.png

• Alteryx Data Preparation Group
• Using Record ID Tool in Alteryx

Render.png

• Alteryx Reporting Group
• Using Render Tool in Alteryx

ReportMap.png

• Alteryx Reporting Group
• Using Report Map Tool in Alteryx

ReportText.png

• Alteryx Reporting Group
• Using Report Text Tool in Alteryx

RunningTotal.png

• Alteryx Transformation Group
• Using Running Total Tool in Alteryx

Select.png

• Alteryx Data Preparation Group
• Using Select Tool in Alteryx

SelectDynamic.png

• Alteryx Developer Tool Group
• Using Dynamic Select Tool in Alteryx

Sort.png

• Alteryx Data Preparation Group
• Using Sort Tool in Alteryx

Spearman.png

• Alteryx Data Investigation Group
• Using Spearman Correlation Tool in Alteryx

StandardMacro.png

• Alteryx Custom Made Macro Group
• Using Custom Made Standard Macro

Summarize.png

• Alteryx Transformation Group
• Using Summarize Tool in Alteryx

Table.png

• Alteryx Reporting Group
• Using Table Tool in Alteryx

UnionTool.png

• Alteryx Join Tool Group
• Using Union Tool in Alteryx

WF1.png

• Workflow graphical representation: Loading Data.
• 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.

WF2.png

• Workflow graphical representation: Data manipulation.
• Using Alteryx Tools: Summarize Tool, Formula Tool, Sample Tool, Sort Tool, Join Tool, Union Tool, Filter Tool, and more.

WF3.png

• Workflow graphical representation: Aggregation and reporting.
• Using Alteryx Tools: Union Tool, Interactive Chart Tool, Layout Tool, and more

WF4.png

• Workflow graphical representation: Aggregation and reporting.
• Using Alteryx Tools: Union Tool, Interactive Chart Tool, Layout Tool, and more

WF5.png

• Workflow graphical representation: Data Investigation.
• Using Alteryx Tools: Spearman Correlation, Pearson Correlation, and more.

WF6.png

• Workflow graphical representation: Spatial Analysis.
• Using Alteryx Tools: Poly-Build Tool, Make Points Tool.