Nextanalytics can analyze patterns.

In this example, we look at sales for each day of the week. 

First, the query is submitted by Nextanalytics which returns the following data.

The DAYOFWEEK means day of week, a digit from 0 to 6. 

ITEMS are the number of items sold for each product on the day.

Nextanalytics converts this to a crosstab (creation of crosstabs is very difficult to do with SQL). 

Nextanalytics easily calculates the average number of items sold per day for each product. 

It is also easy to filter out items below average, or below a certain threshold.  This helps to get the list down to the rows that really matter. 

Nextanalytics makes it easy to look at the cells as a comparison to the row average.  This can be done as:

• a straight percentage
• ratio
• number of standard deviations from row average
• ranks (of the values in the row)

With these operations,  it becomes easy to compare how far a value is from the calculated row average.