Home arrow Kognitio examples arrow Day of Week Profiling
Day of Week Profiling

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.

dow1.png

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

dow2.png

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. 

dow3.png

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.

dow4.png

 

 
Next >
evaluate.png

Database supplied by Kognitio

This example was built on top of the Kognitio WX2 database, using their retail store demo. The Kognitio WX2 database can perform complex queries against a very large dataset and return the results very quickly. When coupled with Nextanalytics, the query result can be further processed and viewed in a wide variety of customizable and useful ways.

These examples demonstrate how Nextanalytics can leverage the power of the Kognitio WX2 database to deliver a complete high speed analytical solution. They are provided as an introduction to some of the things that can be done, even when working from a very large dataset with 11 billion records.  Everything you see is extensible and customizable.

Visit Kognitio's web site for more information.

Other examples