Need an account? Click to Register
Home arrow Product arrow Examples

The following examples show what people have done with nextanalytics. In most cases, they started with a simple SQL or MDX query and followed it by using nextanalytics to transform the data into something more useful. We have included a variety of business scenarios to demonstrate the flexibility of nextanalytics to various datasets and the ease with which results can be delivered.

Some of these reports might be recognizable to you and your business as-is, or with small changes. Many of the examples include the complete script listings - from database query to final presentation - because we believe you can't produce similar reports with any other tools with as little effort. Using nextanalytics frees up your time to take your analyses one step farther and gain new insights into your business.



Filter and Growth Combinations

population_thumb.pngWhen dealing with analytics, there are times that a combination of filtering, sorting and calculations are wanted. Because of the limitations and complexity of many business reporting solutions, it has become common practice to extract the data and manually finish the analysis in a spreadsheet like Microsoft Excel. That extra effort is not required with nextanalytics -- it is a simple matter to perform almost any combination of filtering, sorting and common calculations like growth or net change.

 

 
Top sellers across product lines
productlinecomparison4_thumb.pngSometimes it is not enough to see just the top selling products -- what you'd really like is a view of how the various product lines are represented in that elite list. This is a very simple task for nextanalytics, and doesn't involve any complicated or fragile database queries or setups.
 
Profiling sales volume

orderprofile1_thumb.pngSales reports are full of numbers, big and small, but everyone tends to focus on the big numbers because they are easy to find by sorting. It is nice to be able to celebrate the big wins, but what happens when the bulk of your sales are smaller order sizes? How do you know if one channel or salesperson or product line is performing better than another? Tough question, but with nextanalytics, there is an easy solution.

 
Campaign analysis

campaignanalysis3_thumb.jpgA typical reporting requirement in CRM systems like Microsoft Dynamics CRM is to gauge the success of various marketing campaigns. While nextanalytics can easily generate the commonly provided reports, the real value comes from taking the analysis one step farther.

 
Working with data from multiple sources

ex244.4_thumb.pngMany tools claim to be multi-datasource but they're not as good as this because we allow you to computations, not just show on the same screen.

 
Customer profitability over time
custprofittime5_thumb.pngCustomer profitability is a typical CRM system metric that executives watch closely over time, looking for trends that require their involvement to correct. Most standard reports simply show the numbers, but nextanalytics allows you to take those few additional steps that let you see farther.
 
Customer profit by account
custprofit5_thumb.pngA highly desired CRM system report, the customer profitability report brings attention to customer accounts that bring more than normal profits into the business. Executives want to know who they are so actions can be taken to keep those accounts active and try to replicate the success with other accounts.
 
Distribution of numeric survey data

ex245.8_thumb.jpgAnalysing the distribution of numeric values, such as those found in surveys, demonstrates unique benefits of using NextAnalytics as your processing engine.

 
Year-over-year sales report

Most CRM applications and sales reporting portals include a historical comparison report, usually year-over-year or simply this period compared to last year. With nextanalytics, that simple report is just the starting point for understanding how your business has changed.

 
Benford analysis the easy way
As interest in fraud detection grows, the use of Benford analysis is growing in the audit community. This technique relies on comparing the distribution of the leftmost digit in a set of numbers to a theoretical distribution. This is something nextanalytics does with ease - no spreadsheet forumlas to copy or break, adapting to new data sets with almost no effort.
 
Integrating nextanalytics with Google Charts

Our open source integration examples includes the ability for nextanalytics to supply data to Google Charts and shows how you can easily build this into a dashboard of your own.

 
Blending several analytics into one view

You don't need to send out multiple reports if the data fits on one page.

 
Sales by account - period comparisons

It is very typical to be asked for comparisons of two periods, year-over-year, this quarter to the same quarter last year, this month to last month. The reports are usually all the same as well - current period, previous period, delta (numerical difference) and growth (expressed as a percentage), with the only difference being the row labels and maybe a selection or filtering criteria. With nextanalytics, this type of common report can be reduced to a simple call to run a script from a standard library.

 
Normalization of numeric values
Make charting and visualization easier and more useful.  Use normalization to recognize trends, patterns, and outliers easier.
 
Determine the best and the worst by ranking

Who are your top performers? What were the best months? What and what were the best overall?

 
Example of Maani Chart Integration

Here's a set of charts using the Maani pakage.  See: http://www.maani.us to learn more about this very good package.

 
Easily convert SQL tables to crosstab format

    No metadata or cube building required.  Just supply a query or a data file, and the rest is automatic.

 
Text based analytic distributions

You need to see this to appreciate how much more you can do with your spreadsheet data and query results.

 
Wide range of comparison operations

Compare anything to anything. Really!

 
MDX Challenge

Can MDX do what nextanalytics does? One of our blogs explored this point. A well known blogger and industry veteran Mosha Pasumansky, accepted the comment as a challenge to demonstrate that MDX could indeed easily produce the sample analytic posed in the blog. Please note, it wasn't actually a very tough analytic, as compared to the other examples we've been walking you through.  In any case, the ensuing interaction was enjoyable for everyone who checked in. Mosha wrote a great post in his own blog and was successful in proving that MDX was easily capable of delivering on the sample query.  His response can be found verbatim here.