Brio Software’s BrioQuery is a well-established enterprise business intelligence suite and analytical application development platform. BrioQuery offers functionality for ad hoc database queries, reporting, and online analytical processing analysis. It supports a wide range of databases, including Microsoft Access, DB2, Oracle, Microsoft SQL Server, and Sybase.
BrioQuery is divided into three desktop clients:
- BrioQuery Navigator—The Navigator client offers functionality that the “average” user would need, providing analysis and reporting via predefined data models.
- BrioQuery Explorer—The Explorer client is more powerful than the Navigator client; it targets programmers who need to create the queries for the Navigator client.
- BrioQuery Designer—The Designer client provides database administrators with query, analysis, reporting, security, and auditing tools.
The Navigator client
The BrioQuery Navigator client doesn’t allow direct access to tables, so it’s best used for team members who don’t have any relational database experience. BrioQuery Navigator retrieves information through a data model, which is a graphical representation of a database, or through existing queries created by developers or DBAs with either the Explorer or Designer clients. Data models can be employed to create custom views of databases, add computed columns or fields, and substitute more descriptive names for table columns.
The Explorer client
The BrioQuery Explorer client offers the same features as the Navigator client; however, unlike the Navigator client, you need to have relational database expertise to get the benefit of the Explorer client’s additional features, such as the ability to customize data models.
The Designer client
The BrioQuery Designer client provides all the features from both the Navigator and Explorer clients. In addition to these features, you can use the Designer client to create data models, perform database administrator functions, and modify security, auditing capabilities, and repository setup. The user interface for BrioQuery’s Designer client is reminiscent of the Design View in Microsoft Access, making the user interface relatively easy to learn.
Now I’ll walk through a quick example of how BrioQuery completes a basic reporting task.
BrioQuery in the real world
One of our customers wanted information on how many and what types of requests they were receiving from their internal users via a recently implemented tech support intranet. This technical request system allowed users to enter any of about a dozen types of programming requests that the support programmers would then act upon.
Using the Designer client, I quickly created ODBC connections to the technical request system’s SQL Server database and started selecting columns that I wanted to use for my first report, as shown in Figure A. I was amazed at how quickly the whole report came together, including an aesthetically appealing graph, as shown in Figure B. I presented the document in a tabular fashion so that you can navigate between the graph and the report.
Slick results, painlessly
Have a great product that you want to share with the Builder.com community? E-mail the editors or post your comments below.