Skip to content

Query2Report is a simple open source business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting

License

Notifications You must be signed in to change notification settings

yogeshsd/query2report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Query2Report

Overview

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.

Concepts

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

Download

Statistical Analysis - New Feature

alt text alt text

Sample Reports

alt text