Awesome Open Source
Awesome Open Source



How many times have we run SQL queries on RDBMS, extract data, copy it to excel sheet and plot simple trend charts? Why don't use any of the existing BI or reporting tools? The overhead of using heavy weight BI tools is little too much for a simple report/charting requirement. Firstly, you need to have a licensed version, trial versions are good but they don't offer continuity. Secondly, there is a learning curve associated in building reports, no one lets you transform SQL queries to chart directly, you need to know the product in building even a simple report.


Query2Report addresses both these limitations. Query2Report provides a simple opensource business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting with following features

  • The application transforms bunch SQL queries to beautiful google charts
  • The application caters to real time reporting with automatic refresh functionality
  • Data from multiple database instance can be pulled and displayed in a single report
  • Role based security allows the users to create public or personal reports
  • Angular JS is used to build this application as a SPA and HTML 5 responsive user interface design makes it run on seamlessly laptops, mobiles and tablet

Video tutorials


Statistical Analysis - New Feature

alt text alt text

Sample Reports

alt text

Related Awesome Lists
Top Programming Languages
Top Projects

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Java (388,172
Dashboard (16,359
Web Application (6,998
Business (6,085
Statistical Analysis (690
Business Intelligence (387
Google Charts (300
Reporting Tool (113
Report Generator (78
Reporting Engine (77
Web Based (67
Reportportal (48
Auto Refresh (16
Reporting Services (8