Chapter: Data Warehousing and Data Mining : Business Analysis

Need For Applications - Data Warehousing

Some tools and apps can format the retrieved data into easy-to-read reports, while others concentrate on the on-screen presentation

Need For Applications

Some tools and apps can format the retrieved data into easy-to-read reports, while others concentrate on the on-screen presentation As the complexity of questions grows this tools may rapidly become

Inefficient

Consider various access types to the data stored in a data warehouse

Simple tabular form reporting

Ad hoc user specified queries

Predefined repeatable queries

Complex queries with multi table joins ,multilevel subqueries, and sophisticated search criteria

Ranking

Multivariable analysis

Time series analysis

Data visualization, graphing,charting and pivoting

Complex textual search

Statistical analysis

Interactive Drill down reporting an analysis

AI techniques for testing of hypothesis

Information Mapping

Interactive drill-down reporting and analysis

The first four types of access are covered by the combine category of tools we will call query and reporting tools

There are three types of reporting

Creation and viewing of standard reports

Definition and creation of ad hoc reports

Data exploration

Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail

Data Warehousing and Data Mining : Business Analysis : Need For Applications - Data Warehousing |