Business Need

To make informed decisions, Companies need in-depth knowledge of their business transactions, and for that they need an intelligent data analysis tool. Senior level managers, who may not be expert in sql syntax, would like to work with a tool that understands the business terminology, and helps them in defining what they want.

Avebury Logic Can Help

ISB (Intelligent Scenario Builder) not only has everything you need to build queries, but it is also fine tuned for stock trading environments at Brokerage firms. ISB is designed with non-technical user in mind, who at the beginning, are not sure exactly what they want, but know the direction and where to look for the information. They can start with a snap-shot of data, define part of a selection, see the results and keep refining the queries before bringing clarity to their thinking, and at the same time arriving at a final result set in front of them.

Technical Features

• Easy to use GUI to build queries
• No initial knowledge of SQL required
• Customized column names and meanings to values
• Dynamic switching to different database servers
• Special features for group by and sub query and to build your own expressions
• Save output in Excel format or back to database for further query
• Drag and drop based sorting on multiple columns
• Java based, hence can be used on any platform
• Jdbc connectivity to any database