End User Tools sit over the Data Warehouse/Staging/OLAP (Refer BI Architecture Scenarios), to provide various capabilities for using the information.
Enterprise Reporting Tools
Production Queries and Reports are mostly schedule reports containing transaction level details. There are standard tools (like Crystal) for this purpose. These reporting tools provide an environment to create, produce and distribute reports as well as facility to run ad-hoc detailed queries.
Analytic Applications
Analytic applications undertake slice-dicing, drill up/down, navigation across dimensions and measures, time trending analysis, exceptions, max-min analysis and in many cases what-if analysis as well. It provides many features related to data visualization/presentation and distribution. These analytics are done using the analysis functions within the analytics applications or using the calculation functions available within OLAP.
Data Mining Tools
Data mining tools enable us to discover knowledge and patterns, which we cannot do in analytics application . Data mining tools self discover the information.
Performance Management Tools
Performance Management tools have the dashboard managers and allow you to create scorecards.The Performance Management goes beyond scorecards. Performance Management tools help you to create strategy, set-up targets, Performance Measures & standards.
Decision Modeling Tools
These systems allow you to build business models and use the information as an input. For example you can have a risk profiling system, where you have build models to assess the risk of a Customer. Data-Warehouse (OR mart) could provide the single view Customer information to this system.
|
