Missing Data

Surveys are full of ‘empty’ data – questions not answered, options not selected, gaps in data entry – but all of it is important to gaining a full understanding of the results. Of the people that answered a question, what was the average score? Of those that did not, how did they rate you on another aspect of your business versus those that did?  Are some questions more likely to be answered than others?

Nextanalytics respects the difference between an empty cell and a cell with a zero value. Empty cells are automatically excluded from metric calculations like Count and Average so you don’t have to write complicated algorithms to handle them.  When you want those cells to be included, Nextanalytics makes it easy to assign a value to them, either a fixed value like zero, or a value based on the previous one in a sequence.

Multiple Choice Segmentation

In the quest for segmented results, survey designers use multiple choice questions with uniquely worded response options so respondents can be categorized. Over time, these options may be modified to drive improvements in segmentation, and a better understanding of where things are going right or wrong.  The analysis must be equally dynamic, looking at how today’s responses compared with yesterday’s. Has the picture improved as expected?

With no ‘schema’ or fixed table structure to get in the way, Nextanalytics can easily adapt to multiple choice questions using simple functions. The analytic transformations automatically adapt to the data loaded, with rows or columns created as required. Custom ordering of rows or columns (e.g. Low-Medium-High) is another common challenge that is easily handled, even when there isn’t data for every option.

Simple Questions, Simple Answers

Most survey-type applications are asking a series of simple questions, and we want a set of simple answers from our analysis. Composing intricate formulas, building complicated reports, or interpreting advanced statistical functions forces attention on the process and away from the results. The tools you use should not become the answer.

Nextanalytics uses powerful script functions that act on entire tables of data. There are no formulas to copy, no analytic cubes to construct, and Nextanalytics for Excel makes it easy with a simple interactive interface. You will quickly find that the steps are highly reusable and you can build your own library of common ‘macros’. Providing your customers with better insight doesn’t require a huge investment infrastructure, skills or time. Nextanalytics’ in-memory operation and multiplatform support let you bolt it onto your application or connect it to your dashboard with minimal effort.

Open the door to possibilities you thought were beyond your reach. Read more about our capabilities. Contact us today.