An open place to share expertise, information, opinions and insights on new trends in management control, corporate finance, business intelligence, analytics and web development. All screenshots © of their respective owners.

Wednesday, 10 October 2018 13:46

Query2Report analytics

Query2Report is a simple opensource business intelligence solution that allows users to build reports and dashboards for data analytics or corporate reporting. The application transforms SQL queries to beautiful and very impressive Google charts. The application offers automatic refresh functionality for nearly real-time reporting.
The different elements in reports can pull data from multiple databases instance belonging to same or different vendor.

A role based security allows the administrators to create public reports and personal workspaces. Angular JS is used to build this application with a responsive user interface design. It run on laptops, mobiles and tablets.

These are the main features:
  • web based reporting and dashboard generator
  • auto refresh for real-time reporting
  • public and personal report workspaces
  • integrates with any database using JDBC connections
  • role based user access

More information available here:
where you can also find the download link.

Last version issued on August 4th 2018.
Published in analytics
Saturday, 15 April 2017 08:42

WSO2 Smart Analytics

WSO2 Smart Analytics is a very robust open source analytics platform. With Smart Analytics you can utilize batch analytics for historical analysis, interactive analysis for running complex queries across multiple datasets, and use machine learning models for predictive analysis.

It is also a dashboard tool, with the ability to record events and the ability to track operational metrics, to create powerful visualizations for management.

More information available on WSO2 website.

Direct download link is here.
Published in analytics