Tuesday, 3 March 2015

NextReports Server: Analysis

NextReports Server 8.0 has a new module (section) called Analysis. To be able to create an analysis, users must run/schedule an ETL (extract transform load) process which gets data from a data source and brings it locally to A NoSQL database. This process is just a run type defined in export property:

Anytime an ETL process is run, all data for it is first cleared and then new data is brought on.

Inside analysis section, users can select from existing "analysis sources" to create new analysis. At the beginning all the columns are selected and users will see the entire set of data.

From this step, users can start to play with data. New columns can be created like string concatenations, mathematical expressions, aggregate functions:

Users can select and order the columns they are interested in:

 Users can sort, group and filter data:

Pagination is mandatory but can be modified to suit users needs:

After obtaining the results, users can save the analysis for future view. This is handy, because if there is a scheduled ETL  process that brings data locally, users are able to see updated data just by entering the analysis section.

Results can be exported as excel and can be frozen. A "freeze" action means the data set is saved as a copy inside NoSql database and no other ETL process can modify it.

Analysis can be shared to other users. If there is no need for it, analysis can be deleted. This process will also delete the data set associated with it if there is no any other analysis linked to that data set.

To find more, you should read the server section manual.


  1. I have gone through your blog, it was very much useful for me and because of your blog, and also I gained much unknown information, the way you have clearly explained is really fantastic. Kindly post more like this, Thank You.
    airport ground staff training courses in chennai
    airport ground staff training in chennai
    ground staff training in chennai

  2. it is an interesting Article, i read this post that was very nice and useful thanks for sharing it.
    Data Science training in Chennai | Data Science Training Institute in Chennai | Data Science Course in Chennai

  3. You can find the best casino here all online casinos are good Big win is waiting for you.

  4. Где найти профиль для лед ленты люди добрые помогите пожалуйста.

  5. tweaked from the site emergent best online gambling games such awesome everything is so cool drawn and you can talk All sorts of slot machines, slots and other gambling

  6. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends.