Home | | Data Ware Housing and Data Mining | Reporting and Query Tools and Applications

Chapter: Data Warehousing and Data Mining : Business Analysis

Reporting and Query Tools and Applications

There are five categories of decision support tools Reporting Managed query Executive information system OLAP Data Mining

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


Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
Data Warehousing and Data Mining : Business Analysis : Reporting and Query Tools and Applications |


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.