XL DBQuery description
XL-DBQuery - Easily Query and Analyse your Data

XL-DBQuery is a powerful add-in for Microsoft Excel that makes it easy to perform data analysis and reporting.

Unlike Excel's built-in "MS Query" function, XL-DBQuery offers an intuitive query syntax that lets users build complex queries, without having to master Boolean algebra.

Whether you're a novice Excel user who needs to perform complex data analysis and reporting on corporate-wide data or an experienced data analyst who needs to create complex queries quickly and easily, XL-DBQuery has the tools that you need.

XL-DBQuery is based upon SBS Development's flagship Automated-SQL-Builder query builder, widely considered to be one of the best data querying controls available today.

Rather than forcing analysts to learn new skills, XL-DBQuery builds on the Excel skills that many business people already have. The simple and intuitive interface makes analysts self-reliant and no longer dependent upon data specialists or IT professionals to help them with data analysis.

Here are some key features of "XL DBQuery":

· XL-DBQuery Professional has a simple yet intuitive user interface.
· Utilises users existing Excel skills and extends Excels built-in analysis and reporting capabilities by providing a bridge to your data.
· ‘Self-service’ style analysis and reporting for novice and advanced users alike.
· Query assumptions help users build the queries they want quickly and efficiently without having to learn new skills.
· Adheres to standard database security measures.
· Export data to Excel as standard row column reports or multi-dimensional pivot table reports for dynamic analysis of data.
· Refresh exported results directly from Excel.
· Join and merge data from different data sources.
· Query and analyse virtually any data source within your organisation.
· A cost effective analysis solution for the worlds most widely used spreadsheet.


Limitations:

· 15 daya trial