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. You can find the best casino here all online casinos are good Big win is waiting for you.

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

  4. 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

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

  6. We as a team of real-time industrial experience with a lot of knowledge in developing applications in python programming (7+ years) will ensure that we will deliver our best in python training in vijayawada. , and we believe that no one matches us in this context.

  7. I would like to thank you for the efforts you have made in writing this article. as we provide International Flight Planning at affordable prices. for more info visit our website.

  8. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    data science training in guduvanchery

  9. Excellent blog thanks for sharing the valuable information..it becomes easy to read and easily understand the information.
    Useful article which was very helpful. also interesting and contains good information.
    to know about python training course , use the below link.

    Python Training in chennai

    Python Course in chennai

  10. Excellent post... Thank you for sharing such a informative and information blog with us. keep updating such a wonderful post..

    Java Training in Chennai

    Java Course in Chennai