Flexible Dashboard Enhancing Visualization of Database Information

Abstract

Embodiments provide systems and methods allowing optimization of dashboard analytics. In certain embodiments, results obtained from querying a database may be manipulated to arrange, replace, or supplement existing views. The end user is afforded control to drag and drop view(s) for positioning within a dashboard, as well as to provide additional and/or replacement views. The dashboard can serve as one point of contact allowing end users to render reports created in business warehouse systems, or business intelligence on-demand systems.

1 . A computer-implemented method comprising:
 causing a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of available views from the database query result, wherein the listing of available views further includes the icon;   causing the view engine to receive an input from a user, wherein the user input comprises selecting a single available view from the listing, wherein the single available view comprises query result information from the database query result;   in response to the input, causing the view engine to create a modified dashboard comprising the single available view; and   causing the view engine to display to the user, the modified dashboard.   
     
     
         2 . A method as in  claim 1  wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view. 
     
     
         3 . (canceled) 
     
     
         4 . A method as in  claim 1  wherein the single available view comprises a different format including query result information already present in at least one of the plurality of views. 
     
     
         5 . A method as in  claim 4  wherein the different format reflects a change between vertical or horizontal orientation. 
     
     
         6 . A method as in  claim 4  wherein the different format reflects a change between a chart of one format and a chart of a different format. 
     
     
         7 . A method as in  claim 4  wherein the different view format reflects a change between a chart and a plot. 
     
     
         8 . A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
 causing a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of single available views from the database query result, wherein the listing of available views further includes the icon;   causing the view engine to receive an input from a user, wherein the user input comprises selecting an available view from the listing, wherein the single available view comprises query result information from the database query result;   in response to the input, causing the view engine to create a modified dashboard comprising the single available view; and   causing the view engine to display to the user, the modified dashboard.   
     
     
         9 . A non-transitory computer readable storage medium as in  claim 8  wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view. 
     
     
         10 . (canceled) 
     
     
         11 . A non-transitory computer readable storage medium as in  claim 8  wherein the single available view comprises a different view format including query result information already present in at least one of the plurality of views. 
     
     
         12 . A non-transitory computer readable storage medium as in  claim 11  wherein the different format reflects a change between vertical or horizontal orientation. 
     
     
         13 . A non-transitory computer readable storage medium as in  claim 11  wherein the different format reflects a change between a chart of one typo format and a chart of a different format. 
     
     
         14 . A non-transitory computer readable storage medium as in  claim 11  wherein the different format reflects a change between a chart and a plot. 
     
     
         15 . A computer system comprising:
 one or more processors;   a software program, executable on said computer system, the software program configured to:   cause a view engine to display to a user on a screen, a dashboard comprising a plurality of views of a database query result produced by a query engine, each of the plurality of views including an icon comprising a miniature depiction of a format type of the query result, together with a listing of available views from the database query result, wherein the listing of available views further includes the icon;   cause the view engine to receive an input from a user, wherein the user input comprises selecting a single available view from the listing, wherein the single available view comprises query result information from the database query result;   in response to the input, cause the view engine to create a modified dashboard comprising the single available view; and   cause the view engine to display to the user, the modified dashboard.   
     
     
         16 . A computer system as in  claim 15  wherein the user input comprises clicking on the single available view in the listing, and the modified dashboard comprises replacing one of the plurality of views with the single available view. 
     
     
         17 . (canceled) 
     
     
         18 . A computer system as in  claim 15  wherein the single available view comprises a different view format including query result information already present in at least one of the plurality of views. 
     
     
         19 . A computer system as in  claim 18  wherein the different format reflects a change between vertical or horizontal orientation. 
     
     
         20 . A computer system as in  claim 18  wherein the different format reflects a change between one of,
 a chart of one format and a chart of a different typo format; and 
 a chart and a plot. 
 
     
     
         21 . A computer system as in  claim 18  wherein the icon comprises a bar chart, a plot, a pie chart, or a table. 
     
     
         22 . A method as in  claim 1  wherein the icon comprises a bar chart, a plot, a pie chart, or a table. 
     
     
         23 . A non-transitory computer readable storage medium as in  claim 8  wherein the icon comprises a bar chart, a plot, a pie chart, or a table.