The example below illustrates the use of Analytic Solver Data Mining’s chart wizard in drawing a Parallel Coordinates Plot using the  dataset. 

A parallel coordinates plot allows the exploration of high dimensional datasets, or datasets with a large number of features (variables).  This type of graph starts with a set of vertically drawn parallel lines, equally spaced, which corresponds to the features included in the graph.  Observations for each feature are recorded as dots on the vertical line.  Observations that are contained within the same record are connected by a line.    

Click Help – Examples on the Data Mining ribbon to open the example dataset, SportsTVRatings.xlsx.  Select a cell within the dataset, say A2, then click Explore – Chart Wizard on the Data Mining ribbon.  The following dialog appears.

Chart Wizard 

Select Parallel Coordinates, and click Next. The Chart Wizard - Variable Selection dialog opens.

 

Select two variables, Indy 500 and Daytona 500. Click Finish to draw the plot.

The first thing that we notice is the range of each of the races that are indicated at the top and bottom of each vertical line.  The range of ratings for the Indy 500 has a high of 10.9 and a low of 2.3 whereas the range for the Daytona 500 is 11.3 to 4.4.  As a result, this chart already conveys that the viewership for the Daytona 500 is larger than the viewship for the Indy 500. 

When looking at the observations for each feature, this chart shows that in most years, the viewship of the Indy 500 was low whereas the viewship for the Daytona 500 was high.  There are just four years wheree high ratings for the Indy 500 was recorded.  In these same years, the ratings for the Daytona 500 was correspondingly lower. 

To remove a variable from the matrix, uncheck the desired variable under Filters. To add a variable to the matrix, check the desired variable under Filters.

Common Options ToolBar 

To exit the graph, click the red X in the upper right-hand corner of the Chart Wizard Window.

Save Chart Window 

To save the chart for later viewing, click Save. To delete the chart, click Discard. To cancel the save and return to the chart, click Cancel. For this example, type Parallel for the chart name, then click Save. To reopen the chart, on the Data Mining ribbon, from the Data Analysis tab, select Explore - Existing Charts - Parallel.

Using Analytic Solver Cloud to Create a Parallel Coordinates Chart

Click Help – Example Models – Forecasting / Data Mining Models in Analytic Solver Cloud to open the Sports TV Ratings dataset.  Then click Explore – Chart Wizard and select Parallel Coordinates.

  • Click the down arrow beneath Color By to add a color to specified variable.  In this example, the observations for each year have been giving a different color.    
  • Filter your data by clicking the down arrow next to Filter.  Select the variables to be included in the chart.