Pivot Tabelle

Die Innovationen von NeoNeuro machen die Erstellung von Berichten zu einem Vergnügen!

Data Mining

Pivot Table

NeoNeuro innovations turned report creation into pleasure! Only one mouse click is enough to get trends or pie charts, reveal leaders and outsiders in all parameters like region, product or in any others. Use filters to get answers for complicated questions like “How did milk sales change in New York for the last month with dependence on package type?” Do not bother about data overwhelming – NeoNeuro Pivot Table automatically identifies the most important values and put the rest into “Others” group. Safe you time, use the best – download free NeoNeuro Pivot Table now!

NeoNeuro Pivot Table shows detailed analysis and creates comprehensive sales report from Excel and csv files or SQL Databases.

Pivot table is one of the most powerful tools of MS Excel and other grid-like applications. The only problem is that we need to spend a lot of time, creating needed Pivots and hence it is not convenient for fast financial statistics. This problem is solved in NeoNeuro Pivot Table application. Forget about boring calculations and formula creations – just click on needed cells and enjoy the well-structured results. Copy data and pictures to your report or click on “Report in  Word” button and report will be generated automatically. Financial analysis has never been so easy!

 


  • Time and Money conception
  • Pivot Table automatically
  • Grouping automatically
  • Detailed information about each value in each parameter
  • Sum and trends calculations automatically
  • Easy export to Excel
  • Financial report generation automatically      

Lets look at the grid. Values in each column are grouped. Pay attention that last values in parameters “Customer Name” and ”Province” are “Others”. Pivot Table Finance automatically selects top-12 elements using sums of sales  and all other elements combined into a single one called “Others”. Sums of sales are written after name of value, for instance, at the top of “Customer Name” we see 

Emily Phan | $34,005.45 | 10

What it means:

Emily Phan – name of client

$34,005.45 - amount of money he spent

10 – number of purchases from sthis customer.

By the way, Emily Phan is the best client! Why?

Elements in columns are sorted from the most important at the top – we see that Deborah Brumfield spent less and so on. “Others” element, if any, always at the bottom.

Let’s look at the next parameter: “Province”, here we see green and red arrows which show the trend of sales for last period comparing to previous period of time. By default it is last 30 days and from 31 till 60 day before. Quebec is marked with bold arrow because it has the best trend, +5229% for last month. It is not the first in this column because Ontario and some others have more sales for all the time of dataset.

Click on  Quebec.


  

In text field in bottom-left of window, we see detailed report about situation in Quebec. Trend +5229% appears because of poor sales in November and great sales in December.

Now chart shows monthly sales only in Quebec.

Big arrows show the best increase (green) and the worst decrease (red) in last 30-day-period trend.

Click on Grid by right mouse button and select “Pie Chart”. Now click in any meaningful  cell and NeoNeuro Pivot Table shows pie chart. You can copy chart to clipboard to use in your reports.

 

 

This is sales pie chart for regions: 

 

 Click on grid with right mouse button and select in context menu “Copy grid”. You can paste data to Excel or other spreadsheet application or use them as text for csv creation.   Click on “Report in Word” now. MS Word opens and detailed sales report generates automatically: For each parameter report writes name of parameter and elements with max and min sales, and the best and the worst element in trend. For instance:

 NeoNeuro Pivot Table supports up to 100 rows for free.

 

 

 

Kommentar schreiben


Sicherheitscode
Aktualisieren