CS 2032 DATA WAREHOUSING AND DATA MINING UNIT

  • Slides: 27
Download presentation
CS 2032 DATA WAREHOUSING AND DATA MINING UNIT II BUSINESS ANALYSIS

CS 2032 DATA WAREHOUSING AND DATA MINING UNIT II BUSINESS ANALYSIS

Contents �Reporting and Query tools and Applications �Tool Categories �The Need for Applications �Cognos

Contents �Reporting and Query tools and Applications �Tool Categories �The Need for Applications �Cognos Impromptu �Online Analytical Processing (OLAP) �Need –Multidimensional Data Model �OLAP Guidelines �Multidimensional versus Multirelational OLAP �Categories of Tools �OLAP Tools and the Internet

Reporting and Query Tools and Applications � Tool Categories �Reporting Tools �Managed Query Tools

Reporting and Query Tools and Applications � Tool Categories �Reporting Tools �Managed Query Tools �Executive Information System Tools �OLAP Tools �Data Mining Tools � The Need for Applications � Cognos Impromtu � Applications �Power. Builder �Forte �Information Builder

Reporting Tools �Production Reporting Tools �Let companies generate regular operational reports �Support high volume

Reporting Tools �Production Reporting Tools �Let companies generate regular operational reports �Support high volume batch jobs �Calculating and Printing Paychecks(3 GL) �COBOL, Information Builders, Inc. ’s Focus(4 GL) �MITI’s SQR(High-end Client/Server Tools) �Desktop Report Writers �Let users design and run reports �Graphical Interfaces and Built-in charting functions �Crystal Reports, Actuate Reporting System, IQ objects

Managed Query Tools �Shield end users from the complexities of SQL and database structures

Managed Query Tools �Shield end users from the complexities of SQL and database structures �Meta layer �Support asynchronous query execution �Integrate with web servers �Embed OLAP and Data Mining Features

Executive Information System Tools �Predate report writers and managed query tools �First deployed on

Executive Information System Tools �Predate report writers and managed query tools �First deployed on Mainframes �Allow to build customized, graphical decision support applications �Gives managers and executives a high level view of business and access to external sources �Eg: Pilot Software, Forest and Trees, Comshare, Oracle’s Express Analyzer

OLAP Tools �Provide and intuitive way to view corporate data �Aggregate data along common

OLAP Tools �Provide and intuitive way to view corporate data �Aggregate data along common business objects �Users can drill down, across, or up levels in each dimension

Data Mining Tools �User variety of statistical and artificial-intelligence algorithms �Analyze the correlation of

Data Mining Tools �User variety of statistical and artificial-intelligence algorithms �Analyze the correlation of variables in the data and ferret out interesting patterns and relationships to investigate �Example �IBM’s Intelligent Miner �Data. Mind �Pilot’s Discovery Server �Offers simple UI’s – plug in directly to existing OLAP

The Need for Applications �Access Types to the data �Simple tabular from reporting �Ad

The Need for Applications �Access Types to the data �Simple tabular from reporting �Ad hoc user-specified queries �Predefined repeatable queries �Complex queries �Ranking �Multivariable analysis �Time series analysis �Data visualization, graphing, charting, and pivoting �Complex textual search �Statistical analysis

Cognos Impromptu �Overview �The impromptu Information Catalog �Object-oriented architecture �Reporting �Impromptu Request Server �Supported

Cognos Impromptu �Overview �The impromptu Information Catalog �Object-oriented architecture �Reporting �Impromptu Request Server �Supported Databases

Cognos Impromtu: Overview �Enterprise solution for interactive database reporting �Object oriented architecture �Ensures control

Cognos Impromtu: Overview �Enterprise solution for interactive database reporting �Object oriented architecture �Ensures control and administrative consistency across all users and reports �GUI �Database reporting tool �Supports single user reporting / multi users reporting

Cognos Impromtu: Information Catalog �LAN based repository of business knowledge and data access rules

Cognos Impromtu: Information Catalog �LAN based repository of business knowledge and data access rules �Insulates users from db technical aspects �Protects database �Presents the database in a easy way �Administrators are free to organize database items

Cognos Impromtu: OO Architecture � Drives inheritance based administration and distributed catalogs � Governors

Cognos Impromtu: OO Architecture � Drives inheritance based administration and distributed catalogs � Governors � Activities of Governors �Query activity �Processing location �Database connections �Reporting permissions �User profiles �Client/Server Balancing �Database Transactions �Security by value �Filed and table security

Cognos Impromtu: Reporting � Picklists and prompts � Custom templates � Exception reporting �Conditional

Cognos Impromtu: Reporting � Picklists and prompts � Custom templates � Exception reporting �Conditional filters �Conditional highlighting �Conditional display � Interactive reporting � Frames �List frame �Form frame �Cross-tab frame �Chart frame �Text Frame �Picture Frame �OLE Frame

Cognos Impromtu: Request Server �Allows client to off-load the query process to the server

Cognos Impromtu: Request Server �Allows client to off-load the query process to the server � Scheduling regular and recurring standard reports �Reducing network traffic �Runs on HP/UX 9. X, IBM AIX 4. X, Sun Solaris 2. 4 �Support data maintain in ORACLE 7. x and SYBASE System 10/11

On-Line Analytical Processing(OLAP)(1) �Need for OLAP �Multidimensional Data Model �OLAP Guidelines �Multidimensional versus Multirelational

On-Line Analytical Processing(OLAP)(1) �Need for OLAP �Multidimensional Data Model �OLAP Guidelines �Multidimensional versus Multirelational OLAP �Categorization of OLAP Tools �MOLAP �ROLAP �Managed Query Environment(MQE)

On-Line Analytical Processing(OLAP)(2) �State of the Market �Cognos Power. Play �IBI FOCUS Fusion �Pilot

On-Line Analytical Processing(OLAP)(2) �State of the Market �Cognos Power. Play �IBI FOCUS Fusion �Pilot Software �OLAP Tools and the Internet

OLAP

OLAP

OLAP

OLAP

Multidimensional Data Model �Viewing data as in a cube

Multidimensional Data Model �Viewing data as in a cube

OLAP Guidelines 1. Multidimensional conceptual view 2. Transparency 3. Accessibility 4. Consistent reporting performance

OLAP Guidelines 1. Multidimensional conceptual view 2. Transparency 3. Accessibility 4. Consistent reporting performance 5. Client/server architecture 6. Generic dimensionality 7. Dynamic sparse matrix handling 8. Multiuser support 9. Unrestricted cross-dimensional operations

Categorization of OLAP Tools �MOLAP �ROLAP

Categorization of OLAP Tools �MOLAP �ROLAP

MOLAP

MOLAP

ROLAP

ROLAP

State of the Market �Cognos Power. Play �IBI FOCUS Fusion �Pilot Software

State of the Market �Cognos Power. Play �IBI FOCUS Fusion �Pilot Software

OLAP Tools and the Internet

OLAP Tools and the Internet

END

END

CS 2032 DATA WAREHOUSING AND DATA MINING UNITCS 2032 DATA WAREHOUSING AND DATA MINING UNIT
Data Warehousing Data Warehousing Data Mining and BusinessData Warehousing Data Warehousing Data Mining and Business
Data Warehousing Data Warehousing Data Mining and BusinessData Warehousing Data Warehousing Data Mining and Business
Data Warehousing Data Warehousing Data Mining and BusinessData Warehousing Data Warehousing Data Mining and Business
Data Warehousing Data Warehousing Data Mining and BusinessData Warehousing Data Warehousing Data Mining and Business
Data Warehousing Data Mining Privacy Data Warehousing nData Warehousing Data Mining Privacy Data Warehousing n
WAREHOUSING U CUSTOMS ACT NDER WAREHOUSING Warehousing isWAREHOUSING U CUSTOMS ACT NDER WAREHOUSING Warehousing is
Data Mining FrequentItemset Mining Data Mining Some miningData Mining FrequentItemset Mining Data Mining Some mining
Unit 1 Data Warehousing Introduction to Data WarehousingUnit 1 Data Warehousing Introduction to Data Warehousing
Data Warehousing Data Marting and Metadata DATA WAREHOUSINGData Warehousing Data Marting and Metadata DATA WAREHOUSING
Data Warehousing Mining BI Data Streams Mining DWMBIData Warehousing Mining BI Data Streams Mining DWMBI
Data Warehousing and Decision Support 1 Data WarehousingData Warehousing and Decision Support 1 Data Warehousing
Data Mining What Is Data Mining Data miningData Mining What Is Data Mining Data mining
Data Mining Web Data Mining Web Data MiningData Mining Web Data Mining Web Data Mining
Data Mining Data Mining Simply stated data miningData Mining Data Mining Simply stated data mining
Data Warehousing COT 4810 432008 Data Warehousing oData Warehousing COT 4810 432008 Data Warehousing o
Data Warehousing Introduction to Data Warehousing 1001 DWData Warehousing Introduction to Data Warehousing 1001 DW
Data Warehousing Data Warehousing Make the right decisionsData Warehousing Data Warehousing Make the right decisions
Data Warehousing 1 Basic Concepts of data warehousingData Warehousing 1 Basic Concepts of data warehousing
Data Warehousing Data warehousing provides architectures tools forData Warehousing Data warehousing provides architectures tools for
Data Warehousing Need for Speed Parallelism Data WarehousingData Warehousing Need for Speed Parallelism Data Warehousing
Data Warehousing and Data Mining Chapter 3 DataData Warehousing and Data Mining Chapter 3 Data
Data Mining and Data Warehousing Introduction v DataData Mining and Data Warehousing Introduction v Data
Data Mining Association Rule Mining 2262021 Data MiningData Mining Association Rule Mining 2262021 Data Mining