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.

10 comments:

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

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

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

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

    ReplyDelete
  5. 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.

    ReplyDelete
  6. 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

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

    ReplyDelete