Reporting and Query Tools and Applications

Reporting and Query Tools and Applications

Tool Categories:

There are five categories of decision support tools

Reporting

Managed query

Executive information system

OLAP

Data Mining

Reporting Tools

Production Reporting Tools

Companies generate regular operational reports or support high volume batch jobs,such as calculating and printing pay checks

Report writers

Crystal Reports/Accurate reporting system

User design and run reports without having to rely on the IS department

Managed query tools

Managed query tools shield end user from the Complexities of SQL and database structures by inserting a metalayer between user and the database

Metalayer :Software that provides subject oriented views of a database and supports point and click creation of SQL

Executive information system

First deployed on main frame system

Predate report writer and managed query tools

Build customized, graphical decision support apps or briefing books

Provides high level view of the business and access to external sources eg custom, on-line news feed

EIS Apps highlight exceptions to business activity or rules by using color-coded graphics

OLAP Tools

Provide an intuitive way to view corporate data

Provide navigation through the hierarchies and dimensions with the single click

Aggregate data along common business subjects or dimensions

Users can drill down across ,or up levels

Data mining Tools

Provide insights into corporate data that are nor easily discerned with managed query or OLAP tools

 Use variety of statistical and AI algorithm to analyze the correlation of variables in data 

^Ø Interesting patterns and relationship to investigate

  a.IBM’s Intelligent Miner

 b. DataMind Corp’s DataMind